DOCS_RCVD_MEDS_INS
Description:
This item stores medications received from outside sources.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
CONTACT_DATE_REAL 2
GROUP_LINE 3
VALUE_LINE 4

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
This item stores the Received Document record ID.
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 GROUP_LINE INTEGER No
The line number of the medication insurance in the received document. Together with DOCUMENT_ID and CONTACT_DATE_REAL, this forms the foreign key to the DOCS_RCVD_MEDS table.
4 VALUE_LINE INTEGER No
The line number of one of the multiple medication insurances associated with the received document and the medication from the DOCS_RCVD_MEDS table.
5 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
6 MED_PAT_INSTR VARCHAR No
This item stores the patient instructions associated with the med.