Schema changes between CareRight V7.10.0 and CareRight V7.11.3
New Column(s)
- alert_definitions.primary_snomed_identifier
- allergy_reactions.primary_snomed_identifier
- document_types.radiographic_imaging_procedure
- document_types.radiographic_imaging_type
- allergies.onset_age
- allergy_assessment_snapshots.onset_age
- locations.confirmation_used
- locations.confirm_time
- locations.confirmation_cost
- locations.confirm_interval
- locations.purge_interval
- locations.purge_time
- locations.staff_alloc
- locations.care_right_location_id
- relationships.primary_contact
- relationship_assessment_snapshots.primary_contact
- program_sessions.start_time
- program_sessions.end_time
- program_sessions.time_zone_id
- program_sessions.part_day
- program_schedules.location_id
- program_schedules.ongoing
- program_attendances.admission_id
- email_messages.to_person_id
- sms_messages.to_person_id
- general_services.quantity
- medical_tests.primary_snomed_identifier
- medical_tests.loinc_code
New Index(es)
- snomed_allergies.snomed_identifier
- snomed_allergies.description
- alert_definitions.primary_snomed_identifier
- allergy_reactions.primary_snomed_identifier
- snomed_allergy_reactions.snomed_identifier
- snomed_allergy_reactions.description
- snomed_allergies.description
- patient_counters.patient_id
- program_schedules.location_id
- program_attendances.admission_id
- email_messages.to_person_id
- sms_messages.to_person_id
Change Column(s)
- f_practices.pc_street renamed to address
- f_practices.pc_town renamed to city
- f_practices.pc_postcode renamed to postcode
- f_practices.pc_phone renamed to phone
- f_practices.pc_facsimile renamed to fax
- f_practices.pc_state renamed to state
- f_practices.pc_name renamed to name
- f_practices.pc_notes renamed to notes
- pcoc_phases.leave_days changed
- pcoc_phases.leave_days changed
- general_services.quantity changed
- general_services.quantity changed
Remove Column(s)
- f_associate.ASS_ARGUS_PASS
- f_associate.ass_argus_pass
- f_practitioner.hsd_id
- f_practitioner.argus_email
- f_practitioner.argus_qid
- f_practitioner.argus_interactions
- f_practitioner.argus_address_book_id
- f_prof_categry.hsd_speciality
- f_practices.pc_na_code
- f_practices.PC_NA_CODE
- f_patient.PT_PR_NUMB
- f_patient.pt_pr_numb
- locations.confirmation_cost
- locations.confirm_interval
- locations.confirm_time
- locations.confirmation_used
- locations.purge_interval
- locations.purge_time
- locations.staff_alloc
- locations.care_right_location_id
Removed Table(s)
- argus_end_points
- confirmations
- patient_counters
- medical_director_patient_links
- medical_director_sync_logs
Other
say_with_time "Backfilling activities_count on patients" do
Activity.where(completed_at: nil).group(:patient_id).count.each do |patient_id, _|
patient = Patient.find_by(id: patient_id)
next if patient.blank?
counter = patient.patient_counter || patient.create_patient_counter!
counter.recalculate_for(patient.activities.last)
end
endProgram Attendance to Admission
This does not migrate data yet, as we need to write a service to keep everything in sync. Do not rely on this field.
