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.