V_EHI_PTS_PB_TX_SET_EXCEPT

Description:

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

Primary Key

Column Name	Ordinal Position
PB_TXSET_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PB_TXSET_ID	VARCHAR	No
	The unique ID of the premium billing transaction set.
2	LINE	INTEGER	No
	Line counter for the exception on the transaction set.
3	EXCEPT_PB_TX_ID	VARCHAR	No
	The unique ID of the premium billing detailed transaction associated with the exception.
4	EXCEPT_PMT	NUMERIC	No
	Amount actually paid for the exception.
5	EXCEPT_RSN_C_NAME	VARCHAR	No
	Reason for the exception. May contain organization-specific values: Yes
6	EXCEPT_CMT	VARCHAR	No
	Comment associated with the exception.
7	EXCEPT_REM_AMT	NUMERIC	No
	Remaining amount for the exception.