HH_EPSD_EVNT_DATES

Description: |
This table contains event dates information for Home Health episodes. This information can be entered manually in the Episode of Care Information form in Intake. For certain events, such as Admit, Discharge, and SOC, the information is triggered automatically.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SUMMARY_BLOCK_ID | NUMERIC | No |
Unique identifier for the episode.
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 | DATE_OF_EVENT | DATETIME | No |
Date of event in the episode.
4 | DATE_EVENT_C_NAME | VARCHAR | No |
Category list selection for event on this date. Links to category table ZC_DATE_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 | DATE_ENTERED_BY_ID | VARCHAR | No |
ID of the user who entered the event. Links to CLARITY_EMP.
6 | DATE_ENTERED_BY_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | EVENT_COMMENTS | VARCHAR | No |
Comments text typed in by a user.
8 | EVENT_CREAT_DTTM | DATETIME (UTC) | No |
Stores the time and date when an event type was created for the first time for a Home Care episode.
9 | EVENT_UPDATE_DTTM | DATETIME (UTC) | No |
Stores the time and date when an event type was last updated for a Home Care episode. If an event is not updated after being created then this item will contain the same value as Summary Block / Episode record (HSB) 27408.
10 | LAST_UPDATE_USER_ID | VARCHAR | No |
The unique ID associated with the user who most recently edited the event in this row. This column is frequently used to link to the CLARITY_EMP table.
11 | LAST_UPDATE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.