The ORDER_MED_SIG table stores the patient instructions for a prescription as entered by the user. The table should be used in conjunction with the ORDER_MED table which contains related medication, patient, and contact identification information you can report on.
Primary Key
Column Name
Ordinal Position
ORDER_ID
1
Column Information
Name
Type
Discontinued?
1
ORDER_ID
NUMERIC
No
The unique ID of the order record associated with this medication order. This is an internal unique identifier for ORD master file records in this table and cannot be used to link to CLARITY_MEDICATION.
2
SIG_TEXT
VARCHAR
No
Patient instructions for the prescription as entered by the user.