V_EHI_PBI_PB_INVOICE_GRP_TTL

Description:

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

Primary Key

Column Name	Ordinal Position
PB_INVC_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PB_INVC_ID	VARCHAR	No
	The unique ID of the premium billing invoice.
2	LINE	INTEGER	No
	Line counter for the group on the invoice.
3	PLAN_GRP_ID	VARCHAR	No
	The unique ID of the employer group associated with the invoice.
4	PLAN_GRP_ID_PLAN_GRP_NAME	VARCHAR	No
	The name of the employer group record
5	GROUP_TOTAL	NUMERIC	No
	Total amount for the group on the invoice.