CL_PATEDU_CNT_TITL
Description:
Enterprise reporting table for contact specific title in Patient Education (PED) records.

Primary Key
Column Name Ordinal Position
PED_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 PED_ID NUMERIC No
The Unique ID for the Patient Education Record.
2 CONTACT_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 LINE INTEGER No
Line count for the Patient education contact specific title data.
4 CONTACT_DATE DATETIME No
The contact date in external format.
5 CONTACT_TITLE_ID VARCHAR No
The unique ID of the patient education title for which the patient has received education.
6 CNT_TITLE_STATUS_C_NAME VARCHAR No
Category item that specifies the status of the title.
May contain organization-specific values: No
Category Entries:
Active
N/A
Done
Deleted
Not Started
In Progress
7 CNT_TITLE_EDU_ID NUMERIC No
The unique ID of the education detail record that contains additional details about this title for this encounter.
8 TITLE_WAS_SUG_YN VARCHAR No
Indicates whether this title was suggested by the EMR. Y indicates that this title was suggested by the EMR. N or null indicates that this title was not suggested by the EMR.
May contain organization-specific values: No
Category Entries:
No
Yes
9 TITLE_ADDED_FROM_C_NAME VARCHAR No
The category ID for how this title was added to the patient's chart. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID).
May contain organization-specific values: No
Category Entries:
Patient Education
Care Plan
Doc Flowsheet
Order
Order Set
Pathway
Task Template
Interface
Patient Assigned Task
Utility
Rover Patient Education
Haiku Patient Education
10 TITLE_ALT_CSN_ID NUMERIC No
If this title was added to the patient's chart based on an OurPractice Advisory, then this is the unique contact serial number of the alert (ALT) contact that is used to track the firing of that OurPractice Advisory. If this title was not added based on an OurPractice Advisory, then this is null.