medex_recalls


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of medex_recalls.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Tracks Patient Recalls. Recalls are when a patient should be reached out to or contacted for a healthcare followup.

Columns

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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc r_ID
r_PRACTID Must be unique Asc/Asc r_PRACTID + r_pid

Relationships

Close relationships within degrees of separation