V_EHI_NMM_CASE_MGMT_STATIC

Description:

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

Primary Key

Column Name	Ordinal Position
CASE_ID	1

Column Information

	Name	Type	Discontinued?
1	CASE_ID	NUMERIC	No
	The unique ID assigned to the case record.
2	PAT_ID	VARCHAR	No
	The unique ID of the patient linked to the case record.
3	CM_LOG_OWNER_ID	VARCHAR	No
	ID of the logical deployment owner for this record. Logical owners show the deployment where the record was created but doesn't represent if the record is a part of version skew.