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_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.