Documentation/EHI_Export/docs/tables/patient_tracker_element.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pt_tracker_id | BIGINT | 19 | 0 |
|
| patient_tracker.id | Defined in XML | R |
|
maps to id column in patient_tracker table
| | start_datetime | DATETIME | 19 | √ | | NULL |
|
|
The datetime this tracker element event was created
| | room | VARCHAR | 20 | | | '' |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘patient_flow_board_rooms’ and represents the facility room that the patient has been assigned to and this tracker element is connected to
| | status | VARCHAR | 31 | | | '' |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘apptstat’ if it is a single patient appointment OR list_options.list_id=‘groupstat’ if this is a group appointment. It represents the current appointment status at the time this tracker element was created
| | seq | VARCHAR | 4 | | | '' |
|
|
This is a numerical sequence for this pt_tracker_id events and in combination with the pt_tracker_id uniquely identifies this record
| | user | VARCHAR | 255 | | | '' |
|
| users.username | Defined in XML | R |
|
This is the user that created this element
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pt_tracker_id | Performance | Asc/Asc | pt_tracker_id + seq |