CL_LEARN_ASSES_OTS

Description: |
It stores information that changes over time, such as patient contact date, whether or not the assessment was verified, and the last time assessment was edited or entered.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
LEARNING_ASSMT_ID | 1 |
CONTACT_DATE_REAL | 2 |

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 | CONTACT_DATE | DATETIME | No |
The contact date in external format.
4 | CONTACT_NUM | VARCHAR | No |
The contact number for the contact.
5 | PAT_DAT | VARCHAR | No |
Patient visit date for the patient learning assessment record contact.
6 | EPT_CSN | NUMERIC | No |
The unique contact serial number of the patient contact to which this patient learning assessment record is associated.
7 | VERIFIED_YN | VARCHAR | No |
Indicates whether the assessment is verified for this contact.
May contain organization-specific values: No
Category Entries:
No
Yes
8 | INSTANT_OF_ENTRY | DATETIME (Attached) | No |
The date and time when the learning assessment was entered.
9 | INSTANT_OF_EDIT | DATETIME (Attached) | No |
The date and time when the learning assessment was edited.
10 | 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.
11 | IS_DELETED_YN | VARCHAR | No |
Indicates whether the assessment is deleted for this contact. Y indicates that the learning assessment is deleted; N or a null value indicates that the learning assessment is not deleted.
The category values for this column were already listed for column: VERIFIED_YN