7.6.0 Schema Changes
Last Modified on 22/04/2025 2:52 pm ACST
Schema changes between CareRight V7.5.9 and CareRight V7.6.6
New Tables
New Columns
| Table | Column |
|---|
assessment_elements
| tooltip
|
f_invoice
| has_processing_report
|
f_invoice
| has_payment_report
|
assessments
| authored_by
|
enquiry_categories
| completed_online_enquiry_redirect_url
|
assessment_elements
| placeholder
|
f_guarantors
| abn
|
f_guarantors
| acn
|
f_guarantors
| duns
|
users
| default_clinical_note_filter
|
immunisation_assessment_snapshots
| dose_number
|
immunisations
| dose_number
|
service_providers
| archived_at
|
Changed Columns
| Table | Column | Change |
|---|
f_batch_account
| BATCH_TO
| batch_to
|
f_referral
| f_ref_ass_numb
| medical_provider_id
|
f_referral
| f_ref_pr_numb
| professional_contact_id
|
f_referral
| f_ref_expires
| expires_date
|
f_referral
| f_ref_activated
| activated_date
|
f_referral
| f_ref_ref
| user_reference
|
f_referral
| f_ref_recip_status
| recipient_status
|
f_referral
| f_ref_status
| status
|
f_referral
| f_ref_direction
| referral_type
|
f_referral
| f_ref_date
| referral_date
|
f_referral
| f_ref_notes
| referral_length
|
f_referral
| f_ref_pt_numb
| mrn
|
referral_assessment_snapshots
| f_ref_ass_numb
| medical_provider_id
|
referral_assessment_snapshots
| f_ref_pr_numb
| professional_contact_id
|
referral_assessment_snapshots
| f_ref_expires
| expires_date
|
referral_assessment_snapshots
| f_ref_activated
| activated_date
|
referral_assessment_snapshots
| f_ref_ref
| user_reference
|
referral_assessment_snapshots
| f_ref_recip_status
| recipient_status
|
referral_assessment_snapshots
| f_ref_status
| status
|
referral_assessment_snapshots
| f_ref_direction
| referral_type
|
referral_assessment_snapshots
| f_ref_date
| referral_date
|
referral_assessment_snapshots
| f_ref_notes
| referral_length
|
referral_assessment_snapshots
| f_ref_pt_numb
| mrn
|
service_providers
| address_id
| add index |
enquiries
| category_id
| add index
|
enquiries
| location_id
| add index
|
enquiries
| user_id
| add index
|
enquiries
| enquirer_id
| add index
|
enquiries
| subject_id
| add index
|
current_assessments
| submitted_for_approval_by
| add index
|
Deleted Tables
Deleted Columns
