V_EHI_PAX_PB_ACCT_TX_DIST_HX

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 for the transaction distribution history item.
3	DIST_DATE	DATETIME	No
	Date that the payment distribution took place in the system.
4	HIST_PB_INVOICE_ID	VARCHAR	No
	The unique ID of the premium billing invoice associated with the distribution.
5	HIST_PB_ACT_TX_ID	VARCHAR	No
	The unique ID of the account transaction associated with the distribution.
6	HIST_DIST_AMT	NUMERIC	No
	Amount of the distribution.