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.