BEREAVED_INFO
Description:
This table contains information about your bereaved records. These include name, address, phone numbers, and associated patients. The records included in this table are Bereavement Contact (LHB) records.

Primary Key
Column Name Ordinal Position
RECORD_ID 1

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique identifier for the bereavement contact record.
2 RECORD_NAME VARCHAR No
The name of the bereavement contact record.
3 RECORD_STATUS_C_NAME VARCHAR No
The record status, such as active or soft-deleted.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
4 BEREAVE_STATUS_C_NAME VARCHAR No
The status of the bereavement contact.
May contain organization-specific values: No
Category Entries:
Pre-death
Active
Resolved
Deleted
5 BEREAVEMENT_HSB_ID NUMERIC No
The unique identifier for the hospice episode of care record associated with the bereaved.
6 BEREAVEMENT_EPT_ID VARCHAR No
The unique identifier for the patient record associated with the bereaved.
7 BEREAVEMENT_CITY VARCHAR No
The city of the bereavement contact's address.
8 BEREAVEMENT_STATE_C_NAME VARCHAR No
The state of the bereavement contact's address.
May contain organization-specific values: Yes
9 BEREAVEMENT_ZIP VARCHAR No
The zip code of the bereavement contact's address.
10 BEREAVE_COUNTRY_C_NAME VARCHAR No
The country of the bereavement contact's address.
May contain organization-specific values: Yes
11 BEREAVEMENT_HPHONE VARCHAR No
The home phone number for the bereavement contact.
12 BEREAVEMENT_WPHONE VARCHAR No
The work phone number for the bereavement contact.
13 BEREAVEMENT_MPHONE VARCHAR No
The mobile phone number for the bereavement contact.
14 BEREAVED_RELATION_C_NAME VARCHAR No
The relationship of the bereavement contact to the patient.
May contain organization-specific values: Yes
15 BEREAVEMENT_EMAIL VARCHAR No
The email address for the bereavement contact.
16 BEREAVEMENT_CMNTS VARCHAR No
Comments entered by the user to record miscellaneous information about the bereaved.
17 SEX_C_NAME VARCHAR No
The gender of the bereavement contact.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
18 BIRTH_DATE_DT DATETIME No
The date of birth of the bereavement contact.
19 PRIMARY_LANGUAGE_C_NAME VARCHAR No
The primary language of the bereavement contact.
May contain organization-specific values: Yes
20 RECORD_CREATION_DT DATETIME No
The date the bereavement contact record was created.
21 INSTANT_OF_UPD_DTTM DATETIME (Local) No
The instant the record was last locked or unlocked.
22 RISK_LEVEL_C_NAME VARCHAR No
Risk level of the bereaved.
May contain organization-specific values: No
Category Entries:
Low
Medium
High
23 LAST_ADDRESS_LBL_PRINT_DTTM DATETIME (Local) No
The instant the bereaved address label was last printed.
24 UNLINK_DEPT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
25 GENDER_C_NAME VARCHAR No
The gender identity of the bereaved.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Transgender Female
Transgender Male
Other
Choose not to disclose
Nonbinary
Genderqueer
26 COMMBRV_PAT_NAME VARCHAR No
The name of the individual for whom the bereaved is grieving. This column is only populated for Community Bereavement records. In order to link to patients using non-Community Bereavement records, use the column BEREAVED_INFO.BEREAVEMENT_EPT_ID.
27 COMMBRV_PAT_LEGAL_SEX_C_NAME VARCHAR No
The legal sex of the individual for whom the bereaved is grieving. This column is only populated for Community Bereavement records.
The category values for this column were already listed for column: SEX_C_NAME
28 COMMBRV_PAT_BIRTH_DATE DATETIME No
The date of birth of the individual for whom the bereaved is grieving. This column is only populated for Community Bereavement records.
29 COMMBRV_PAT_DEATH_DATE DATETIME No
The date of death of the individual for whom the bereaved is grieving. This column is only populated for Community Bereavement records.
30 COMMBRV_PAT_STATUS_C_NAME VARCHAR No
The status (alive, deceased, etc) of the individual for whom the bereaved is grieving. This column is only populated for Community Bereavement records.
May contain organization-specific values: Yes
Category Entries:
Alive
Deceased
31 COMMBRV_PAT_GENDER_C_NAME VARCHAR No
The gender identity of the individual for whom the bereaved is grieving. This column is only populated for Community Bereavement records.
The category values for this column were already listed for column: GENDER_C_NAME