6.83 Schema Changes

Schema changes between CareRight V6.82 and 6.83

New Tables/Views

• v_accrual_base
• v_accruals
• v_aged_debtors_data

New Columns

• f_associate.abn_description
• f_setup_acc.abn_description
• calendar_settings.check_provider_of_referral
• providers.prescriber_number - Data is migrated from f_associate.ass_presc_no
• providers.prescription_authority_number
• providers.prescriber_cns_number
• providers.script_paper
• prescriptions.providers
• f_setup_acc.search_item_description
• f_setup_acc.use_account_balance_accrual_date
• f_setup_acc.allow_new_opening_balances
• export_patient_records.appointments
• export_patient_records.correspondence
• export_patient_records.diagnoses
• f_line_items.admission_id
• f_hold_lines.admission_id
• ihc_accommodation_services.claim_contract_id
• ihc_accommodation_services.contract_unit_price_id
• admissions.accrual_accommodation_item_number
• admission_categories.accrual_accommodation_item_number
• admissions.accrual_rate_definition_id
• admissions.accrual_provider_id
• admissions.accrual_service_location_id
• program_attendances.reviewed_at
• program_attendances.reviewed_by
• program_attendances.reviewer_comment
• program_attendances.does_not_require_admission

New Indexes

• None

Changed Views

• None

Changed Columns/Indexes

• f_assoc_loc.al_ref - now unique
• f_adjustment_types.ad_numb - now unique
• f_counters.ct_number - now unique
• f_estimates.est_no - now unique
• f_ip_record.ir_numb - now unique
• f_line_alloc.la_no - now unique
• f_mbs_category.mc_code - now unique
• f_mbs_group.mg_code - now unique
• f_rate_tables.rt_numb - now unique
• f_serv_locs.sl_ref - now unique
• f_setup_acc.sa_numb - now unique
• f_setup_rec.sr_numb - now unique
• f_transaction.trans_no - now unique
• f_practices.pc_numb - now unique
• f_associate.ass_numb - now unique
• f_statement.stat_no - now unique
• f_batch_account.batch_number - now unique
• f_rate_defs.rd_index - now unique

Deleted Tables

• f_ip_record - this has been renamed legacy_ip_record and will eventually be removed
  • This was previously used to join admissions to f_line_items but is no longer required.  Joins such as:
    

    • admissions.arn = f_ip_record.ir_arn AND f_ip_record.line_ir_numb = f_line_items.ir_numb 

  • can be replaced with:

    • f_line_items.admission_id = admissions.id

Deleted Columns/Indexes

• providers.prescription_provider_number
• providers.prescription_script_authority
• f_associate.ass_auth_no
• f_associate.ass_cns
• f_associate.script_paper
• prescriptions.medical_providers
• f_line_items.line_ir_numb
• f_hold_lines.hold_ir_numb

Other

• f_associate.ass_presc_no, storing a Prescriber Number is deprecated in favour of provider.prescriber_number.  Correctly formatted numbers are copied to the new field automatically.

delete FROM settings where settings.var='tasks_enabled'