Schema changes between CareRight V6.79 and 6.80
New Tables/Views
- None
New Columns/Indexes
- service_provider_import_dirs.file_type
- hi_service_audit_trails.organisation_hpio
- medicare_payment_reports_uk1 - uniqueness constraint
- medicare_payment_reports_uk2 - uniqueness constraint
Changed Views
- Changes to deployment sequence of views
Changed Columns
- medicare_payment_reports.claim_transaction_id - reduced to length 24
- medicare_era_reports.payment_reference - reduced to length 30
- medicare_payment_reports.payment_reference reduced to length 30
Deleted Tables
- None
Deleted Columns/Indexes
- users.db_username - Unused by the application.
- medicare_batch_payment_reports_stop_duplicates - index only
- medicare_batch_payment_reports_stop_duplicates1 - index only
