Avatar Appointment Scheduling 2023 Update 5
Product Requirements / Recommendations
Avatar Appointment Scheduling
required
Avatar PM
required
RADplus
required
Avatar Cal-PM
Recommended Update Level
RADplus 2023 Update 28
Additional Requirements
Avatar RADplus 2023 Update 28
Avatar NX Release 2023.03.00
Product Update Form Description
Avatar Appointment Scheduling is enhanced to support Clinic Hours and Waiting Room functionalities. Please note: Avatar RADplus 2023 Update 28 and an Avatar NX Release are required for full functionality.
Included Updates
None
Required Updates
None
| Table | Column | Change |
|---|---|---|
| SYSTEM.appt_site_time_slots | end_timeJ | added |
| SYSTEM.appt_site_time_slots | start_timeJ | added |
| SYSTEM.appt_site_time_slots | clinic_hours | added |
| SYSTEM.AppointmentWaitingRoom | FACILITY | added |
| SYSTEM.AppointmentWaitingRoom | SITEID | added |
| SYSTEM.AppointmentWaitingRoom | site_name | added |
| SYSTEM.AppointmentWaitingRoom | STAFFID | added |
| SYSTEM.AppointmentWaitingRoom | staff_name | added |
| SYSTEM.AppointmentWaitingRoom | waiting_room_date | added |
| SYSTEM.AppointmentWaitingRoom | waiting_room_time | added |
| SYSTEM.AppointmentWaitingRoom | waiting_room_order | added |
| SYSTEM.AppointmentWaitingRoom | type_code | added |
| SYSTEM.AppointmentWaitingRoom | type_value | added |
| SYSTEM.AppointmentWaitingRoom | priority_code | added |
| SYSTEM.AppointmentWaitingRoom | priority_value | added |
| SYSTEM.AppointmentWaitingRoom | phonein_code | added |
| SYSTEM.AppointmentWaitingRoom | phonein_value | added |
| SYSTEM.AppointmentWaitingRoom | telehealth_code | added |
| SYSTEM.AppointmentWaitingRoom | telehealth_value | added |
| SYSTEM.AppointmentWaitingRoom | PATID | added |
| SYSTEM.AppointmentWaitingRoom | patient_name | added |
| SYSTEM.AppointmentWaitingRoom | EPISODE_NUMBER | added |
| SYSTEM.AppointmentWaitingRoom | program_code | added |
| SYSTEM.AppointmentWaitingRoom | program_value | added |
| SYSTEM.AppointmentWaitingRoom | SERVICE_CODE | added |
| SYSTEM.AppointmentWaitingRoom | service_description | added |
| SYSTEM.AppointmentWaitingRoom | location_code | added |
| SYSTEM.AppointmentWaitingRoom | location_value | added |
| SYSTEM.AppointmentWaitingRoom | reason_for_visit_text | added |
| SYSTEM.AppointmentWaitingRoom | JOIN_TO_SLOT_ID | added |
| SYSTEM.AppointmentWaitingRoom | status_code | added |
| SYSTEM.AppointmentWaitingRoom | status_value | added |
| SYSTEM.AppointmentWaitingRoom | display_code | added |
| SYSTEM.AppointmentWaitingRoom | display_value | added |
| SYSTEM.AppointmentWaitingRoom | JOIN_TO_APPT_ID | added |
| SYSTEM.AppointmentWaitingRoom | req_pract_type_code | added |
| SYSTEM.AppointmentWaitingRoom | req_pract_type_value | added |
| SYSTEM.AppointmentWaitingRoom | req_pract_sex_code | added |
| SYSTEM.AppointmentWaitingRoom | req_pract_sex_value | added |
| SYSTEM.AppointmentWaitingRoom | staff_discipline | added |
| SYSTEM.AppointmentWaitingRoom | staff_sex | added |
| SYSTEM.AppointmentWaitingRoom | JOIN_TO_CURRENT | added |
| SYSTEM.AppointmentWaitingRoom | data_entry_action | added |
| SYSTEM.AppointmentWaitingRoom | data_entry_by | added |
| SYSTEM.AppointmentWaitingRoom | data_entry_by_option | added |
| SYSTEM.AppointmentWaitingRoom | data_entry_date | added |
| SYSTEM.AppointmentWaitingRoom | data_entry_source | added |
| SYSTEM.AppointmentWaitingRoom | data_entry_time | added |
| SYSTEM.AppointmentWaitingRoom | data_entry_user_id | added |
| SYSTEM.AppointmentWaitingRoom | data_entry_user_name | added |
| SYSTEM.AppointmentWaitingRoom | option_desc | added |
| SYSTEM.AppointmentWaitingRoom | option_id | added |
| SYSTEM.AppointmentWaitingRoomAudit | JOIN_TO_PREVIOUS | added |
| SYSTEM.AppointmentWaitingRoomAudit | FACILITY | added |
| SYSTEM.AppointmentWaitingRoomAudit | SITEID | added |
| SYSTEM.AppointmentWaitingRoomAudit | site_name | added |
| SYSTEM.AppointmentWaitingRoomAudit | STAFFID | added |
| SYSTEM.AppointmentWaitingRoomAudit | staff_name | added |
| SYSTEM.AppointmentWaitingRoomAudit | waiting_room_date | added |
| SYSTEM.AppointmentWaitingRoomAudit | waiting_room_time | added |
| SYSTEM.AppointmentWaitingRoomAudit | waiting_room_order | added |
| SYSTEM.AppointmentWaitingRoomAudit | type_code | added |
| SYSTEM.AppointmentWaitingRoomAudit | type_value | added |
| SYSTEM.AppointmentWaitingRoomAudit | priority_code | added |
| SYSTEM.AppointmentWaitingRoomAudit | priority_value | added |
| SYSTEM.AppointmentWaitingRoomAudit | phonein_code | added |
| SYSTEM.AppointmentWaitingRoomAudit | phonein_value | added |
| SYSTEM.AppointmentWaitingRoomAudit | telehealth_code | added |
| SYSTEM.AppointmentWaitingRoomAudit | telehealth_value | added |
| SYSTEM.AppointmentWaitingRoomAudit | PATID | added |
| SYSTEM.AppointmentWaitingRoomAudit | patient_name | added |
| SYSTEM.AppointmentWaitingRoomAudit | EPISODE_NUMBER | added |
| SYSTEM.AppointmentWaitingRoomAudit | program_code | added |
| SYSTEM.AppointmentWaitingRoomAudit | program_value | added |
| SYSTEM.AppointmentWaitingRoomAudit | SERVICE_CODE | added |
| SYSTEM.AppointmentWaitingRoomAudit | service_description | added |
| SYSTEM.AppointmentWaitingRoomAudit | location_code | added |
| SYSTEM.AppointmentWaitingRoomAudit | location_value | added |
| SYSTEM.AppointmentWaitingRoomAudit | reason_for_visit_text | added |
| SYSTEM.AppointmentWaitingRoomAudit | JOIN_TO_SLOT_ID | added |
| SYSTEM.AppointmentWaitingRoomAudit | status_code | added |
| SYSTEM.AppointmentWaitingRoomAudit | status_value | added |
| SYSTEM.AppointmentWaitingRoomAudit | display_code | added |
| SYSTEM.AppointmentWaitingRoomAudit | display_value | added |
| SYSTEM.AppointmentWaitingRoomAudit | JOIN_TO_APPT_ID | added |
| SYSTEM.AppointmentWaitingRoomAudit | req_pract_type_code | added |
| SYSTEM.AppointmentWaitingRoomAudit | req_pract_type_value | added |
| SYSTEM.AppointmentWaitingRoomAudit | req_pract_sex_code | added |
| SYSTEM.AppointmentWaitingRoomAudit | req_pract_sex_value | added |
| SYSTEM.AppointmentWaitingRoomAudit | staff_discipline | added |
| SYSTEM.AppointmentWaitingRoomAudit | staff_sex | added |
| SYSTEM.appt_site_waiting_room | FACILITY | added |
| SYSTEM.appt_site_waiting_room | SITEID | added |
| SYSTEM.appt_site_waiting_room | limit_wroom_code | added |
| SYSTEM.appt_site_waiting_room | limit_wroom_value | added |
| SYSTEM.appt_site_waiting_room | site_name | added |
| SYSTEM.appt_site_waiting_room | user_roles | added |
| SYSTEM.appt_site_waiting_room | users | added |
| SYSTEM.appt_site_waiting_room | JOIN_TO_CURRENT | added |
| SYSTEM.appt_site_waiting_room | data_entry_action | added |
| SYSTEM.appt_site_waiting_room | data_entry_by | added |
| SYSTEM.appt_site_waiting_room | data_entry_by_option | added |
| SYSTEM.appt_site_waiting_room | data_entry_date | added |
| SYSTEM.appt_site_waiting_room | data_entry_source | added |
| SYSTEM.appt_site_waiting_room | data_entry_time | added |
| SYSTEM.appt_site_waiting_room | data_entry_user_id | added |
| SYSTEM.appt_site_waiting_room | data_entry_user_name | added |
| SYSTEM.appt_site_waiting_room | option_desc | added |
| SYSTEM.appt_site_waiting_room | option_id | added |
| SYSTEM.appt_site_waiting_room_audit | FACILITY | added |
| SYSTEM.appt_site_waiting_room_audit | SITEID | added |
| SYSTEM.appt_site_waiting_room_audit | limit_wroom_code | added |
| SYSTEM.appt_site_waiting_room_audit | limit_wroom_value | added |
| SYSTEM.appt_site_waiting_room_audit | site_name | added |
| SYSTEM.appt_site_waiting_room_audit | user_roles | added |
| SYSTEM.appt_site_waiting_room_audit | users | added |
