V_EHI_PAX_PB_ACCT_TX_GRP_TTL

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
TRANSACTION_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TRANSACTION_ID	VARCHAR	No
	The unique identifier for the account transaction record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	EMP_GRP_PAX_GRP_ID	VARCHAR	No
	Specifies the employer groups for premium billing acount transactions group total.
4	EMP_GRP_PAX_GRP_ID_PLAN_GRP_NAME	VARCHAR	No
	The name of the employer group record
5	REM_PAX_GRP_TTL_AMT	NUMERIC	No
	Specifies the remaining premium billing account transactions group total amount.