PAT_ENC_REMINDER

Description:

The PAT_ENC_REMINDER table contains information about follow up messages sent to users. These include the number of days after the visit to send the message, the text of the message, and a flag indicating whether the message has been sent or not.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1

Column Information

	Name	Type	Discontinued?
1	PAT_ENC_CSN_ID	NUMERIC	No
	The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
2	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
3	PAT_REMD_SEND_DAYS	INTEGER	No
	Contains the number of days after the visit that a reminder/follow up message should be sent to the user.
4	PATIENT_REMD_SENT_NAME	VARCHAR	No
	This column indicates whether or not a reminder message has been sent to the user. A 1 indicates that a reminder message has been sent. May contain organization-specific values: No Category Entries: No Yes
5	PAT_REMINDER_MSG	VARCHAR	No
	Contains the text of the reminder/follow up message sent to the user.