PT_GOALS_INFO

Description: |
This table contains data in the Discrete Goals (IGO) master file that is no-add data.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
GOAL_ID | 1 |

Column Information

| 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 |
The goal template name.
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