Schema changes between CareRight V6.87.3 and 6.88
New Tables/Views
- result_snapshots
New Columns
- admission_categories.supports_modern_validation
- hi_service_settings.mhr_user_timeout
- f_serv_locs.bpay_code
- episode_procedures.procedure_date
- grouper_settings.send_method
- grouper_job_results.request_json
- grouper_job_results.response_json
- appointment_types.completed_online_booking_redirect_url
- calendar_settings.show_existing_patient_toggle
- ihc_claims.claim_type_code
- external_patient_tokens.document_id
- external_patient_tokens.result_id
- assessment_elements.av_scanned_at
- attachments.av_scanned_at
- correspondence_snapshots.av_scanned_at
- custom_templates.av_scanned_at
- export_instances.av_scanned_at
- merge_forms.av_scanned_at
- pictures.av_scanned_at
- scaled_pictures.av_scanned_at
New Indexes
- appointment_statuses.appointment_condition
- appointment_statuses.disabled
- appointment_trigger_configs.appointment_trigger_id
- appointment_trigger_configs.message_type_id
- appointment_trigger_configs.template_override_id
- appointment_triggers.trigger_type
- appointment_types.disabled
- appointment_types.enabled_for_theatre
- appointment_types.online_booking
- appointments.appointment_type_id
- appointments.calendar_session_type_id
- appointments.calendar_session_id
- appointments.category
- appointments.referral_id
- appointments.assistant_id
- appointments.anaesthetist_id
- appointments.anaesthetic_choice_id
- appointments.lmo_id
- appointments.root_id
- calendar_sessions.anaesthetist_id
- calendar_sessions.theatre_planning_complete
- calendar_session_types.inactive
- calendar_session_types.service_location_id
Changed Views
None
Changed Columns/Indexes
- f_associate.ass_bpay_bcode renamed to bpay_code
Deleted Tables
- None
Deleted Columns/Indexes
- external_patient_tokens.correspondence_id
