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.