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