PB_ACCT

Description: |
Stores information about Premium Billing accounts.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PB_ACCT_ID | 1 |

Column Information

| 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_LOC_NAME | VARCHAR | No |
The name of the revenue location.
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
20 | ASGN_COLL_USER_ID | VARCHAR | No |
This is the user that is assigned to this account to track and manage their collections process.
21 | ASGN_COLL_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
22 | SEC_PB_FORMAT_ID | VARCHAR | No |
The override setting for the secondary paper invoice format that will be used on the account.
23 | SEC_PB_FORMAT_ID_FORMAT_NAME | VARCHAR | No |
Name of the premium billing invoice format