6.81.1 Schema changes

Schema changes between CareRight V6.81 and 6.81.1



New Tables/Views

  • export_patient_records

New Columns

  • episodes.snap_episode_number
  • episodes.snap_type
  • episodes.snap_episode_start_date
  • episodes.snap_episode_end_date
  • episodes.ansnap_group_classification
  • episodes.multidisciplinary_care_plan_flag
  • episodes.multidisciplinary_care_plan_date
  • episodes.proposed_principal_referral_service
  • episodes.primary_impairment_type
  • episodes.clinical_assessment_only_indicator
  • admission_categories.hide_procedures
  • admission_categories.hide_miscellaneous_service_codes
  • admission_categories.hide_births
  • admission_categories.hide_leave

New Indexes

  • None

Changed Views

  • None

Changed Columns

  • admissions.unplanned_readmission_type renamed to admissions.unplanned_admission_type

Deleted Tables

  • None

Deleted Columns/Indexes

  • episodes.clinical_assessment_only_indicator