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.