ORD_REC_RMD_LTR

Description:

Contains information about the reminder letters sent for a recommendation.

Primary Key

Column Name	Ordinal Position
FINDING_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	FINDING_ID	NUMERIC	No
	The unique identifier of the finding record associated with this recommendation letter.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	REMINDER_LTR_DT	DATETIME	No
	The date on which a reminder letter was sent to the patient.
4	LETTER_TMPL_ID	VARCHAR	No
	Letter template used to print reminder letter
5	LETTER_TMPL_ID_SMARTTEXT_NAME	VARCHAR	No
	The name of the SmartText record.
6	RIS_LETTER_TYPE_C_NAME	VARCHAR	No
	The batch letter type category number for the reminder letter. This prevents multiple letters of the same type from printing. May contain organization-specific values: Yes Category Entries: Custom Patient Letter Custom Provider Letter Recommendation Due Letter 3-Day Letter 7-Day Letter 10-Day Letter 15-Day Letter 30-Day Letter 60-Day Letter 90-Day Letter 4-Month Letter 5-Month Letter 6-Month Letter 3-Day Overdue Letter 7-Day Overdue Letter 10-Day Overdue Letter 15-Day Overdue Letter 30-Day Overdue Letter 60-Day Overdue Letter 90-Day Overdue Letter
7	MAM_REMINDER_LET_ID	VARCHAR	No
	The ID of the note that contains the letter text