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