|
Name |
Type |
Discontinued? |
|
1 |
ORDER_MED_ID |
NUMERIC |
No |
|
|
|
The unique ID of the medication order (prescription) record. NOTE: This is an internal unique identifier for ORD master file records in this table and cannot be used to link to CLARITY_MEDICATION. |
|
|
2 |
LINE |
INTEGER |
No |
|
|
|
The line number for each change. |
|
|
3 |
VALUE_LINE |
INTEGER |
No |
|
|
|
A value is needed. For multiple response item, it is the line number for each real data or 0 for total count line. For single response item, it is 1. |
|
|
4 |
AUDIT_LOCAL_DTTM |
DATETIME (Local) |
No |
|
|
|
|
5 |
OLD_VALUE_INTERNAL |
VARCHAR |
No |
|
|
|
For audited items which store a networked record ID, this column will extract the CID of the linked record in OLD_VALUE. For other items this will extract the same value as OLD_VALUE. |
|
|
6 |
NEW_VALUE_INTERNAL |
VARCHAR |
No |
|
|
|
For audited items which store a networked record ID, this column will extract the CID of the linked record in NEW_VALUE. For other items this will extract the same value as NEW_VALUE. |
|
|
7 |
OLD_VALUE_EXTERNAL |
VARCHAR |
No |
|
|
|
The old value of the item in external format. Dates, categories, and networked items will display meaningful information instead of the internal value. |
|
|
8 |
NEW_VALUE_EXTERNAL |
VARCHAR |
No |
|
|
|
The new value of the item in external format. Dates, categories, and networked items will display meaningful information instead of the internal value. |
|
|
9 |
CHANGED_DATA_ELEMENT |
VARCHAR |
No |
|
|
|
The Clarity table and column which corresponds to the data which changed. |
|
|
10 |
CHANGE_USER_ID |
VARCHAR |
No |
|
|
|
The unique user ID who made the change. |
|
|
11 |
CHANGE_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|