CL_PAT_EDU_HISTORY
Description:
Patient Education History items.

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 history data.
3 PAT_HX_KEY VARCHAR No
The education key for patient education history. The education key is a string of Title^Topic^Point
4 PAT_HX_TOPIC_ID_TTP_NAME VARCHAR No
The name of the Title/Topic/Point.
5 PAT_HX_POINT_ID VARCHAR No
Unique identifier for the patient education history point.
6 PAT_HX_STATUS_C_NAME VARCHAR No
Category item that that specifies the status of title, topic, or point in education history.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Deleted
7 PAT_HX_INS DATETIME (Local) No
Date/Time stamp for the instance when the title/topic/point was added, resolved, reactivated or deleted.
8 PAT_HX_USER_ID VARCHAR No
Unique identifier for the user that added, resolved, reactivated or deleted the title/topic/point for the patient education.
9 PAT_HX_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
10 PAT_HX_RSN_C_NAME VARCHAR No
Category item specifying the reason for resolving title/topic
May contain organization-specific values: Yes
11 PAT_HX_EPTCSN NUMERIC No
The contact serial number for the patient contact to which this patient education record is associated to.
12 HX_POINT_IED_ID_TTP_NAME VARCHAR No
The name of the Title/Topic/Point.
13 HX_MY_POINT_HNO_ID VARCHAR No
The unique identifier for the note record associated for a My point in patient education record history. My point is a patient education point created on the fly and does not have an education (IED) record associated with it.
14 HX_MY_POINT_HNO_DA VARCHAR No
The contact date for the note record associated for a My point in patient education record history. My point is a patient education point created on the fly and does not have an education (IED) record associated with it.
15 PAT_HIST_TITLE_DAT INTEGER No
The contact date (DAT) where the patient education history title was documented.
16 PAT_HIST_TOPIC_DAT INTEGER No
The contact date (DAT) where the patient education history topic was documented.
17 PAT_HIST_POINT_DAT INTEGER No
The contact date (DAT) where the patient education history point was documented.
18 HX_FIRST_DOSE_MEDICATION_ID_MEDICATION_NAME VARCHAR No
The name of this medication record.