OfficeFlow
This section includes facility resources and details used to track patient flow in the office.
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
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 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
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
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
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
Contains the notes related to a task.
- task_note_id
- task_id
- current_task_note_id
- patient_id
- note
- archived
- firm_global_id
Links tasks with order log records.
- task_order_log_id
- order_log_id
- task_id
- patient_id
- firm_global_id
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