HSPC_ELECTION_DATE_HX
Description:
This table contains the history of the hospice election date.

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 (.1 item) 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 ELECTION_DATE DATETIME No
History of the Hospice Election Date
4 EDIT_UTC_DTTM DATETIME (UTC) No
Instant that the election date was changed
5 EDIT_USER_ID VARCHAR No
User that changed the hospice election date.
6 EDIT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 ELECTION_DATE_RTE_SRC_C_NAME VARCHAR No
This item stores whether the hospice election date was entered manually or pulled from RTE.
May contain organization-specific values: No
Category Entries:
Manual Entry
Pulled from RTE
Set by Conversion, Source Not Available