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	VARCHAR	No
	Record ID for patient learning assessment question. Stored in internal ID format and links to LQL master file.
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	NUMERIC	No
	Record Id for the learning assessment template(ILA). Stored in internal format and links to ILA master file. Related to the learning assessment question ID.
16	TOPIC_ID	NUMERIC	No
	Record Id for the learning assessment topic(ILA). Stored in internal format and links to ILA master file. Related to the learning assessment question ID.
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.