|
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. |
|
|