Schema changes between CareRight V6.84.3 and 6.85
New Tables/Views
- stripe_transactions
New Columns
- f_setup_acc.stripe_connected_account_id
- admission_category_configs.required
New Indexes
- staff_members.staff_type_id - New index
- staff_members.staff_category_code - New index
- staff_resources.staff_type - New index
- staff_resources.discipline - New index
Changed Views
None
Changed Columns/Indexes
- f_batch_account, :batch_number - Now limit: 40
- batch_logs.batch_account_id - Now limit: 40
- f_invoice.inv_batch_number - Now limit: 40
- f_statement.stat_batch_number - Now limit: 40
- batch_service_assessments.batch_number - Now limit: 40
- bulk_bill_service_mappings.batch_number - Now limit: 40
- medicare_payment_reports.batch_account_id - Now limit 40
- medicare_payment_reports_old.batch_account_id - Now limit 40
- medicare_payment_reports_old1.batch_account_id - Now limit 40
- receipts.batch_account_id - Now limit 40
- refunds.batch_account_id - Now limit 40
- report_results.token - Now limit 128
Deleted Tables
- None
Deleted Columns/Indexes
- None
Other
- delete from custom_templates where default_template_id in (select id from default_templates where category = 2)
