Schema changes between CareRight V7.6.6 and CareRight V7.7.1
New Tables
- metric_thresholds
- charts
- chart_metrics
- chart_metric_thresholds
- chart_required_clinical_actions
- patient_charts
- metric_threshold_values
- era_claim_summaries
New Columns
- assessments: citation
- metric_targets: upper_warning_1
- metric_targets: upper_warning_2
- metric_targets: upper_warning_3
- metric_targets: upper_warning_4
- metric_targets: lower_warning_1
- metric_targets: lower_warning_2
- metric_targets: lower_warning_3
- metric_targets: lower_warning_4
- metric_targets: upper_info_1
- metric_targets: upper_info_2
- metric_targets: upper_info_3
- metric_targets: upper_info_4
- metric_targets: lower_info_1
- metric_targets: lower_info_2
- metric_targets: lower_info_3
- metric_targets: lower_info_4
- metric_targets: end_date
- metric_targets: name
- metric_targets: description
- metric_targets: provider_id
- metrics: default_time_axis_1
- metrics: default_time_axis_2
- metrics: default_time_axis_3
- metrics: default_time_axis_4
- metric_targets: metric_threshold_id
- metric_thresholds: upper_emergency_1
- metric_thresholds: upper_emergency_2
- metric_thresholds: upper_emergency_3
- metric_thresholds: upper_emergency_4
- metric_thresholds: lower_emergency_1
- metric_thresholds: lower_emergency_2
- metric_thresholds: lower_emergency_3
- metric_thresholds: lower_emergency_4
- metric_thresholds: upper_default_zoom_1
- metric_thresholds: lower_default_zoom_1
- metric_thresholds: upper_default_zoom_2
- metric_thresholds: lower_default_zoom_2
- metric_thresholds: upper_default_zoom_3
- metric_thresholds: lower_default_zoom_3
- metric_thresholds: upper_default_zoom_4
- metric_thresholds: lower_default_zoom_4
- metric_targets: upper_emergency_1
- metric_targets: upper_emergency_2
- metric_targets: upper_emergency_3
- metric_targets: upper_emergency_4
- metric_targets: lower_emergency_1
- metric_targets: lower_emergency_2
- metric_targets: lower_emergency_3
- metric_targets: lower_emergency_4
- metric_targets: upper_default_zoom_1
- metric_targets: lower_default_zoom_1
- metric_targets: upper_default_zoom_2
- metric_targets: lower_default_zoom_2
- metric_targets: upper_default_zoom_3
- metric_targets: lower_default_zoom_3
- metric_targets: upper_default_zoom_4
- metric_targets: lower_default_zoom_4
- metrics: generic_table_id_1
- metrics: generic_table_id_2
- metrics: generic_table_id_3
- metrics: generic_table_id_4
- patient_measurements: generic_value_1
- patient_measurements: generic_value_2
- patient_measurements: generic_value_3
- patient_measurements: generic_value_4
- clinical_notes: patient_chart_id
- charts: clinical_guidance_url
- users: display_toc
- charts: task_type_id
- chart_metric_thresholds: sort_order
- chart_metrics: sort_order
- clinical_note_versions: patient_chart_id
- metric_targets: patient_chart_id
- metrics: running_balance_1
- metrics: running_balance_2
- metrics: running_balance_3
- metrics: running_balance_4
- charts: plan_assessment_name
- suggested_assessments: chart_id
- plan_elements: chart_id
- charts: has_observation_modifications
- charts: archived_at
- patient_charts: archived_at
- patient_charts: archived
- person_users: encrypted_otp_secret
- person_users: encrypted_otp_secret_iv
- person_users: encrypted_otp_secret_salt
- person_users: consumed_timestep
- person_users: otp_required_for_login
- person_users: otp_backup_codes
- medicare_era_reports: last_cached
- chart_metrics: show_graph
- chart_metric_thresholds: show_graph
- metric_thresholds: show_graph_1
- metric_thresholds: show_graph_2
- metric_thresholds: show_graph_3
- metric_thresholds: show_graph_4
- metric_targets: show_graph_1
- metric_targets: show_graph_2
- metric_targets: show_graph_3
- metric_targets: show_graph_4
- metrics: show_graph_1
- metrics: show_graph_2
- metrics: show_graph_3
- metrics: show_graph_4
- documents: referral_id
- referrals: correspondence_id
- current_assessments: assessed_at
- assessments: modify_assessed_at
- admission_categories: handover_assessment_name
- suggested_assessments: plan_element_id
- metrics: uses_metric_notes_1
- metrics: uses_metric_notes_2
- metrics: uses_metric_notes_3
- metrics: uses_metric_notes_4
- patient_measurements: notes_1
- patient_measurements: notes_2
- patient_measurements: notes_3
- patient_measurements: notes_4
- charts: renderer
- item_services: notes
Changed Columns
- metric_targets: target_date renamed to start_date
- metric_targets: upper_1 renamed to upper_critical_1
- metric_targets: upper_2 renamed to upper_critical_2
- metric_targets: upper_3 renamed to upper_critical_3
- metric_targets: upper_4 renamed to upper_critical_4
- metric_targets: lower_1 renamed to lower_critical_1
- metric_targets: lower_2 renamed to lower_critical_2
- metric_targets: lower_3 renamed to lower_critical_3
- metric_targets: lower_4 renamed to lower_critical_4
- metric_threshold_values: index changed
- metric_threshold_values: threshold_object_type changed
- metric_threshold_values: threshold_object_id changed
- metric_threshold_values: generic_code changed
- metric_threshold_values: threshold_type changed
- patient_charts: start_date renamed to started_at
- patient_charts: end_date renamed to finished_at
- patient_charts: started_at renamed to start_date
- patient_charts: finished_at renamed to end_date
Deleted Tables
- person_users
Deleted Columns
- metric_targets: numeric_value_1
- metric_targets: numeric_value_2
- metric_targets: numeric_value_3
- metric_targets: numeric_value_4
- metric_targets: date_entered
- metric_targets: notes
- patient_charts: archived
- patient_charts: archived_at
- current_assessments: assessed_at
- assessments: modify_assessed_at
