patient_tracker_element


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

Used for tracking individual state changes in the appointment/encounter of a patient

Columns

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

Indexes

Constraint Name Type Sort Column(s)
pt_tracker_id Performance Asc/Asc pt_tracker_id + seq

Relationships

Close relationships within degrees of separation