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.