Documentation/EHI_Export/docs/tables/medex_recalls.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| r_ID | INT | 10 | √ | null |
|
|
Unique ID for the recall record
| | r_PRACTID | INT | 10 | | | null |
|
|
UNUSED - Practice ID associated with the recall
| | r_pid | INT | 10 | | | null |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | r_eventDate | DATE | 10 | | | null |
|
|
Date of Appointment or Recall
| | r_facility | INT | 10 | | | null |
|
| facility.id | Defined in XML | R |
|
FK facility.id associated with the recall
| | r_provider | INT | 10 | | | null |
|
| users.id | Defined in XML | R |
|
Provider ID associated with the recall FK to users.id
| | r_reason | VARCHAR | 255 | √ | | NULL |
|
|
Reason for the recall
| | r_created | TIMESTAMP | 19 | | | '0000-00-00 00:00:00' |
|
|
Timestamp when the recall was created
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | r_ID |
| r_PRACTID | Must be unique | Asc/Asc | r_PRACTID + r_pid |