Schema changes between CareRight V6.80 and 6.81
New Tables/Views
- ihc_births
- admission_births
- mims.amt_description
- mims.link_amt
New Columns
- admissions.icu_days
- admissions.icu_hours
- admissions.special_care_nursery_hours
- admissions.duration_of_non_invasive_ventilation_in_icu
- admissions.special_care_nursery_days
- admissions.special_care_nursery_charges
- beds.is_icu
- beds.is_special_nursery
- custom_drugs.amt_coding_system
- custom_drugs.amt_display_name
- custom_drugs.amt_code
- episodes.unplanned_return_to_theatre
- episodes.qhapdc_first_admission_for_palliative_care_treatment
- episodes.qhapdc_previous_specialised_non_admitted_palliative_care
- f_practices.email
- followups.due_time
- ihc_claims.admission_weight
New Indexes
- services.event_id
- item_services.item_id
- item_services.billed
- events.deleted
- events.location_id
- events.service_type
- events.service_location_id
- events.staff_member_id
- events.start_date
- clinical_notes.clinical_note_category_id
- clinical_notes.user_id
- clinical_notes.note_type
- clinical_notes.assessment_id
- clinical_notes.assessment_instance_id
- clinical_notes.version
- clinical_notes.striker_id
- clinical_notes.unstriker_id
- group_roles.role_id
- group_roles.role_id + group_id
- f_assoc_loc.al_prov_numb + disabled
- tyro_terminal_targets.tyro_terminal_id
- tyro_terminals.tyro_terminal_target_id
Changed Views
- v_age_accounts - Now includes a most_recent_date
Changed Columns
- admissions.infant_weight - string to int
- admissions.newborn_qualified_days - string to int
Deleted Tables
- medicare_secondary_capabilities
- medicare_participant_capabilities
- medicare_capabilities
- arbitrary_medicare_requests
Deleted Columns/Indexes
- medicare_online_requests.log
