DOCS_RCVD_GOALS

Description:

This table stores goal information received from outside sources.

Primary Key

Column Name	Ordinal Position
DOCUMENT_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	DOCUMENT_ID	NUMERIC	No
	This item stores the Received Document record ID.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates 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. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	GOAL_REF_ID	VARCHAR	No
	This item stores the unique reference identifier associated with the goal.
6	GOAL_NAME	VARCHAR	No
	This item stores the name of the goal.
7	GOAL_DESC_ID	VARCHAR	No
	This item stores the identifier of the Notes (HNO) record that stores the goal description.
8	GOAL_CREATION_INST_DTTM	DATETIME (Local)	No
	This item stores the instant when the goal was created by the external system.
9	GOAL_RCNT_INST_DTTM	DATETIME (Local)	No
	This item stores the instant when the value of the patient's recent progress for the goal was changed by an external system.
10	GOAL_CONTRIBUTOR_C_NAME	VARCHAR	No
	This item stores the contributor of the goal. May contain organization-specific values: No Category Entries: Provider goal Patient goal Negotiated goal
11	GOAL_SRC_DXR_CSN	NUMERIC	No
	This item stores the contact serial number of the Received Documents record that owns the instance of this goal.
12	GOAL_RECENT_VALUE	VARCHAR	No
	This item stores the value of the patient's recent progress for the goal.
13	GOAL_ID	NUMERIC	No
	This item stores the Discrete Goals Template (IGT) record IDs that maps to the goal.
14	GOAL_ID_GOAL_TEMPLATE_NAME	VARCHAR	No
	The goal template name.
15	GOAL_LST_UPD_INST_DTTM	DATETIME (UTC)	No
	This item stores the last update instant in UTC for the goal.
16	GOAL_TYPE_C_NAME	VARCHAR	No
	This item stores the goal type. May contain organization-specific values: Yes Category Entries: Diet Exercise Weight Blood Pressure Result Component Patient Stated Contingency General
17	GOAL_VAL_COMP_YN	VARCHAR	No
	This item stores the whether the goal recent value is compliant. May contain organization-specific values: No Category Entries: No Yes
18	GOAL_CATEGORY_C_NAME	VARCHAR	No
	This column stores the categorization of the goal. It will be null if the category cannot be determined. May contain organization-specific values: No Category Entries: General Social Determinants of Health