|
Name |
Type |
Discontinued? |
|
1 |
PROBLEM_ID |
VARCHAR |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the PROB_CONTACT column in the PROB_CONTACT table to report on this item instead. Unique identifier for the care plan problem record. |
|
|
2 |
CONTACT_DATE_REAL |
FLOAT |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the CONTACT_DATE_REAL column in the PROB_CONTACT table to report on this item instead. Unique identifier for this contact for this patient. |
|
|
3 |
CONTACT_NUMBER |
VARCHAR |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the CONTACT_NUMBER column in the PROB_CONTACT table to report on this item instead. The serial number of the contact on the care plan problem record. |
|
|
4 |
CONTACT_DATE |
DATETIME |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the CONTACT_DATE column in the PROB_CONTACT table to report on this item instead. The date of this contact in calendar format. |
|
|
5 |
CM_CT_OWNER_ID |
VARCHAR |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the CM_CT_OWNER_ID column in the PROB_CONTACT table to report on this item instead. The Community ID (CID) of the instance that owns this contact. This is populated only if you use IntraConnect. |
|
|
6 |
USER_ID |
VARCHAR |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the PROB_CONTACT column in the PROB_CONTACT table to report on this item instead. Unique identifier of the user who created the contact. Links to table CLARITY_EMP. |
|
|
7 |
USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
8 |
LAST_EDIT_INST |
DATETIME (Local) |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the LAST_EDIT_TIME column in the PROB_CONTACT table to report on this item instead. Instant at which care plan problem was last edited. |
|
|
9 |
IS_RESOLVED_C_NAME |
VARCHAR |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the IS_RESOLVED_C column in the PROB_CONTACT table to report on this item instead. Indicates whether the care plan problem is resolved. 'Y' indicates that the care plan problem is resolved. 'N' or NULL indicate that the care plan problem is not resolved. Links to category list ZC_LPB_IS_RESOLVED. |
May contain organization-specific values: No |
Category Entries: |
YES |
NO |
|
|
10 |
PRIORITY_C_NAME |
VARCHAR |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the CP_PRIORITY_C column in the PROB_CONTACT table to report on this item instead. Care plan problem priority. Links to category list ZC_CP_PRIORITY. |
May contain organization-specific values: Yes |
|
|
11 |
PROB_START_DT |
DATETIME |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the START_DATE column in the PROB_CONTACT table to report on this item instead. Care plan problem start date. |
|
|
12 |
PROB_RESOLV_DT |
DATETIME |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the RESOLVED_DATE column in the PROB_CONTACT table to report on this item instead. Care plan problem resolved date. |
|
|
13 |
CARE_PLAN_CSN |
VARCHAR |
No |
|
|
|
This column no longer populates data for new HH/HSPC problems as of the Epic 2018 release (8.4). Use the CAREPLAN_CSN_ID column in the PROB_CONTACT table to report on this item instead. The unique contact serial number of the care plan problem contact that is associated with the care plan. |
|
|