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.