GA Releases
GA
patient_problem_code: use the single is_deleted boolean to filter deleted rows. deletion_time and deleted_by_user_id are deprecated — they remain on the table but are now always null and will be fully removed at a future date. Also fixes duplicate-code and deleted-problem inconsistencies so deletion state matches the Elation application.Full release notesGA
Three Elation Billing tables:
insurance_eligibility_check, patient_insurance_eligibility, clearinghouse_transaction. Also renames patient_guarantor.guarantor to the boolean is_guarantor.Full release notesGA
Six Elation Billing tables:
patient_guarantor, patient_statement_tracking, user_practice, elation_sso_user, payment, financial_transaction.Full release notesGA
Detailed billing status on each bill, plus the rendering, supervising, billing, and referring providers.Full release notes
GA
Five Elation Billing lookup tables (
legal_entity, worklist, worklist_reason, tag_system, tag); claim.legal_entity_id documented as a foreign key.Full release notesGA
Consistent visit-note deletion across
bill, bill_item, bill_item_dx; unified is_deleted flag.Full release notesGA
New
elation_billing schema: era_matched_adjustment, user_role, claim, authorization.Full release notesGA
recurring_event_group and recurring_event_schedule promoted to GA.Full release notesGA
office_messages report_id; med_order prescription lifecycle; Elation Note beta tables.Full release notesGA
physician_license expansion; ethnicity fields overhaul; loinc_code replaces loinc_id.Full release notesGA
Timestamp standardization to
TIMESTAMPNTZ(9); Event Streaming migration.Full release notesGA
medication_rxnorm.is_deleted; appointment in_person_or_virtual and instructions.Full release notesGA
med_order.days_supply; patient full_name, consented, gender_identity update.Full release notesGA
New
physician_license and provider_availability tables; visit_note time columns.Full release notesGA
patient primary_care_provider_id, primary_care_provider_npi, pronouns.Full release notesGA
patient.deceased_date; visit_note_bullet.is_deleted; user.direct_message_address.Full release notesGA
patient_employer.is_deleted.Full release notesGA
referral_order lifecycle columns; misc_orders.is_deleted and resolution_state.Full release notesGA
Audit columns for
patient_tag and document_tag; patient.patient_status.Full release notesGA
appointment.service_location_id; service_location.name.Full release notesBeta Releases
Beta
bill_item_dx schema overhaul; visit_note_bullet.replaced_by_visit_note_bullet_id.Beta
clinical_form_collection.is_deleted; visit_note_bullet audit columns.Beta
is_deleted added to 10 tables; unique key rebuild required.Beta
uq_{tablename} and hdb_last_sync added to all tables.Beta
Views replaced by tables (
report, report_addendum, report_document_tag).