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.