ORDER_IMPRESSION
Description:
This table stores impression information for 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 count for the reading physician's impression.
3 IMPRESSION VARCHAR No
The reading physician's impression for this procedure.
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.