| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
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 |
|
|
The calendar appointment id |
|||||
| pid | BIGINT | 19 | 0 |
|
|
The internal patient identifier |
|||||
| original_user | VARCHAR | 255 | '' |
|
|
This is the user that created the original record |
|||||
| encounter | BIGINT | 19 | 0 |
|
|
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 |
Showing 1 to 11 of 11 entries