CL_PLA_EDIT_HX

Description:

Enterprise reporting table that contains the editing history of learning assessment contacts. It identifies the user who edited the assessment.

Primary Key

Column Name	Ordinal Position
LEARNING_ASSMT_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	LEARNING_ASSMT_ID	NUMERIC	No
	The unique ID for the patient learning assessment 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 Counter for the edit instance and editing user of the patient learning assessment record.
4	CONTACT_DATE	DATETIME	No
	The contact date in external format.
5	EDIT_USER_ID	VARCHAR	No
	Record ID for the user who edited the patient learning assessment record contact. It is related to the Edit Instance and is stored in internal ID format. Points to EMP user record.
6	EDIT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	EDIT_INSTANCE	DATETIME (Local)	No
	Date/Time stamp for instance of editing the patient learning assessment record contact. It is related to the Edit User.
8	END_CONT_DATE_REAL	FLOAT	No
	This is a numeric representation of the date of the last 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.
9	EDIT_IS_DELETED_YN	VARCHAR	No
	Indicates whether the learning assessment was deleted in this line in the learning assessment's edit history. Y indicates that the learning assessment was deleted; N or a null value indicates that the learning assessment was not deleted. May contain organization-specific values: No Category Entries: No Yes
10	EDIT_DEL_COMMENT	VARCHAR	No
	The comments entered by the user who deleted the learning assessment.