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