ORDER_MED_ALTCSN

Description: |
It contains the unique contact specific alert number for the order. Link it to alert related tables, such as ALT_HISTORY, ALT_ORDINFO, to get alert related information.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_MED_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_MED_ID | NUMERIC | No |
The unique ID of the order record.
2 | CONTACT_DATE_REAL | FLOAT | No |
The contact date that corresponds to the encounter this order alert occurred.
3 | LINE | INTEGER | No |
The line number for each alert unique contact number.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | ALT_CSN_ID | NUMERIC | No |
The unique ID for the alert across all contacts and alerts in ALT master file. You could link this to ALT_HISTORY table to get the alert information.