THERAPY_AUDIT
Description:
This table stores audit information for changes to therapy plans.

Primary Key
Column Name Ordinal Position
TREATMENT_PLAN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 TREATMENT_PLAN_ID NUMERIC No
The unique identifier for the plan 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 PLAN_OTP_ID NUMERIC No
The unique ID of the parent order template record that is affected by the change in this row.
4 INTERVAL_C_NAME VARCHAR No
The category number for the interval. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID).
May contain organization-specific values: No
Category Entries:
Every visit
Weekly
Every two weeks
Monthly
Quarterly
PRN
Once
Every three weeks
Every four weeks
Every five weeks
Every six weeks
Twice per week
Three times per week
Selected dates
Selected treatments
Daily
Every eight weeks
5 REQ_TOTAL_COUNT INTEGER No
The count of treatments requested for the affected order template.
6 START_DATE DATETIME No
The initial date on which the affected order template may be shown to be due.
7 ORDER_CAT_HX_C_NAME VARCHAR No
The category number for order category associated with the order template in this row. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID).
May contain organization-specific values: Yes
Category Entries:
Other
8 CHANGE_DTTM_DTTM DATETIME (Local) No
The date and time when the change audited in this row was made.
9 CHANGE_USER_ID VARCHAR No
The unique ID associated with the user record for this row. This identifies the user making the change audited in this row. This column is frequently used to link to the CLARITY_EMP table.
10 CHANGE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
11 CHANGE_TYPE_C_NAME VARCHAR No
The category number for the type of change audited in this row. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID).
May contain organization-specific values: No
Category Entries:
Propagation - New order
Propagation - Plan to day
Propagation - Day to plan
Added order
Removed order
Released order
Cancel release
Schedule changed
Order changed (plan)
Order changed (day)
Schedule and order changed
Due date adjustment
Reactivated order
Signature expired
Defer until date adjustment
Plan start date adjustment
Completed order
Unsigned order
12 CONTEXT_OTP_ID NUMERIC No
The unique ID of the child order template affected by the change in this row. This value will only be present for certain types of changes.
13 TREAT_DIST_HX_C_NAME VARCHAR No
Category item, stores the changes to the treatment distribution type. Changes stored for reporting purposes.
May contain organization-specific values: No
Category Entries:
Any Day
Specific Days
Specific Day of Month
Specific Day of Week
14 INTER_DET_DESC_HX VARCHAR No
Stores the changes to the interval details description item. Changes stored for reporting purposes.
15 NEXT_DUE_DATE VARCHAR No
Stores the history of next due date of the linked order.
16 END_DATE DATETIME No
This item stores the history of end date for an order after which the order should be completed.