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
Update Linked Medications Information
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
Update from Status Auto-Update
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_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
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.
38 | ASSOC_CMGMT_MED_INFO_LINE | INTEGER | No |
The line number in EPSD_ASSOC_MEDS_HX that contains a copy of the previous associated medications information provided. The updated associated medications information provided will be in the next line of EPSD_ASSOC_MEDS_HX, or in I HSB 48004 and 48007-48009 if there are no more lines.