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