V_EHI_PBI_FILTER_STATIC

Description:

This view supports extracting RTF data for EHI from the invoice masterfile.

Primary Key

Column Name	Ordinal Position
INVOICE_ID	1
PAT_ID	2

Column Information

	Name	Type	Discontinued?
1	INVOICE_ID	VARCHAR	No
	The unique identifier (.1 item) for the invoice record.
2	PAT_ID	VARCHAR	No
	This item contains the subscriber patient Id of a coverage and will be used to associate patients with linked premium billing accounts for EHI.
3	CM_LOG_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.