CL_PLC_AUDIT
Description:
This table extracts the audit data from a Patient Location (PLC) record.

Primary Key
Column Name Ordinal Position
LOCATION_EVNT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 LOCATION_EVNT_ID NUMERIC No
The unique ID of the location event.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 USER_EDIT_ID VARCHAR No
Item stores the user who made a specific modification to a patient location record.
4 USER_EDIT_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 INST_OF_CHNG_TM DATETIME (Local) No
Item tracks the instant a change was made to the patient location record.
6 ITM_CHANGED INTEGER No
Item that holds which patient location item was modified.
7 OLD_VALUE VARCHAR No
Old value of item to be modified. This is raw data, to get external data look at OLD_PLF_VALUE, OLD_STATUS_VALUE, OLD_EVENT_TYPE_VALUE, AND OLD_TIME_VALUE columns.
8 NEW_VALUE VARCHAR No
New value of item that was modified. This is raw data, to get external data look at NEW_PLF_VALUE, NEW_STATUS_VALUE, NEW_EVENT_TYPE_VALUE, AND NEW_TIME_VALUE columns.
9 CHANGE_SOURCE_C_NAME VARCHAR No
Action that describes how a patient location record was changed.
May contain organization-specific values: Yes
Category Entries:
Manual
Event Management
Admission
Transfer
Discharge
HOV
Update
Sign In
Check In
Check Out
Cancel Check In
Cancel Sign In
Interface
Undo Transfer
Undo Admission
Undo Discharge
Undo Manual Update
Undo HOV
Patient Merge
Patient Unmerge
Room Patient
Removed from Room
Patient Transport
Leave of Absence
Return from Leave of Absence
Undo Leave of Absence
Undo Return from Leave of Absence
RTLS Update
ED Waiting
Undo ED Arrival
Dismiss ED Encounter
Cancel Check Out
Surrounding Event Edit
10 OLD_PLF_VALUE_RECORD_NAME VARCHAR No
The name of the PLF record.
11 NEW_PLF_VALUE_RECORD_NAME VARCHAR No
The name of the PLF record.
12 OLD_STATUS_VALUE INTEGER No
If ITM_CHANGED is 50, then this column stores the old value of the status that was changed.
13 NEW_STATUS_VALUE INTEGER No
If ITM_CHANGED is 50, then this column stores the new value of the status that was changed.
14 OLD_EVENT_TYPE_VALUE INTEGER No
If ITM_CHANGED is 70, then this column stores the old value of the event type that was changed.
15 NEW_EVENT_TYPE_VALUE INTEGER No
If ITM_CHANGED is 70, then this column stores the new value of the event type that was changed.
16 OLD_TIME_VALUE DATETIME (Local) No
If ITM_CHANGED is 221, 222, or 223, then this column stores the old value of the time that was changed.
17 NEW_TIME_VALUE DATETIME (Local) No
If ITM_CHANGED is 221, 222, or 223, then this column stores the new value of the time that was changed.