Documentation/EHI_Export/docs/tables/patient_tracker.html
| 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
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| eid | Performance | Asc | eid |
| pid | Performance | Asc | pid |