Schema changes between CareRight V6.84 and 6.84.1
New Tables/Views
New Columns
- f_serv_locs.email
- prescription_drugs.private_script
- admission_categories.copy_coding_defaults
New Indexes
- None
Changed Views
None
Changed Columns/Indexes
- line_no.f_line_items - now unique.
Deleted Tables
- None
Deleted Columns/Indexes
The following columns held duplicate information. To access the correct information, join patient -> person -> address.
- f_patient.pt_street
- f_patient.pt_town
- f_patient.pt_postcode
- f_patient.pt_state
- f_patient.pt_res_street
- f_patient.pt_res_town
- f_patient.pt_res_postcode
- f_patient.pt_res_state
Other
- Professional Categories - de-duplication of Orthopaedic Surgeon.
- Professional Categories - maps to MHR/ANZCO specialities unless overridden by users.
