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