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