CL_PATEDU_CT_HIST
Description:
Enterprise reporting table for contact specific education history items in Patient Education (PED) records.

Primary Key
Column Name Ordinal Position
PED_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 PED_ID NUMERIC No
The Unique ID for the Patient Education Record.
2 CONTACT_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 LINE INTEGER No
The Line Count for contact specific history detail.
4 CONTACT_DATE DATETIME No
Date of contact for contact specific history detail.
5 CONTACT_HX_KEY VARCHAR No
The education key for the contact-specific history record. The education key is a string in the form of Title^Topic^Point.
6 CONTCT_HX_TOPIC_ID_TTP_NAME VARCHAR No
The name of the Title/Topic/Point.
7 CONTCT_HX_POINT_ID VARCHAR No
The unique ID of the education point for which the status was changed. The rest of the columns in each record contain the information related to this status change.
8 CONTACT_HX_STATUS_NAME VARCHAR No
This category value is the status of the education point. The possible status entries are as follows: 1. Active 2. N/A 3. Done 4. Deleted This column is a foreign key reference to ZC_PED_CT_STATUS__PED_CT_STATUS_C.
May contain organization-specific values: No
Category Entries:
Active
N/A
Done
Deleted
Not Started
In Progress
9 CONTACT_HX_EDIT_IN DATETIME (Local) No
The date and time the education point was documented on.
10 CONTACT_HX_USER_ID VARCHAR No
The unique ID of the user who performed the documentation associated with each record in the contact-specific history.
11 CONTACT_HX_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 CONT_HX_TITLE_DAT INTEGER No
The contact date (DAT) of the contact where the patient education history title was documented.
13 CONT_HX_TOPIC_DAT INTEGER No
The contact date (DAT) of the contact where the patient education history topic was documented.
14 CONT_HX_POINT_DAT INTEGER No
The contact date (DAT) of the contact where the patient education history point was documented.
15 CONTACT_HX_DOC_SRC_C_NAME VARCHAR No
This category value is the platform/workflow that triggered the change in the learning status of the education title, topic or point. The possible status entries are as follows: 1. Patient Education 2. Care Plan 3. Doc Flowsheet 4. Order 5. Order Set 6. Pathway 7. Task Template 8. Interface 9. Patient Assigned Task 10. Utility 11. Rover Patient Education 12. Haiku Patient Education
May contain organization-specific values: No
Category Entries:
Patient Education
Care Plan
Doc Flowsheet
Order
Order Set
Pathway
Task Template
Interface
Patient Assigned Task
Utility
Rover Patient Education
Haiku Patient Education