CL_LEARN_ASSESS_QA
Description:
Enterprise reporting table for learning assessment questions per contact.

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
Line count for the patient learning assessment Questions.
4 CONTACT_DATE DATETIME No
The contact date in external format.
5 TEMPLATE VARCHAR No
The template for the patient learning assessment contact.
6 TOPIC VARCHAR No
Patient learning assessment topic.
7 LA_QUESTION_ID_QUEST_NAME VARCHAR No
The name of the question record.
8 LA_QUESTION_DAT VARCHAR No
Contact date for patient learning assessment question. Stored in internal format.
9 LA_ANSWER VARCHAR No
Answer to the patient learning assessment question. Related to the learning assessment question ID.
10 LA_COMMENT VARCHAR No
Comment to the learning assessment question. Related to the learning assessment question ID.
11 QUESTION_USER_ID VARCHAR No
User ID of the person asking the learning assessment question. Related to the learning assessment question ID.
12 QUESTION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
13 QUESTION_INSTANT DATETIME (Local) No
Date/Time stamp for the instance when the question was asked. Related to the learning assessment question ID.
14 ADD_REPORT_YN VARCHAR No
Response to whether this learning assessment question should be added to the report or not.
May contain organization-specific values: No
Category Entries:
No
Yes
15 TEMPLATE_ID_ILA_RECORD_NAME VARCHAR No
The name for this Learning Assessment Template/Topic record.
16 TOPIC_ID_ILA_RECORD_NAME VARCHAR No
The name for this Learning Assessment Template/Topic record.
17 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.