Schema changes between CareRight V6.86 and 6.87
New Tables/Views
- None
New Columns
- patient_tracking.history_of
- patient_tracking.user_id
- calendar_settings.next_available_only
- calendar_settings.day_split_time
- appointment_types.booking_fee_strategy
- admissions.newborn_qualification_status
- external_patient_tokens.invoice_id
- f_rate_tables.a_theatre_procedure_1
- f_rate_tables.a_theatre_procedure_2
- f_rate_tables.a_theatre_procedure_3
- f_rate_tables.a_theatre_procedure_4
- f_rate_tables.b_theatre_procedure_1
- f_rate_tables.b_theatre_procedure_2
- f_rate_tables.b_theatre_procedure_3
- f_rate_tables.b_theatre_procedure_4
- f_rate_tables.c_theatre_procedure_1
- f_rate_tables.c_theatre_procedure_2
- f_rate_tables.c_theatre_procedure_3
- f_rate_tables.c_theatre_procedure_4
- f_rate_tables.d_theatre_procedure_1
- f_rate_tables.d_theatre_procedure_2
- f_rate_tables.d_theatre_procedure_3
- f_rate_tables.d_theatre_procedure_4
- f_rate_tables.e_theatre_procedure_1
- f_rate_tables.e_theatre_procedure_2
- f_rate_tables.e_theatre_procedure_3
- f_rate_tables.e_theatre_procedure_4
- people.person_description
- f_patient_acc.minimum_benefit
- f_guarantors.minimum_benefit_rate
- admission_categories.associated_assessment_name
- current_assessments.admission_id
New Indexes
- current_assessments.program_attendance_id
- current_assessments.submitted_by_patient_id
Changed Views
None
Changed Columns/Indexes
- f_prof_categry.pro_cat_no is now unique
- f_hold_lines.hold_item_number - now limit: 15
Deleted Tables
- None
Deleted Columns/Indexes
- None
Other
update f_invoice set inv_ref_number = INV_REF_NO where INV_REF_NO > 0 and inv_ref_number = 0
