Schema changes between CareRight V6.92.4 and 6.93
New Tables/Views
- erx_settings
- erx_links
- medisecure_audit_details renamed to e_prescription_audit_details
- enquiry_categories
New Columns
- locations.fax
- prescription_drugs.regulation_24
- prescription_drugs.route_of_administration
- prescription_drugs.unusual_dose
- providers.exr_entity_id
- providers.prescriber_qualification
- enquiries.category_id
- saml_settings.externally_managed_groups
New Indexes
- None
Changed Views
None
Changed Columns/Indexes
- MIMS: packdat_pbs_code, proddat_prodsort
- enquiries.start_date - allow null
Deleted Tables/Views
- None
Deleted Columns/Indexes
Many legacy columns are removed from Accounting Setup.
- f_setup_acc.SA_ISAAC_PREFIX
- f_setup_acc.SA_DISPLAY_PRIV_MNO
- f_setup_acc.SA_MEDICARE_INTERACTIVE
- f_setup_acc.SA_ACC_MANAGED
- f_setup_acc.SA_HCP_HOSP_TYPE
- f_setup_acc.SA_DISC_PERIOD
- f_setup_acc.SA_DISC_PERC
- f_setup_acc.SA_ASK_MED
- f_setup_acc.SA_ASK_LMO
- f_setup_acc.SA_ASK_PRINT_INV
- f_setup_acc.SA_CHANGE_RATES
- f_setup_acc.SA_ACC_MESS
- f_setup_acc.SA_ACC_METHOD
- f_setup_acc.SA_DEF_ASS_NUMB
- f_setup_acc.SA_DISP_REF
- f_setup_acc.SA_MAX_GAP
- f_setup_acc.SA_MAX_WRITEOFF
- f_setup_acc.SA_MED_CITY
- f_setup_acc.SA_OBAL
- f_setup_acc.SA_PHC_RATE
- f_setup_acc.SA_POSSESSIVE
- f_setup_acc.SA_PROVNO_SPEC
- f_setup_acc.SA_RTI_DATE
- f_setup_acc.SA_ASK_NOTES
- f_setup_acc.SA_USE_REF
- f_setup_acc.SA_VAL_MCARE
- f_setup_acc.SA_VET_TYPE
- f_setup_acc.SA_ZERO_INV
- f_setup_acc.SA_STORE_BALANCES
- f_setup_acc.SA_PLATE_EST
- f_setup_acc.SA_WC_EM_FFALL
- f_setup_acc.SA_WC_EM_UNIT
- f_setup_acc.SA_WC_IH_FFALL
- f_setup_acc.SA_WC_IH_UNIT
- f_setup_acc.SA_ANAES_BILLING
- f_setup_acc.SA_IT_CODE_ASA
- f_setup_acc.SA_GST_METHOD
- f_setup_acc.SA_GST_CALC_METHOD
- f_setup_acc.SA_GST_TAX_INVOICE
- f_setup_acc.SA_BPAY_GRAPHIC
- f_setup_acc.SA_BPAY_CD_RULE_NO
- f_setup_acc.SA_BPAY_MESSAGE
- f_setup_acc.SA_ICD_VERSION
- f_setup_acc.SA_STAT_ASSOC
- f_setup_acc.SA_STAT_THRESH
- f_setup_acc.SA_ACTPH_USED
- f_setup_acc.SA_ASSIST_PYMT
- f_setup_acc.SA_ISAAC_USED
- f_setup_acc.SA_DRG_VERSION
- f_setup_acc.SA_HCP_PROV_NUMB
- f_setup_acc.SA_VAED_USED
- f_setup_acc.SA_HCP_VERSION
- f_setup_acc.SA_VAED_YTD
- f_setup_acc.SA_VAED_HOSPITAL
- f_setup_acc.SA_VAED_SITE_IDENTIFIER
- f_setup_acc.SA_ISAAC_CLINIC
- f_setup_acc.SA_ISAAC_HOSP
- f_setup_acc.SA_DB4_CHAR
- f_setup_acc.SA_DB4_NO
- f_setup_acc.SA_ITEM_COPIED
- f_setup_acc.SA_ITEM_ROLLOVER
- f_setup_acc.SA_RATE_PRINT_OPTIONS
- f_setup_acc.SA_VET_CHAR
- f_setup_acc.SA_VET_NO
Other
So that old temporary reports are cleaned up correctly:
UPDATE report_results SET created_date = current_timestamp WHERE created_date IS NULL
