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