CL_PLC
Description:
This table extracts the Patient Location (PLC) event tracking information into Clarity. PLC records record information about where a patient was at a certain time. They contain information about where the patient is, when they arrived there, how they got there, and who put them there.

Primary Key
Column Name Ordinal Position
LOCATION_EVNT_ID 1

Column Information
Name Type Discontinued?
1 LOCATION_EVNT_ID NUMERIC No
The unique ID of the patient location event.
2 STATUS_C_NAME VARCHAR No
The status of the location event
May contain organization-specific values: No
Category Entries:
Pending
Confirmed
Canceled
Completed
3 CASE_TRACK_EVENT_C_NAME VARCHAR No
Surgical case tracking event
May contain organization-specific values: Yes
4 PRE_CANCEL_STS_C_NAME VARCHAR No
Holds the status of the record before it was canceled
The category values for this column were already listed for column: STATUS_C_NAME
5 PRIVATE_YN VARCHAR No
Flag denoting whether or not the location event is confidential
May contain organization-specific values: No
Category Entries:
No
Yes
6 SOURCE_ORC_ID VARCHAR No
Source Case ID for the patient location
7 SOURCE_ORL_ID VARCHAR No
Source Log ID for the patient location
8 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
9 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
10 LOCATION_RECORD_ID_RECORD_NAME VARCHAR No
The name of the PLF record.
11 START_TIME DATETIME (Local) No
Confirmed time that a location event occurred
12 CANCELED_TIME DATETIME (Local) No
The time the event record was canceled.
13 END_TIME DATETIME (Local) No
Completion time for the location event
14 COMMENTS VARCHAR No
Free text field for entering comments related to the creation of location event
15 EVENT_TYPE_C_NAME VARCHAR No
This item will log how the patient location (PLC) event was created.
May contain organization-specific values: No
Category Entries:
System Event
Manually Created
Interface - Untrusted
Interface - Trusted