|
Name |
Type |
Discontinued? |
|
| 1 |
PB_ACCT_ID |
VARCHAR |
No |
|
|
|
| The unique ID for the premium billing account. |
|
|
| 2 |
ACCOUNT_NAME |
VARCHAR |
No |
|
|
|
| Name for the premium billing account. |
|
|
| 3 |
PBA_REC_STAT_C_NAME |
VARCHAR |
No |
|
|
|
| Displays the status of the premium billing account record (i.e. active or deleted). |
| May contain organization-specific values: No |
| Category Entries: |
| Yes |
| No |
|
|
| 4 |
EXT_IDENT |
VARCHAR |
No |
|
|
|
| External ID for the premium billing account. |
|
|
| 5 |
PB_FORMAT_ID |
VARCHAR |
No |
|
|
|
| The unique ID for the premium billing invoice format that is used when printing premium billing invoices for the premium billing account. |
|
|
| 6 |
PB_FORMAT_ID_FORMAT_NAME |
VARCHAR |
No |
|
|
|
| Name of the premium billing invoice format |
|
|
| 7 |
DELINQUENCY_DATE |
DATETIME |
No |
|
|
|
| Date the premium billing account was last delinquent. |
|
|
| 8 |
DELINQUENT_STAT_C_NAME |
VARCHAR |
No |
|
|
|
| Delinquency status of the premium billing account. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Not Delinquent |
|
|
| 9 |
DELINQ_PB_INVC_ID |
VARCHAR |
No |
|
|
|
| The unique ID for the last invoice for which the premium billing account was delinquent. |
|
|
| 10 |
POST_PMT_ON_INV_YN |
VARCHAR |
No |
|
|
|
| This Yes/No flag indicates whether payments should automatically be posted to the premium billing account when the premium billing account is invoiced. |
| The category values for this column were already listed for column: PBA_REC_STAT_C_NAME |
|
|
| 11 |
INDIVIDUAL_BILL_YN |
VARCHAR |
No |
|
|
|
| This Yes/No flag indicates whether this account is an individual billing account. |
| The category values for this column were already listed for column: PBA_REC_STAT_C_NAME |
|
|
| 12 |
UPDATE_DATE |
DATETIME (Local) |
No |
|
|
|
| The extract date and time of the record for this table. |
|
|
| 13 |
OWNING_BUSSEG_ID |
NUMERIC |
No |
|
|
|
| Stores the business segment ID that owns the premium billing account record. |
|
|
| 14 |
AUTO_PAY_ACTIVE_YN |
VARCHAR |
No |
|
|
|
| Indicates whether auto pay is currently active for this account. Y is stored if it is active, N otherwise. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 15 |
AUTO_PAY_CARD_ID |
NUMERIC |
No |
|
|
|
| Stores the unique identifier of the payment card currently being used for auto pay. |
|
|
| 16 |
AUTO_PAY_PAYMENT_DAY |
INTEGER |
No |
|
|
|
| Stores the day of the month auto pay is currently scheduled to occur on. |
|
|
| 17 |
AUTO_PAY_NEXT_PAYMENT_DATE |
DATETIME |
No |
|
|
|
| Stores the next date auto pay is currently scheduled to occur on. |
|
|
| 18 |
ORIGINAL_SUBSCRIBER_PAT_ID |
VARCHAR |
No |
|
|
|
| Stores the original subscriber that an individual account was created for. |
|
|
| 19 |
BUCKET_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
| The account status represents the overall state of an account. This is composite of the premium bucket statuses for the buckets on an account. An account with a status of "New" does not have any transactions filed to it. An account with a status of "Open - Unreconciled" as at least one bucket that has a status of "Open - Unreconciled". An account with the status of "Open - Reconciled" has been fully reconciled and contains transactions that have not been invoiced. An account with a status of "Closed" has all buckets reconciled and invoiced. |
| May contain organization-specific values: No |
| Category Entries: |
| New |
| Open - Unreconciled |
| Open - Reconciled |
| Closed |
|
|
