V_EHI_PBI_PB_INVOICE
Description:
This view filters out invoice data that is not appropriate for member level EHI exports when group billing or claims invoicing is used.

Primary Key
Column Name Ordinal Position
INVOICE_ID 1

Column Information
Name Type Discontinued?
1 INVOICE_ID VARCHAR No
The unique ID of the premium billing invoice.
2 INV_BAL_DUE NUMERIC No
Balance due for the invoice.
3 LAST_INV_AMT NUMERIC No
Amount of the last invoice for the premium billing account.
4 BAL_FWD_AMT NUMERIC No
Total balance forward from the last invoice.
5 NEW_ACTV_AMT NUMERIC No
Total amount for new activity included on the invoice, including new credits.
6 NEW_CHRG NUMERIC No
Total new charges included on the invoice.
7 THIS_CYL_AMT NUMERIC No
Total amount of new premium charges for this invoice. This amount does not include retroactive transactions.
8 RETRO_PREM_AMT NUMERIC No
Amount of retroactive premium on the invoice.
9 PREM_ADJ_AMT NUMERIC No
Amount of premium adjustments on the invoice.
10 OTHER_ADJ_AMT NUMERIC No
Amount of other adjustments included on the invoice.
11 TOTAL_PAID_AGAINST NUMERIC No
Total paid against the invoice to date.
12 OUTSTAND_AMT NUMERIC No
Amount outstanding for the invoice. This amount includes unused credits associated with the invoice.
13 OUT_NEW_CHRG NUMERIC No
Outstanding new charges for the invoice. This represents the amount of charge transactions left to be closed in payment posting related to this invoice.
14 OVERPOST_AMT NUMERIC No
Total amount of overposts that appear for the first time on this invoice.
15 AMT_IN_OPEN_PTS NUMERIC No
Amount of payment against this invoice that is currently included in uncommitted payment transaction sets.
16 THIS_CYL_APTC_AMT NUMERIC No
The APTC amount for the current billing cycle.
17 THIS_CYL_LEP_AMT NUMERIC No
This field contains the amount of the Medicare Part D late enrollment penalty for this invoice.
18 SEC_INV_BAL_DUE NUMERIC No
The amount due on the secondary invoice.
19 SEC_INV_NEW_ACTV_AMT NUMERIC No
The amount of charges on the secondary invoice that are new. This includes both the amount for the current cycle, as well as any new charges from retro.
20 SEC_INV_THIS_CYL_AMT NUMERIC No
The amount of premium charges on the secondary invoice. This does not include retro.