V_EHI_PTS_PB_TX_SET

Description:

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

Primary Key

Column Name	Ordinal Position
PB_TXSET_ID	1

Column Information

	Name	Type	Discontinued?
1	PB_TXSET_ID	VARCHAR	No
	The unique ID of the premium billing transaction set.
2	PMT_AMT	NUMERIC	No
	Amount of the payment.
3	TX_SET_TOTAL	NUMERIC	No
	Total amount of outstanding transactions to be closed in the transaction set.
4	TOTAL_CREDIT	NUMERIC	No
	Total credits for the transaction set.
5	NET_EXCEPT	NUMERIC	No
	Amount for net exceptions from the transaction set.
6	NET_DIFF	NUMERIC	No
	Net difference for the transaction set. This represents the amount that still needs to be balanced in the transaction set.
7	BAL_FWD_AMT	NUMERIC	No
	Balance forward amount for the transaction set.
8	ADJ_AMOUNT	NUMERIC	No
	This field stores the total adjustment amount for this transaction set.