V_EHI_AUDIT_OTP
Description:
Translates OTP_AUDIT_TRAIL.

Primary Key
Column Name Ordinal Position
OTP_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 OTP_ID NUMERIC No
The unique identifier for the patient order template record.
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 SOURCE_OTP_ID NUMERIC No
Holds the order template ID that is the source for this audit line.
4 UPDATE_ACTION_C_NAME VARCHAR No
Action taken on the order.
May contain organization-specific values: Yes
Category Entries:
Added
Deleted
Post-release modify
Pre-release start time change
Free text sig changed
Unsigned
External order added
Dose change
Other order change
AUC - Target AUC change
AUC - GFR source change
AUC - CrCl formula change
AUC - GFR order-specific value change
AUC - sCr source change
AUC - sCr order-specific value change
ERX replaced by Medication Replacer
Maximum BSA Change
AUC - Use AUC Dose
Conversion Status - Set to Unspecified
Conversion Status - Set to Kept
Conversion Status - Set to Removed
Conversion Status - Set to Replaced
Conversion Status - Set to Replacement
Pharmacy Changed
Sig Type Changed
Scheduling Evaluated
PBS - Script number change
5 UPDATE_COMMENT VARCHAR No
Any additional comment for the updating the order.
6 UPDATE_DTTM DATETIME (Local) No
Time instant at which the order was updated.
7 UPDATE_ORDER_ID NUMERIC No
This item contains the ID of the order that this action refers to.
8 UPDATE_REASON_C_NAME VARCHAR No
Reason for updating the order.
May contain organization-specific values: Yes
Category Entries:
Order created with treatment plan
Initial Value
Deferred
Order created for plan conversion
Build updated
9 UPDATED_BY_ID VARCHAR No
User who updated the order.
10 UPDATED_BY_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
11 UPDATE_OLD_START_DAY VARCHAR No
Stores the old start date of the order.
12 UPDATE_OLD_START_TIME DATETIME (Local) No
Stores the old start time of the order.
13 UPDATE_NEW_START_DAY VARCHAR No
Stores the new start date of the order.
14 UPDATE_NEW_START_TIME DATETIME (Local) No
Stores the new start time of the order.
15 UPDATED_FREE_TEXT_SIG VARCHAR No
Stores the value of the updated free text sig of the order.
16 UPDATED_TARGET_AUC NUMERIC No
Stores the value of the updated target AUC of the order.
17 UPDATED_SELECTED_CRCL_SRC_C INTEGER No
Stores the value of the updated GFR source of the order.
18 UPDATED_GFR_FORMULA_LPP_ID NUMERIC No
Stores the value of the updated GFR formula of the order.
19 UPDATED_GFR_FORMULA_LPP_ID_LPP_NAME VARCHAR No
The name of the extension.
20 UPDATED_GFR_ORDER_SPECIFIC_VAL NUMERIC No
Stores the value of the updated GFR order specific value.
21 UPDATED_SELECTED_SCR_SRC_C INTEGER No
Stores the value of the updated SCR source of the order.
22 UPDATED_SCR_ORDER_SPECIFIC_VAL NUMERIC No
Stores the value of the updated SCR order specific value.
23 UPDATED_MEDICATION_ID_MEDICATION_NAME VARCHAR No
The name of this medication record.
24 UPDATED_MAX_BSA NUMERIC No
Stores the value of the updated maximum BSA of the order.
25 UPDATED_USES_AUC_DOSE_C INTEGER No
Stores if the order uses AUC dosing after the update.
26 UPDATED_PHARMACY VARCHAR No
Stores the value of the updated pharmacy of the order.
27 UPDATE_OLD_MLSIG_SIGTYPE_C INTEGER No
Stores the old sig type of the order.
28 UPDATE_NEW_MLSIG_SIGTYPE_C INTEGER No
Stores the new sig type of the order.
29 UPDATED_SCHEDULING_DURATION INTEGER No
Stores the value of the updated scheduling duration (in minutes) of the order.
30 UPDATED_MEDICATION_NAME VARCHAR No
The name of the medication.
31 UPDATE_ORDER_NAME VARCHAR No
The name of the medication as it appears on the medication record itself.