V_EHI_AUDIT_THERAPY

Description: |
Translates THERAPY_AUDIT.

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
Multi-day cycle
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
Order Added
Order Removed
Order Released
Cancel Release
Schedule Changed
Order Changed (Plan)
Order Changed (Day)
Schedule and Order Changed
Due Date Adjustment
Order Reactivated
Signature Expired
Defer Until Date Adjustment
Plan Start Date Adjustment
Order Completed
Order Unsigned
Off Schedule Release - Released Early
Off Schedule Release - Released Additional
Off Schedule Release - New Cycle
Off Schedule Release - Continue Cycle
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 | MIN_TREAT_SEP_HX | INTEGER | No |
Historical record of changes to the minimum treatment separation value for an order.
14 | 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
15 | INTER_DET_DESC_HX | VARCHAR | No |
Stores the changes to the interval details description item. Changes stored for reporting purposes.
16 | NEXT_DUE_DATE | DATETIME | No |
Stores the history of next due date of the linked order.
17 | END_DATE | DATETIME | No |
This item stores the history of end date for an order after which the order should be completed.
18 | NUMBER_OF_RELEASES | INTEGER | No |
Stores the number of times the linked order has been released when calculating due dates.
19 | MANUAL_DUE_DATE | DATETIME | No |
Stores the manual due date of the linked order.
20 | NEXT_DUE_TREATMENT | INTEGER | No |
Stores the next treatment the linked order is due on.
21 | PLAN_OTP_NAME | VARCHAR | No |
The display name of the plan order template.
22 | CONTEXT_OTP_NAME | VARCHAR | No |
The display name of the context order template.