Skip to navigation

Standard Financial Rollups

Financial totals Candid has already computed per encounter and service line: billed and allowed amounts, patient responsibility, copay, deductible, coinsurance and projected allowed amounts. Use them for reporting without summing transactions yourself.

Tables

TableOne row perPrimary keyShape
export_financial_summaryEncounterencounter_idCurrent state
export_service_line_financial_summaryService line (none for deleted lines)service_line_idCurrent state
export_service_line_projected_financialsService line (none for deleted lines)service_line_idCurrent state

Notes

  • Check is_persisted_financial_summary_record_stale before comparing a summary against the latest transactions.
  • Rows change on claim status changes, even when no amount changed, so expect them in incremental syncs.

Common queries

Billed and allowed per service line

SELECT
sl.service_line_id,
sl.procedure_code,
slfs.billed_amount_cents,
slfs.allowed_amount_cents,
slfs.patient_responsibility_cents
FROM export_service_line sl
JOIN export_service_line_financial_summary slfs
ON sl.service_line_id = slfs.service_line_id