COMP_ASMT_FLAGS

Description:

This table contains information about flags that were added to the hospice comprehensive assessment. Comprehensive assessment flags are used to highlight important or unusual information on a specific form in the comprehensive assessment.

Primary Key

Column Name	Ordinal Position
EPISODE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	EPISODE_ID	NUMERIC	No
	The unique identifier for the summary block record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	FLAG_TYPE_C_NAME	VARCHAR	No
	This item stores the flag type for flags added to the comprehensive assessment. May contain organization-specific values: Yes
4	FLAGGED_FORM_ID	NUMERIC	No
	This item stores which form in the comprehensive assessment to which this flag was added.
5	FLAG_ENCOUNTER_CSN	NUMERIC	No
	This item stores a link to the patient contact in which this flag was added.
6	FLAG_COMMENTS	VARCHAR	No
	This item stores free text comments associated with a flag attached to a comprehensive assessment.
7	CREATED_BY_USER_ID	VARCHAR	No
	The user record ID of the user that created this flag.
8	CREATED_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	CREATED_ON_DTTM	DATETIME (UTC)	No
	This item stores the instant at which the flag was created and added to the comprehensive assessment.
10	CLEARED_BY_USER_ID	VARCHAR	No
	The user record ID of the user who cleared or removed the flag from the comprehensive assessment.
11	CLEARED_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
12	CLEARED_ON_DTTM	DATETIME (UTC)	No
	The instant at which this flag was cleared or removed from the comprehensive assessment.