V_EHI_ORD_LINKED_PATS
Description:
Placeholder view for ORD EHI data that needs to be marked as both static and dynamic.
Primary Key
Column Name
Ordinal Position
ORDER_ID
1
Column Information
Name
Type
Discontinued?
1
ORDER_ID
NUMERIC
No
The unique ID of the order record associated with this procedure order.
2
PAT_ID
VARCHAR
No
The unique ID of the patient record for this order. This column is frequently used to link to the PATIENT table.
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.