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.