V_EHI_PAX_PB_ACCT_TX_GRP_PMT

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 group payment on the transaction.
3	GP_PAY_PAX_ID	VARCHAR	No
	The unique ID of the account transaction associated with the group payment.
4	GP_PAY_PLAN_GRP_ID	VARCHAR	No
	The unique ID of the employer group associated with the payment.
5	GP_PAY_PLAN_GRP_ID_PLAN_GRP_NAME	VARCHAR	No
	The name of the employer group record
6	GP_PAY_AMT	NUMERIC	No
	Amount of the payment towards the employer group
7	GP_PAY_REMAIN_AMT	NUMERIC	No
	Amount remaining on the transaction for the employer group after payment.