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
Cancel Room Patient
Cancel Appointment
Auto Back in Bed
No Show
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.