ORDER_NARRATIVE

Description:

This table stores the narrative information resulting from a procedure.

Primary Key

Column Name	Ordinal Position
ORDER_PROC_ID	1
ORD_DATE_REAL	2
LINE	3

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 number for the information associated with this record. Multiple pieces of information can be associated with this record
3	NARRATIVE	VARCHAR	No
	Stores the narrative information for this order.
4	ORD_DATE_REAL	FLOAT	No
	This is a numeric representation of the date each order was placed in your system. The integer portion of the number specifies the date the order was placed. The digits after the decimal point indicate multiple orders on one day.
5	CONTACT_DATE	DATETIME	No
	The calendar date that the order was placed.
6	IS_ARCHIVED_YN	VARCHAR	No
	Indicates whether the order narrative is archived. Y’ indicates that the order narrative is archived. N’ or NULL indicate that the order narrative is not archived.