6.66 Schema Changes

Schema changes between CareRight V6.65.3 and CareRight V6.66

New Tables

  • certificates
  • provider_directories
  • clinical_specialties
  • secure_messages
  • medical_objects_endpoints
  • correspondence_acks
  • data_producers

New Columns

TableColumn
medicare_era_reports
invoice_deposit_total
f_practitioner
created_at
f_practitioner
updated_at
f_practitioner
hpii
f_practitioner
ahpra_registration_number
f_practitioner
mo_routing_id
f_practitioner
provider_directory
f_practitioner
pds_key
f_practitioner
pds_practitioner_role_id
f_practitioner
pds_specialties
f_practitioner
pds_synchronised_at
f_practices
created_at
f_practices
updated_at
f_practices
provider_directory
f_practices
pds_key
f_practices
pds_healthcare_service_id
f_practices
hpio
f_practices
pds_synchronised_at
f_practices
recv_facility_namespace_id
f_practices
recv_facility_universal_id
f_practices
recv_facility_universal_id_type
f_practices
recv_application_namespace_id
f_practices
recv_application_universal_id
f_practices
recv_application_universal_id_type
correspondences
message_control_id
correspondences
retry_count
unprocessed_results
location
results
original_hl7

Changed Columns

TableColumnChange
f_patient_acc
p_acc_title
length increased  to 80
f_transaction
trans_payment_ref
length increased  to 100
f_transaction
trans_bank_acc_ref
length increased  to 100

Deleted Columns

TableColumn
episodes
episode_identifier