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