V_EHI_PAX_PB_ACCT_TX

Description:

This view filters out premium billing transaction data that is not appropriate for member level EHI exports when group billing is used.

Primary Key

Column Name	Ordinal Position
PB_ACT_TX_ID	1

Column Information

	Name	Type	Discontinued?
1	PB_ACT_TX_ID	VARCHAR	No
	The unique ID of the premium billing account transaction.
2	TX_AMT	NUMERIC	No
	Amount of the premium billing account transaction.
3	PREV_BAL	NUMERIC	No
	Indicates the previous balance for the premium billing account before the transaction.
4	NEW_BAL	NUMERIC	No
	Indicates the new balance for the premium billing account after the transaction.
5	OUTSTND_AMT	NUMERIC	No
	Specifies the outstanding amount for the transaction.
6	DIST_AMT	NUMERIC	No
	Total distributed amount for the transaction.
7	UNDIST_AMT	NUMERIC	No
	Total undistributed amount for the transaction.
8	CURRENT_BILLING_AMOUNT	NUMERIC	No
	The amount billed for the current period for a billing transaction.
9	RETRO_BILLING_AMOUNT	NUMERIC	No
	The amount billed for prior periods due to retroactivity for a billing transaction.