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