PT_GOALS_UPDATES

Description:

This table contains data for the Discrete Goals (IGO) masterfile that is over-time data.

Primary Key

Column Name	Ordinal Position
GOAL_ID	1
CONTACT_DATE_REAL	2

Column Information

	Name	Type	Discontinued?
1	GOAL_ID	VARCHAR	No
	The unique identifier for the goal record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	EDIT_USER_ID	VARCHAR	No
	The user (EMP) ID of the person who entered this data.
5	EDIT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	PAT_CSN	NUMERIC	No
	Patient CSN (contact serial number I.E. unique contact identifier) associated with a particular IGO (goal) contact.
7	STATUS_C_NAME	VARCHAR	No
	Current status of the goal record May contain organization-specific values: No Category Entries: Active Done Deleted
8	INSTNT_OF_EDIT_DTTM	DATETIME (Local)	No
	Instant of edit for this contact. This column no longer populates data for new HH/HSPC care plans as of Epic May 2024. Use the EDIT_INST_DTTM column in PT_GOAL_UPDATES table to report on this item instead.
9	DISPLAY_NAME_OT	VARCHAR	No
	Display name for the goal
10	LOW_VALUE_OVERRIDE	VARCHAR	No
	Low value for the goal value range
11	HIGH_VALUE_OVERRIDE	VARCHAR	No
	High value for goal value range
12	COMPLIANCE_VALUE_NAME	VARCHAR	No
	Current outcome value for the goal. This column stores the manually tracked goal compliance value. May contain organization-specific values: Yes Category Entries: Not on track On track Improving No change Worsening
13	MYC_EDIT_USER_ID	VARCHAR	No
	This item stores the proxy/patient (WPR) ID of the proxy/patient who added or edited a goal from MyChart.
14	PT_STATED_YN	VARCHAR	No
	Indicates whether or not a goal is patient-stated. May contain organization-specific values: No Category Entries: No Yes
15	LONG_RANGE_YN	VARCHAR	No
	Indicates whether the goal is a long-range goal or a short-term goal. The category values for this column were already listed for column: PT_STATED_YN
16	LINKED_LONG_RANGE_ID	VARCHAR	No
	The ID of the long-range goal that this short-term goal is linked to.
17	OUTPAT_PRIORITY_C_NAME	VARCHAR	No
	Outpatient Priority May contain organization-specific values: Yes Category Entries: High Medium Low