|
Name |
Type |
Discontinued? |
|
1 |
ALERT_ID |
NUMERIC |
No |
|
|
|
This column stores the unique identifier of the alert record. You could link it to ALERT.ALT_ID to get patient and vendor information in table ALERT. |
|
|
2 |
CONTACT_DATE_REAL |
FLOAT |
No |
|
|
|
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day. |
|
|
3 |
LINE |
INTEGER |
No |
|
|
|
|
4 |
CONTACT_DATE |
DATETIME |
No |
|
|
|
The date on which the encounter took place. |
|
|
5 |
PRC_DIAGNOSES_ID_DX_NAME |
VARCHAR |
No |
|
|
|
The name of the diagnosis. |
|
|