CMGMT_EPISODE_HX
Description:
The history tracks changes made to the case episode for auditing purposes.

Primary Key
Column Name Ordinal Position
EPISODE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 EPISODE_ID NUMERIC No
The unique identifier for the summary block 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 ACTION_C_NAME VARCHAR No
Stores the action taken by the user.
May contain organization-specific values: No
Category Entries:
Update Case Types
Update Case Status
Update Enrolling Step
Update Closed Reason
Update Review Due Date
Update Review Frequency Unit
Update Review Frequency Length
Update Sensitivity
Update Start Date
Update Department
Update Tracking Status
Update Declined Reason
Update End Date
Update Linked Medications
Support & Services Provided changed
Update Enrollment Date
Update Episode Type
Update Referral Link
Update Claim Link
Update Effective Date
Update Termination Date
Update Relationship
Update Primary
Update Linked Problems
Create Case
Review Case
Converted from Tapestry Case
Updated from Case Episode Import
Update Active SDOH
Copied providers from Episode Care Team
Update from Bulk Edit
4 ACTION_USER_ID VARCHAR No
Stores the user that updated the case episode.
5 ACTION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 ASSOC_VALUE_RAW_DATA VARCHAR No
Stores the new value or record associated with the action taken on the case episode.
7 REMOVING_USER_ID VARCHAR No
Stores the user that removed the associated value (I HSB 18440) from the case episode.
8 REMOVING_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 ACTION_UTC_DTTM DATETIME (UTC) No
Stores the date and time (UTC) on which the history action was taken.
10 REMOVED_UTC_DTTM DATETIME (UTC) No
Store the date and time (UTC) on which the associated value (I HSB 18440) was removed from the case episode.
11 ACTION_LOCAL_DTTM DATETIME (Local) No
Stores the date and time (system default time) on which the history action was taken.
12 REMOVED_LOCAL_DTTM DATETIME (Local) No
Stores the date and time (system default time) on which the associated value (I HSB 18440) was removed from the case episode.
13 CASE_TEAM_LINE INTEGER No
Store a line from the case team, if the history value (I HSB 18440) is associated with the case team.
14 ACTION_ENC_CSN_ID NUMERIC No
Case Management History Item - The encounter that set the value on the case episode, if the history value (I HSB 18440) is associated with an encounter.
15 REMOVING_ENC_CSN_ID NUMERIC No
Case Management History Item - The encounter that removed the value on the case episode, if the history value (I HSB 18440) is associated with an encounter.
16 ASSOC_CMGMT_TYPE_C INTEGER No
When the action taken by the user is 1-Update Case Type, this column holds the associated case type value. This column is derived from the Assoc_Value_Raw_Data column.
17 ASSOC_CMGMT_STATUS_C INTEGER No
When the action taken by the user is 2-Update Case Status, this column holds the associated case status value. This column is derived from the Assoc_Value_Raw_Data column.
18 ASSOC_CMGMT_ENROLLING_STEP_C INTEGER No
When the action taken by the user is 3-Update Enrolling Step, this column holds the associated enrolling step value. This column is derived from the Assoc_Value_Raw_Data column.
19 ASSOC_CMGMT_CLOSED_REASON_C INTEGER No
When the action taken by the user is 5-Update Closed Reason, this column holds the associated closed reason value. This column is derived from the Assoc_Value_Raw_Data column.
20 ASSOC_REVIEW_DUE_DATE DATETIME No
When the action taken by the user is 6-Update Review Due Date, this column holds the associated review due date value. This column is derived from the Assoc_Value_Raw_Data column.
21 ASSOC_REV_FREQ_UNIT_C INTEGER No
When the action taken by the user is 7-Update Review Frequency Unit, this column holds the associated review frequency unit value. This column is derived from the Assoc_Value_Raw_Data column.
22 ASSOC_REV_FREQ_LENGTH INTEGER No
When the action taken by the user is 8-Update Review Frequency Length, this column holds the associated review frequency length value. This column is derived from the Assoc_Value_Raw_Data column.
23 ASSOC_CMGMT_SENSITIVITY_C INTEGER No
When the action taken by the user is 9-Update Sensitivity, this column holds the associated sensitivity value. This column is derived from the Assoc_Value_Raw_Data column.
24 ASSOC_CMGMT_TRACKING_STATUS_C INTEGER No
When the action taken by the user is 12-Update Tracking Status, this column holds the associated tracking status value. This column is derived from the Assoc_Value_Raw_Data column.
25 ASSOC_CMGMT_DEPARTMENT_ID NUMERIC No
When the action taken by the user is 11-Update Department, this column holds the associated department ID value. This column is derived from the Assoc_Value_Raw_Data column.
26 ASSOC_CMGMT_END_DATE DATETIME No
When the action taken by the user is 14-Update End Date, this column holds the associated end date value. This column is derived from the Assoc_Value_Raw_Data column.
27 ASSOC_CMGMT_START_DATE DATETIME No
When the action taken by the user is 10-Update Start Date, this column holds the associated start date value. This column is derived from the Assoc_Value_Raw_Data column.
28 ASSOC_CMGMT_DECLINE_REASON_C INTEGER No
When the action taken by the user is 13-Update Declined Reason, this column holds the associated declined reason value. This column is derived from the Assoc_Value_Raw_Data column.
29 ASSOC_CMGMT_MED_PRBLM_LIST_ID NUMERIC No
When the action taken by the user is 15-Update Linked Medications, this column holds the associated medication ID value. This column is derived from the Assoc_Value_Raw_Data column.
30 ASSOC_CMGMT_SSP_CHANGED_LINE INTEGER No
The line number in CMGMT_SUPPORT_TYPE_HX that contains a copy of the previous support & services provided. The updated support and services provided will be in the next line of CMGMT_SUPPORT_TYPE_HX, or in I HSB 64050 if there are no more lines.
31 ASSOC_CMGMT_REFERRAL_ID NUMERIC No
When the action taken by the user is 19-Link Referral, this column holds the associated referral.
32 ASSOC_CMGMT_CLAIM_ID NUMERIC No
When the action taken by the user is 20-Link Claim, this column holds the associated claim.
33 ASSOC_CMGMT_EFF_DATE DATETIME No
When the action taken by the user is 21 - Update Effective Date, this column holds the associated effective date value. This column is derived from the Assoc_Value_Raw_Data column.
34 ASSOC_CMGMT_TERMINATION_DATE DATETIME No
When the action taken by the user is 22 - Update Termination Date, this column holds the associated termination date value. This column is derived from the Assoc_Value_Raw_Data column.
35 ASSOC_CMGMT_TRTMNT_TEAM_REL_C VARCHAR No
When the action taken by the user is 23 - Update Relationship, this column holds the associated case team relationship value. This column is derived from the Assoc_Value_Raw_Data column.
36 ASSOC_CMGMT_IS_PRIMARY_YN VARCHAR No
When the action taken by the user is 24 - Update Primary, this column holds the associated Primary? value. This column is derived from the Assoc_Value_Raw_Data column.
37 ASSOC_CMGMT_PROBLEM_LIST_ID NUMERIC No
When the action taken by the user is 25-Update Linked Problems, this column holds the associated problem ID value. This column is derived from the Assoc_Value_Raw_Data column.