7.10.0 Schema Changes

Schema changes between CareRight V7.9.0 and CareRight V7.10.3

New Tables

• activities

New Columns

• program_categories.program_session_assessment_name
• current_assessments.program_session_id
• plan_elements.is_create_task
• patients.activities_count
• activities.chart_id
• care_plans.archived_at

New Indexes

• current_assessments.program_session_id
• activities.staff_member_id
• activities.deadline_at
• activities.undertaken_at
• activities.completed_at
• activities.plan_element_id
• activities.patient_id
• activities.chart_id
• care_plans.archived_at

Changed Columns

• locations.anzsic_organization_code
• pcoc_phases.leave_days

Deleted Tables

None

Deleted Columns

None

Other

For all workflows, we have added the below columns

    ActiveRecord::Base.connection.tables.select { |a| a != "workflow_model_state_logs" && a.start_with?("workflow_model_") }.each do |table_name|
      add_column table_name, :assigned_user_at, :datetime
      add_column table_name, :assigned_user_id, :integer
      add_index table_name, :assigned_user_id
    end

We have updated activity counts

    Activity.group(:patient_id).pluck(:patient_id).each do |patient_id|
      Patient.reset_counters(patient_id, :activities)
    end

My Health Record users may notice an update to their ANZSIC Organisation Classifications to be more specific.

    execute "update locations set anzsic_organization_code = '8402-2' where anzsic_organization_code = '8402'"
    execute "update locations set anzsic_organization_code = '8511-2' where anzsic_organization_code = '8511'"
    execute "update locations set anzsic_organization_code = '8401-13' where anzsic_organization_code = '8401'" # Private day centre/hospital
    execute "update locations set anzsic_organization_code = '8512-14' where anzsic_organization_code = '8512'"
    execute "update locations set anzsic_organization_code = '8531-5' where anzsic_organization_code = '8531'" # Dental Surgery
    execute "update locations set anzsic_organization_code = '8539-18' where anzsic_organization_code = '8539'" # Extended Allied Health services