HSPC_EPSD_BEN_PRDS

Description: |
This table extracts data about hospice benefit periods.

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 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 | BNFT_PRD_START_DATE | DATETIME | No |
This item tracks the start date of each hospice benefit period for the hospice admission associated with the episode.
4 | BNFT_PRD_END_DATE | DATETIME | No |
This item tracks the end date of each hospice benefit period for the hospice admission associated with the episode.
5 | BNFT_PRD_COMMENTS | VARCHAR | No |
This item tracks free text comments about a hospice benefit period.
6 | BNFT_PRD_CTI_ID | VARCHAR | No |
This item tracks the ID of the Certificate of Terminal Illness verbal order that corresponds to this hospice benefit period.
7 | BNFT_PRD_NUM | INTEGER | No |
This item tracks the hospice benefit period number for the hospice admission associated with the episode.
8 | BNFT_PRD_F2F_ID | VARCHAR | No |
The unique identifier of the Face to Face verbal order record that corresponds to this hospice benefit period.
9 | BNFT_PRD_VCTI_DT | DATETIME | No |
The date of the verbal CTI that corresponds to this benefit period.
10 | BNFT_PD_VCTI_SER_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
11 | BT_PD_VCTI_RCVR_ID | VARCHAR | No |
The unique identifier of the user who received the verbal certificate of illness (CTI) from the provider.
12 | BT_PD_VCTI_RCVR_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
13 | BNFT_PRD_2ND_VCTI_DT | DATETIME | No |
The date of the second verbal certificate of terminal illness (CTI).
14 | BNFT_PRD_2ND_VCTI_SER_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
15 | BNFT_PRD_2ND_VCTI_RCVR_ID | VARCHAR | No |
The person who received the second verbal certificate of illness (CTI) from the provider.
16 | BNFT_PRD_2ND_VCTI_RCVR_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
17 | BNFT_PRD_VCTI_NOTE_ID | VARCHAR | No |
The unique identifier of the note record associated with the first verbal CTI for this hospice benefit period.
18 | BNFT_PRD_2ND_VCTI_NOTE_ID | VARCHAR | No |
The unique ID of the note associated with the second verbal Certificate of Terminal Illness.