DOCS_RCVD_MEDS_CMT

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 comment 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 comments 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_COMMENTS	VARCHAR	No
	This item stores medication comments.