|
Name |
Type |
Discontinued? |
|
1 |
GOAL_ID |
VARCHAR |
No |
|
|
|
The unique identifier for the goal record. |
|
|
2 |
USER_ID |
VARCHAR |
No |
|
|
|
The user ID of the person who entered this goal. |
|
|
3 |
USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
4 |
GOAL_TEMPLATE_ID |
NUMERIC |
No |
|
|
|
Stores the goal template used to create this record |
|
|
5 |
GOAL_TEMPLATE_ID_GOAL_TEMPLATE_NAME |
VARCHAR |
No |
|
|
|
|
6 |
GOAL_TEMPLATE_DAT |
NUMERIC |
No |
|
|
|
Stores the Goal Template Contact |
|
|
7 |
PAT_ID |
VARCHAR |
No |
|
|
|
The unique ID of the patient who is associated with this goal. |
|
|
8 |
CREATE_INST_DTTM |
DATETIME (Local) |
No |
|
|
|
The instant this goal was created. |
|
|
9 |
GOAL_USAGE_C_NAME |
VARCHAR |
No |
|
|
|
Context in which the goal is used. |
May contain organization-specific values: No |
Category Entries: |
Care Plan |
Patient-Oriented |
Pathway |
Home Health/Hospice Care Plan |
Customized Care Plan |
|
|
10 |
REC_VAL_COMPLIAN_YN |
VARCHAR |
No |
|
|
|
Contains a category value denoting whether or not the most recent compliance value is compliant |
May contain organization-specific values: No |
Category Entries: |
Yes |
No |
|
|
11 |
MOST_RECENT_VALUE |
VARCHAR |
No |
|
|
|
Contains the most recent compliance value for the goal |
|
|
12 |
RECENT_VALUE_I_DTTM |
DATETIME (Local) |
No |
|
|
|
The instant that the most recent compliance value was recorded |
|
|
13 |
REC_VALUE_CHEC_DTTM |
DATETIME (Local) |
No |
|
|
|
The instant that this goal was checked to determine its most recent compliance value |
|
|
14 |
AMB_GOAL_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
Ambulatory goal type category (for example, Blood Pressure, Diet, etc.). |
May contain organization-specific values: Yes |
Category Entries: |
Diet |
Exercise |
Weight |
Blood Pressure |
Result Component |
Patient Stated |
Contingency |
General |
|
|
15 |
MYC_CREATE_USER_ID |
VARCHAR |
No |
|
|
|
Stores the ID of patient account record of the MyChart (Epic Patient Portal) user who created the goal. |
|
|
16 |
GOAL_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
The current status of the goal. |
May contain organization-specific values: No |
Category Entries: |
Active |
Done |
Deleted |
|
|