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
Update Complexity
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
Update Medication Access Linked Clinical Episode
Update Medication Access Linked Class
Update Medication Access Linked Episode Type
Update Medication Access Decision Due Date
Update Medication Access Treatment Start Date
Update Medication Access Linked Product
Update Medication Access Linked Authorization
Update Medication Access Site of Care Information
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.
39 | ASSOC_CMGMT_COMPLEXITY_C | INTEGER | No |
When the action taken by the user is 27-Update Complexity, this column holds the associated complexity value. This column is derrived from the Assoc_Value_Raw_Data column.
40 | ASSOC_RXMA_EPISODE_ID | NUMERIC | No |
When the action taken by the user is 1200-Update Medication Access Linked Clinical Episode, this column holds the associated Medication Access linked clinical episode value. This column is derived from the Assoc_Value_Raw_Data column.
41 | ASSOC_RXMA_CLS_C | INTEGER | No |
When the action taken by the user is 1201-Update Medication Access Linked Class, this column holds the associated Medication Access linked class value. This column is derived from the Assoc_Value_Raw_Data column.
42 | ASSOC_RXMA_BLOCK_DEF_ID_EPISODE_DEF_NAME | VARCHAR | No |
This column displays the name of the episode / block definition record.
43 | ASSOC_RXMA_DCN_DATE | DATETIME | No |
When the action taken by the user is 1203-Update Medication Access Decision Due Date, this column holds the associated Medication Access decision due date value. This column is derived from the Assoc_Value_Raw_Data column.
44 | ASSOC_RXMA_TX_START_DATE | DATETIME | No |
When the action taken by the user is 1204-Update Medication Access Treatment Start Date, this column holds the associated Medication Access treatment start date value. This column is derived from the Assoc_Value_Raw_Data column.
45 | ASSOC_RXMA_MEDICATION_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
46 | ASSOC_RXMA_REFERRAL_ID | NUMERIC | No |
When the action taken by the user is 1206-Update Medication Access Linked Authorization, this column holds the associated Medication Access linked authorization value. This column is derived from the Assoc_Value_Raw_Data column.
47 | ASSOC_RXMA_SOC_INFO_LINE | INTEGER | No |
The line number in RXMA_SITE_OF_CARE_HX that contains a copy of the previous site of care information provided. The updated site of careinformation provided will be in the next line of RXMA_SITE_OF_CARE_HX, or in I HSB 48830-48836 if there are no more lines.