HH_EPSD_EVNT_HX

Description: |
This contains audit information about the event of an episode.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SUMMARY_BLOCK_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SUMMARY_BLOCK_ID | NUMERIC | No |
The unique identifier for the episode 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 | EVENT_HX_DATE | DATETIME | No |
History of the date of the event in the episode
4 | DATE_EVENT_C_NAME | VARCHAR | No |
History of the category list selection for the event.
May contain organization-specific values: Yes
Category Entries:
Intake Completed
Start of Care
Assessment
Resumption of Care
Cert Period Start
Cert Period End
Episode Created
Coverage Change Start of Care
Alternative Billing Start Date for Cutover
MCCM Election
Notice of Admission Date for Cutover
Inpatient Discharge
Home Health Discharge
Demographic Update
Discard Episode
MCCM Discharge
Undo HH Discharge
Undo Discard Episode
Undo MCCM Discharge
Hospice Admission
Undo Hospice Admission
Undo Intake Completed
Hospice Discharge
Undo Hospice Discharge
Hospice Non-Admit
Undo Hospice Non-Admit
Agency Discharge Approved
5 | ENTERED_BY_USER_ID | VARCHAR | No |
History of the user IDs who entered the event.
6 | ENTERED_BY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | EVENT_COMMENT_HX | VARCHAR | No |
History of the comments left about this event.
8 | EDIT_USER_ID | VARCHAR | No |
The user who made the edits to the event data.
9 | EDIT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
10 | EDIT_UTC_DTTM | DATETIME (UTC) | No |
The instant at which edits were made to the event data. .
11 | EDIT_LINE | INTEGER | No |
The line number of the event that was edited. This is the line number found in column LINE of HH_EPSD_EVNT_DATES.