DELINQUENCY_HISTORY
Description:
The DELINQUENCY HISTORY table stores information about the history of delinquency on a premium billing account. It stores the new delinquency status, delinquency date, relevant invoice, workflow that set the information, and links to relevant records.

Primary Key
Column Name Ordinal Position
PB_ACCT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PB_ACCT_ID VARCHAR No
The unique identifier (.1 item) for the account record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 DLQ_HX_INST_UTC_DTTM DATETIME (UTC) No
The UTC instant that the delinquency information changed.
4 DLQ_HX_UPD_ACCT_DQ_STS_C_NAME VARCHAR No
The Delinquency Status category ID for the premium billing account.
May contain organization-specific values: Yes
Category Entries:
Not Delinquent
5 DLQ_HX_LAST_PB_INVC_ID VARCHAR No
The unique ID of the delinquency history premium billing invoice.
6 DLQ_HX_EPSD_DATE DATETIME No
The date of the premium billing accounts delinquency episode began.
7 DLQ_HX_USER_ID VARCHAR No
The unique ID associated with the user record for this row. This column is frequently used to link to the CLARITY_EMP table.
8 DLQ_HX_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 DLQ_HX_WORKFLOW_C_NAME VARCHAR No
The Delinquency History - Workflow category ID for the premium billing account.
May contain organization-specific values: No
Category Entries:
Account Info
Account Activities
Reporting Workbench Action
Automatic Action
Task Executed
Import
Invoice Cancel
10 DLQ_HX_EVENT_ID VARCHAR No
The unique ID of the event that caused a change in delinquency information.
11 DLQ_HX_EVENT_ID_EVENT_NAME VARCHAR No
The name of the event.
12 DLQ_HX_PAYMENT_ID VARCHAR No
The unique ID of the payment associated with the change in deliquency information.