|
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 |
|
|
