CL_PAT_EDU_TOPIC

Description:

Enterprise reporting table for patient topic 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 topic data.
3	PAT_TOPIC_ID	VARCHAR	No
	Unique identifier for the patient education topic. It is stored in internal format and can be used to link to the teaching topic (IED) master file.
4	PAT_TOPIC_TITLE_ID	VARCHAR	No
	Unique identifier for the patient education title to which the topic is attached to. It is stored in internal format and can be used to link to the teaching title (IED) master file.
5	PAT_TOPIC_STATUS_C_NAME	VARCHAR	No
	A category item that specifies each topic's status. May contain organization-specific values: No Category Entries: Active Resolved Deleted
6	PAT_TOPIC_KEY	VARCHAR	No
	The education topic key for patient education record. This is a string of Title^Topic