office_messages: report_idIf a report is attached to an office message, report_id now links to the report table.office_messages_recipients: thread removal trackingremoved_from_thread (boolean) and removed_at (timestamp) were added to track when recipients are removed from a message thread.appointment: is_blockingThe is_blocking flag indicates whether an appointment blocks the provider’s schedule. Defaults to true.med_order: prescription lifecycle and sample tracking
supervising_physician_id: the supervising physician for the order
fulfillment_state: current state of the prescription: new, failure, error, sent, complete, pending_complete, denied, sending
num_samples: populated when the medication is a sample
patient_adherence: patient adherence data for the medication
provider_letter: viewed_atRecords the timestamp when a provider letter was initially viewed.referral_order: clinical_reason removedThe clinical_reason column has been removed. Use the body column instead, which is pulled from the body of the referral.patient_problem: unique key changeA bug caused duplicate rows due to incorrect fields being included in the unique key. All unique keys for this table will change as a result of this fix. Customers doing incremental builds will need to account for this.patient_phone: empty string deletions now visibleWhen a phone number was manually removed from a chart, it was previously filtered out. It will now appear as an empty phone number (not as deleted).New Elation Note tables (beta)Six new tables expose structured data from Elation’s custom note blocks. See the entity relationship diagram for details on how these tables relate.
These tables are beta. Schema may change without notice. The vn2_* tables will be removed in a future release.
Was this page helpful?
⌘I
Assistant
Responses are generated using AI and may contain mistakes.