ALT_PRC_DIAGNOSES

Description: |
Diagnoses that are associated with Drug-Disease alerts.

Primary Key

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

Column Information

| 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 |
The Line Count
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.