ORD_ASMT_RMNDR_LTR
Description:
This table contains information about the reminder letters sent for a given mammography assessment.

Primary Key
Column Name Ordinal Position
ORDER_PROC_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_PROC_ID NUMERIC No
The unique ID of the procedure order record.
2 LINE INTEGER No
The line count for the reminder letter.
3 MAMM_RMD_LTR_DT DATETIME No
Dates on which a reminder letter was sent to have an appointment scheduled for regular mammograms
4 MAMMO_LETTER_ID VARCHAR No
The record ID of the mammo reminder letter. This would be commonly used to link to the actual letter text.