PLAN_HOLD_HISTORY
Description:
The history of all the instances when a treatment plan was put on hold.

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 HX_HOLD_INST_UTC_DTTM DATETIME (UTC) No
A history of when this plan was put on hold. This is the UTC instant when it was put on hold.
4 HX_HOLD_USER_ID VARCHAR No
A history of when this plan was put on hold. This is the user who put the plan on hold.
5 HX_HOLD_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 HX_HOLD_REASON_C_NAME VARCHAR No
A history of when this plan was put on hold. This is the reason for putting the plan on hold.
May contain organization-specific values: Yes
Category Entries:
Admission
Transfer
Discharge
Admitted with OP day
Not admitted with IP day
Plan Created
Protocol Added
Patient Contact Moved
New study version available
Plan Reactivated
Plan Conversion
New study version available
7 HX_HOLD_COMMENT VARCHAR No
A history of when this plan was put on hold. This is the comment for putting the plan on hold.
8 HX_RELEASE_INST_UTC_DTTM DATETIME (UTC) No
A history of when this plan was put on hold. This is the UTC instant when the hold on the plan was released.
9 HX_RELEASE_USER_ID VARCHAR No
A history of when this plan was put on hold. This is the user who released the plan from hold.
10 HX_RELEASE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
11 HX_RELEASE_REASON_C_NAME VARCHAR No
A history of when this plan was put on hold. This is the reason for releasing the hold from the plan.
May contain organization-specific values: Yes
Category Entries:
Admission
Transfer
Discharge
Study version updated
12 HX_RELEASE_COMMENT VARCHAR No
A history of when this plan was put on hold. This is the comment given for releasing the hold from the plan.
13 HX_HOLD_ADT_ID NUMERIC No
If this plan was put on hold because of an ADT event, this will be the ID of that ADT event.
14 HX_HOLD_IS_UNDO_YN VARCHAR No
Whether this hold action was the result of undoing an ADT event.
May contain organization-specific values: No
Category Entries:
No
Yes
15 HX_RELEASE_ADT_ID NUMERIC No
If this plan was released from hold because of an ADT event, this will be the ID of that ADT event.
16 HX_RELEASE_IS_UNDO_YN VARCHAR No
Whether this release from hold action was the result of undoing an ADT event.
The category values for this column were already listed for column: HX_HOLD_IS_UNDO_YN