|
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 |
|
|
|
|
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 |
|
|