V_EHI_PAX_PB_ACCT_TX_PMT_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
LINE	2

Column Information

	Name	Type	Discontinued?
1	PB_ACT_TX_ID	VARCHAR	No
	The unique ID of the premium account transaction.
2	LINE	INTEGER	No
	Line counter of the payment on the transaction.
3	HIST_PB_ACT_TX_ID	VARCHAR	No
	The unique ID of the premium account transaction used as a payment against this premium account transaction.
4	PMT_AMT	NUMERIC	No
	Amount of the payment transaction applied towards this premium account transaction.
5	REMAINING_AMT	NUMERIC	No
	Amount remaining on the premium account transaction after the payment has been applied.
6	PAYMENT_REV_LINE	INTEGER	No
	Specifies the payment history reversed line.