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 VARCHAR No
Unique identifier for the patient education history topic. it is stored in internal format and can be used to link to topic record in education master file.
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 VARCHAR No
Unique identifier for the patient education history point. It is stored in internal format and can be used to link to point record in the education (IED) master file.
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 NUMERIC No
The unique ID of the medication record associated with a first-dose education point. This is blank for points that are not associated with first-dose education for a medication.