6.90 Schema Changes

Schema changes between CareRight V6.89.4 and 6.90


New Tables/Views

  • assessment_standardisations
  • medisecure_links
  • medisecure_audit_details
  • medisecure_audit_trails
  • medisecure_settings
  • nde_check_settings
  • nde_check_results
  • medisecure_access_tokens

New Columns

  • admissions.unqualified_newborn_bed_days
  • program_schedules.archived_at
  • f_guarantors.use_parent_fund_for_claiming
  • signature_templates.pages_to_sign
  • signature_templates.data
  • signature_templates.mime_type
  • audit_items.category
  • audit_items.staff_id
  • custom_drugs.s8
  • custom_drugs.formula
  • custom_drugs.form_code
  • custom_drugs.amt_code_type
  • providers.eprescription_disabled
  • providers.encrypted_prescription_passphrase
  • providers.nde_enabled
  • prescriptions.ctg_code
  • prescriptions.notes
  • prescriptions.streamline_authority
  • prescription_drugs.asl_opt_out
  • prescription_drugs.send_to_pharmacy
  • prescription_drugs.unusual_quantity
  • prescription_drugs.urgent_supply
  • prescription_drugs.permit_number
  • prescription_drugs.minimum_day_interval_between_repeats
  • prescription_drugs.completion_date
  • prescription_drugs.formula
  • prescription_drugs.s8_valid

New Indexes

Warning: Some customers with a large number of audit logs may experience increases in disk usage or a long deployment time.

Clintel: Internal Checklist

  • audit_items.created_at
  • auditable_actions.created_at
  • audit_items.category
  • audit_items.staff_id

Changed Views

  • None

Changed Columns/Indexes

  • index_users_on_reset_password_token

Deleted Tables

  • None

Deleted Columns/Indexes

  • None