billing_status_detail column and provider reference columns to the bill table, exposing the provider roles recorded in the visit note billing section.
Schema Changes
Release Highlights
Billing Status Detail The existingbilling_status column collapses eight underlying bill statuses into four categories (Unbilled, Billed, UnresolvedError, ResolvedError). The new billing_status_detail column exposes the full status shown in Billing Home, so you no longer have to reconstruct it. billing_status is unchanged. Values:
Provider reference columns on
bill
The bill table now carries the provider roles from the visit note billing section. Previously only visit_note.physician_user_id was available, which does not always match the rendering provider shown on the bill.
Three of the columns identify Elation user accounts. Resolve them to provider name, NPI, and credentials by joining the user table on user.physician_id:
rendering_provider_id— the provider who rendered the services on the bill.supervising_provider_id— the supervising provider.billing_provider_id— the billing provider (for example, incident-to billing).
referring_provider_id— the referring-provider record; its name and state are already surfaced onbillasreferring_providerandreferring_provider_state.
Join the three user-backed
*_provider_id columns to user on user.physician_id, not user.id.