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