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.