OfficeFlow
This section includes facility resources and details used to track patient flow in the office.
appointment_facility_resource_reservation
Shows all reservations of facility resources by appointments. One row for every instance of an Appointment reserving a Facility Resource.
- appointment_facility_resource_reservation_id
- appointment_id
- facility_resource_id
- patient_id
- firm_global_id
facility_resource_utilization_log
Utilization Log Facility Resources, primarily patients checking in and out of rooms. Table including room times and reasons for leaving. One row per room/check in (not per event).
- facility_resource_utilization_log_id
- facility_resource_id
- facility_id
- patient_id
- visit_id
- checked_in_by_staff_id
- checked_out_by_staff_id
- come_in_notification_sent
- room_leave_reason
- check_in_time
- check_out_time
- firm_global_id
task
Task table contains all the tasks created in Encompass.
- task_id
- firm_id
- patient_id
- patient_assignee_id
- parent_task_id
- visit_id
- appointment_id
- facility_id
- business_unit_id
- result_log_id
- chart_note_id
- intra_mail_id
- created_by_staff_id
- modified_by_staff_id
- task_unique_identifier
- task_patient_name
- task_name
- task_detail
- main_note
- priority
- task_type
- current_status
- appointment
- task_facility_name
- bill_assignee_group_name
- intra_mail
- is_complete
- track_history
- time_zone
- visit_date
- date_assigned
- date_due
- date_completed
- date_restarted
- date_last_note_added
- visit_date_ld
- date_assigned_ld
- date_due_ld
- date_completed_ld
- date_restarted_ld
- date_last_note_added_ld
- date_created
- date_modified
- firm_global_id
task_attachment
This table contains the relationship ids between a task and its attachments.
- task_attachment_id
- file_attachment_id
- patient_id
- task_id
- firm_global_id
task_fax_inbound
This table contains the relationship ids between a task and its faxes received.
- task_fax_inbound_id
- fax_inbound_id
- task_id
- patient_id
- firm_global_id
task_group_assignee
This table contains the list of groups assigned to a task.
- task_group_assignee_id
- firm_group_id
- task_id
- patient_id
- firm_global_id
task_note
Contains the notes related to a task.
- task_note_id
- task_id
- current_task_note_id
- patient_id
- note
- archived
- firm_global_id
task_order_log
Links tasks with order log records.
- task_order_log_id
- order_log_id
- task_id
- patient_id
- firm_global_id
task_staff_assignee
This table contains the list of persons assigned to a task.
- task_staff_assignee_id
- staff_id
- task_id
- patient_id
- assignee_by_group
- firm_global_id