PAT_OR_ADM_LINK
Description:
This table stores the link between encounter ID and the associated log or case ID.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique ID of the patient encounter.
2 PAT_ENC_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 CM_CT_OWNER_ID VARCHAR No
The community ID of the owner of this encounter.
4 OR_LINK_CSN NUMERIC No
The unique contact serial number of the admission linked to the procedural case/log . This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
5 OR_LINK_INP_ID VARCHAR No
The inpatient data ID used by the case and log.
6 OR_SHARE_PERIOP_YN VARCHAR No
Do OR management system Periop activities share data with Inpatient?
May contain organization-specific values: No
Category Entries:
No
Yes
7 OR_SUM_BLOCKS_ID NUMERIC No
The summary block record associated with this surgery.
8 OR_SRC_VISIT_CSN NUMERIC No
This item will store the Contact Serial Number (CSN) for the visit in which this surgery was created.
9 OR_CASELOG_ID VARCHAR No
The unique ID of the procedural case/log. NOTE: Use the CASE_ID or LOG_ID columns to link to the case or log record, respectively. This column should not be used to write reports.
10 UPDATE_DATE DATETIME (Local) No
The date and time when this row was extracted into enterprise reporting.
11 OR_MED_REV_HSB_ID NUMERIC No
The summary block record associated with the medication review workflow. This summary block record will store all of the review history.
12 CASE_ID VARCHAR No
The unique ID of the case (ORC) that is associated with this encounter.
13 LOG_ID VARCHAR No
The unique ID of the log (ORL) that is associated with this encounter.
14 PXPASS_ID NUMERIC No
The unique ID of the Procedure Pass that is associated with this surgical encounter.