V_EHI_NCS_FILTER_PAT

Description:

This view creates one column of unique patients linked to a communication record.

Primary Key

Column Name	Ordinal Position
COMM_ID	1
PAT_ID	2

Column Information

	Name	Type	Discontinued?
1	COMM_ID	NUMERIC	No
	The unique identifier for the customer service communication.
2	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used by other tables to link to PATIENT.