CL_PAT_EDU_LEARNER
Description:
Enterprise reporting table for Contact specific Learner items in Patient education Record.

Primary Key
Column Name Ordinal Position
PED_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 PED_ID NUMERIC No
The unique ID for the patient education 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 count for contact specific learner items in the patient education record.
4 CONTACT_DATE DATETIME No
The contact date for contact specific learner items in patient education record.. Store in external format.
5 LEARNER_KEY VARCHAR No
The key for contact specific learner items in patient education record.
6 LEARNER_C_NAME VARCHAR No
The learner category for contact specific learner items in patient education record.
May contain organization-specific values: Yes
Category Entries:
Patient
Family
Significant Other
Caregiver
Other
7 READINESS_C_NAME VARCHAR No
The learner readiness category for contact specific learner items in patient education record.
May contain organization-specific values: Yes
Category Entries:
Eager
Acceptance
Nonacceptance
Refuses
8 TEACHING_METHOD VARCHAR No
The method of teaching for contact specific learner items in patient education record.
9 RESPONSE VARCHAR No
The learner response for contact specific learner items in patient education record.
10 TAUGHT_BY_USER_ID VARCHAR No
The teaching user ID for contact specific learner items in patient education record. It is stored in internal ID format and is linked to the user master file.
11 TAUGHT_BY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 TAUGHT_AT_INS DATETIME (Local) No
Date/Time stamp for the instance of teaching for contact specific learner items in patient education record.
13 STATUS_C_NAME VARCHAR No
The status category for contact specific learner items in patient education record.
May contain organization-specific values: No
Category Entries:
Active
N/A
Done
Deleted
Not Started
In Progress
14 ENTER_BY_USER_ID VARCHAR No
User ID of the user who added the point associated with the row of learning.
15 ENTER_BY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
16 ENTER_AT_INS DATETIME (Local) No
The data entry instant for contact specific learner items in patient education record.
17 LEARNER_COMMENT VARCHAR No
The learner's comment- contact specific.
18 DELETED_BY_USER_ID VARCHAR No
The ID number of the user who deleted the contact specific learner items in the patient education record.
19 DELETED_BY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
20 DELETED_AT_INS DATETIME (Local) No
The instant of deletion for contact specific learner items in patient education record.
21 TITLE_ID_TTP_NAME VARCHAR No
The name of the Title/Topic/Point.
22 TOPIC_ID_TTP_NAME VARCHAR No
The name of the Title/Topic/Point.
23 POINTS_IED_ID_TTP_NAME VARCHAR No
The name of the Title/Topic/Point.
24 MY_POINTS_HNO_ID VARCHAR No
The first part of the unique ID of the patient education My Point record that is associated with this row of documentation. My Point is a patient education point created on the fly and does not have an education (IED) record associated with it. Note that this column is only populated for My Point records. This column is frequently used (along with MY_POINTS_HNO_DAT) to link to tables such as CL_PAT_EDU_POINT (via MY_POINT_HNO_ID) and CL_PATEDU_CNTCT_PT (via CNT_MYPOINT_HNO_ID).
25 MY_POINTS_HNO_DAT VARCHAR No
The second part of the unique ID of the patient education My Point record that is associated with this row of documentation. My Point is a patient education point created on the fly and does not have an education (IED) record associated with it. Note that this column is only populated for My Point records. This column is frequently used (along with MY_POINTS_HNO_ID) to link to tables such as CL_PAT_EDU_POINT (via MY_POINT_HNO_DAT) and CL_PATEDU_CNTCT_PT (via CNT_MYPOINT_HNO_DA).
26 LRNR_FIRST_DOSE_MEDICATION_ID_MEDICATION_NAME VARCHAR No
The name of this medication record.
27 TITLE_CONTACT_DATE_REAL INTEGER No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc. The contact date will be for the title education row that was documented on. This can be used along with the TITLE_ID column to join with tables such as IP_EDU_OT_DATA in order to retrieve information for a specific title contact.
28 TOPIC_CONTACT_DATE_REAL INTEGER No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc. The contact date will be for the topic education row that was documented on. This can be used along with the TOPIC_ID column to join with tables such as IP_EDU_OT_DATA in order to retrieve information for a specific topic contact.
29 POINT_CONTACT_DATE_REAL INTEGER No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc. The contact date will be for the point education row that was documented on. This can be used along with the POINTS_IED_ID column to join with tables such as IP_EDU_OT_DATA in order to retrieve information for a specific point contact.