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.