GOAL
Description:
This table contains data on discrete goals (IGO) records associated with a patient.

Primary Key
Column Name Ordinal Position
GOAL_ID 1

Column Information
Name Type Discontinued?
1 GOAL_ID VARCHAR No
The unique ID for the goal record.
2 GOAL_TYPE_ID VARCHAR No
The unique ID of the goal type associated with this goal.
3 GOAL_TYPE_ID_GOAL_NAME VARCHAR No
The name of the goal type record.
4 PROBLEM_ID VARCHAR No
The unique ID for the problem linked to this goal.
5 DELETED_YN VARCHAR No
Determines if this goal has been deleted.
May contain organization-specific values: No
Category Entries:
Yes
No
6 DISPLAY_NAME VARCHAR No
This column holds the display name of this goal.
7 GOAL_DESC_ID VARCHAR No
This column holds the goal description note's ID.
8 EVALUATION_NOTE_ID VARCHAR No
This column holds the evaluation note ID for this goal.
9 GOAL_TEMPLATE_ID NUMERIC No
This column stores the goal template used to create this record.
10 GOAL_TEMPLATE_ID_GOAL_TEMPLATE_NAME VARCHAR No
The goal template name.
11 GOAL_TEMPLATE_CDR FLOAT No
This column stores contact date real of the goal template contact associated with this goal, stored in Epic's DTE format.
12 HH_EPISODE_ID NUMERIC No
The associated HH/HSPC episode ID for a care plan goal.
13 IS_AUTOGENERATED_YN VARCHAR No
This item determines whether a goal is autogenerated.
May contain organization-specific values: No
Category Entries:
No
Yes