CL_PAT_EDU_POINT
Description:
Enterprise reporting table for patient education point items in the Patient Education (PED) master file.

Primary Key
Column Name Ordinal Position
PED_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PED_ID NUMERIC No
The Unique ID for the Patient Education Record.
2 LINE INTEGER No
Line count for the Patient education point data.
3 PAT_POINT_ID VARCHAR No
Unique identifier for the patient education points.
4 PAT_PNT_TOPIC_ID_TTP_NAME VARCHAR No
The name of the Title/Topic/Point.
5 PAT_PNT_TITLE_ID_TTP_NAME VARCHAR No
The name of the Title/Topic/Point.
6 PAT_PNT_STATUS_C_NAME VARCHAR No
A category item that specifies each point's status.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Deleted
7 PAT_POINT_KEY VARCHAR No
The education point key for patient education record. This is a string of Title^Topic^Point
8 POINT_IED_ID_TTP_NAME VARCHAR No
The name of the Title/Topic/Point.
9 MY_POINT_HNO_ID VARCHAR No
The unique identifier for the note record associated for a My Point. My Point is a patient education point created on the fly and does not have an IED record associated with it.
10 MY_POINT_HNO_DAT VARCHAR No
The contact date for the note record associated for a My Point. My Point is a patient education point created on the fly and does not have an IED record associated with it.
11 POINT_FIRST_DOSE_MEDICATION_ID_MEDICATION_NAME VARCHAR No
The name of this medication record.