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	VARCHAR	No
	The unique ID of the education topic record which is used to retrieve the contact-specific history for the education point in this record. If the education point is directly beneath the title then this value is null.
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