BEREAVE_FOL_STATUS

Description:

This table contains information about your bereaved follow-up record's status. These include planned and completed dates, record status, user ID, and user comment. The records included in this table are Bereavement Follow-Up (LHC) records.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
CONTACT_DATE_REAL	2

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	The unique identifier for the bereavement follow-up record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date, in decimal format, where the integer portion represents the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	CONTACT_SERIAL_NUM	NUMERIC	No
	The contact serial number (CSN) of the contact.
5	CONTACT_NUM	INTEGER	No
	Contact number
6	CM_CT_OWNER_ID	VARCHAR	No
	Stores the Community ID (CID) of the instance that owns this contact
7	FOLLOW_UP_PLANNED_DT	DATETIME	No
	Planned date for bereavement follow-up.
8	FOLLOW_UP_COMP_DT	DATETIME	No
	Completion date for bereavement follow-up.
9	FOLLOW_UP_COMP_DTTM	DATETIME (Local)	No
	Instant bereavement follow-up filed.
10	FOLLOW_UP_USER_ID	VARCHAR	No
	User entering bereavement follow-up.
11	FOLLOW_UP_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
12	FOLLOW_UP_STAT_C_NAME	VARCHAR	No
	Status of bereavement follow-up. May contain organization-specific values: No Category Entries: Planned Completed Deleted
13	FOLLOW_UP_CONT_CMT	VARCHAR	No
	Comment related to follow-up contact.
14	INSTANT_OF_ENT_DTTM	DATETIME (Local)	No
	Stores the instant of entry when a record is edited
15	FOLLOW_UP_RISK_C_NAME	VARCHAR	No
	Risk level related to follow-up contact. May contain organization-specific values: No Category Entries: Low Medium High
16	FOL_UP_LET_LST_PRNT_DTTM	DATETIME (Local)	No
	The instant the follow-up letter was last printed.
17	FOLLOW_UP_OWNER_PROV_ID	VARCHAR	No
	The unique ID associated with the person responsible for the bereavement follow-up. This ID is frequently used to link to the CLARITY_SER table.