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.