BEREAVE_FOL_INFO

Description: |
This table contains information about your bereaved's follow-up record. These include bereaved record link, follow-up type, and follow-up form. The records included in this table are Bereavement Follow-Up (LHC) 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 follow-up record.
2 | 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
3 | BEREAVED_ID | NUMERIC | No |
The unique identifier for the bereaved record linked to this bereavement follow-up.
4 | PAT_CSN | NUMERIC | No |
The contact serial number of the contact in a patient record in which the bereavement follow-up was documented.
5 | FORM_ID | VARCHAR | No |
The unique identifier of the custom interface (SmartForm) record that is used to document the bereavement follow-up.
6 | FORM_ID_FORM_NAME | VARCHAR | No |
The name of the form associated with the questionnaire.
7 | FORM_DAT | VARCHAR | No |
The contact date (DAT) of the custom interface (SmartForm) record that is used to document the bereavement follow-up.
8 | FOLLOW_UP_TYPE_C_NAME | VARCHAR | No |
Type of documentation in bereavement follow-up.
May contain organization-specific values: Yes
Category Entries:
Assessment
9 | RECORD_CREATION_DT | DATETIME | No |
The date the record was created
10 | INSTANT_OF_UPD_DTTM | DATETIME (Local) | No |
The instant the record was last locked/unlocked
11 | PAT_ID | VARCHAR | No |
The ID of the patient associated with the bereaved.