6.66 Schema Changes
Last Modified on 28/05/2020 4:59 pm ACST
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
Table | Column |
---|
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
Table | Column | Change |
---|
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
Table | Column |
---|
episodes
| episode_identifier
|