V_EHI_PBA_PB_ACCT

Description: |
This view filters out account data that is not appropriate for member level EHI exports when group billing is used.

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 | BILL_ADDR1 | VARCHAR | No |
Street address line 1 for premium billing account billing address.
3 | BILL_ADDR2 | VARCHAR | No |
Street address line 2 for premium billing account billing address.
4 | BILL_CITY | VARCHAR | No |
City for premium billing account billing address.
5 | BILL_STATE_C_NAME | VARCHAR | No |
State for premium billing account billing address.
May contain organization-specific values: Yes
6 | BILL_ZIP | VARCHAR | No |
ZIP Code for premium billing account billing address.
7 | BILL_COUNTY_C_NAME | VARCHAR | No |
County for premium billing account billing address.
May contain organization-specific values: Yes
8 | BILL_COUNTRY_C_NAME | VARCHAR | No |
Country for premium billing account billing address.
May contain organization-specific values: Yes
9 | BILL_PHONE | VARCHAR | No |
Billing phone number for premium billing account.
10 | BILL_FAX | VARCHAR | No |
Billing fax number for premium billing account.
11 | BILL_EMAIL | VARCHAR | No |
Billing e-mail address for premium billing account.
12 | INVMSG_NOTE_ID | VARCHAR | No |
The unique ID of note to be included on premium billing invoices for the premium billing account.
13 | BAL_DUE | NUMERIC | No |
Balance due for the premium billing account.
14 | HIX_ACCT_BAL_DUE | NUMERIC | No |
This item contains the subscriber's portion of the balance due on the associated group premium billing account.
15 | TOTAL_BAL_DUE | NUMERIC | No |
This item contains the total of the account balance plus the subscriber's portion of the balance due on the associated group premium billing account.
16 | AR_ACCT_BALANCE | NUMERIC | No |
The account balance stores the sum of all transaction amounts for transactions that have filed to the account.
17 | BILL_HOUSE_NUM | VARCHAR | No |
House number for premium billing account billing address.
18 | BILL_DISTRICT_C_NAME | VARCHAR | No |
District for the premium billing account billing address.
May contain organization-specific values: Yes