patient_tracker


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

Patient appointment events that occur in the system. Used in the patient flowboard and for patient data reporting

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
patient_tracker_element.pt_tracker_id Defined in XML R

Surrogate ID of the patient tracker record used as the primary incrementing key
date DATETIME 19 √ NULL

The datetime this tracker event was created
apptdate DATE 10 √ NULL

The appointment date this patient tracker record applies to
appttime TIME 10 √ NULL

The appointment time this patient tracker record applies to
eid BIGINT 19 0
openemr_postcalendar_events.pc_eid Defined in XML R

The calendar appointment id
pid BIGINT 19 0
patient_data.pid Defined in XML R

The internal patient identifier
original_user VARCHAR 255 ''
users.username Defined in XML R

This is the user that created the original record
encounter BIGINT 19 0
form_encounter.encounter Defined in XML R

The encounter the patient appointment is connected to
lastseq VARCHAR 4 ''

The element file should contain this number of elements
random_drug_test BOOLEAN 3 √ NULL

Tracks if the patient should be given a randomized drug test. NULL if not randomized. If randomized, 0 is no, 1 is yes
drug_screen_completed BOOLEAN 3 0

Tracks if the patient has completed a drug screening. 0 if no, 1, if they have completed a drug screening

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
eid Performance Asc eid
pid Performance Asc pid

Relationships

Close relationships within degrees of separation