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