Skip to navigation

Claim Lifecycle

Every submission of every claim, with the channel, the payer it went to, and the clearinghouse and payer acknowledgements.

Tables

TableOne row perPrimary keyShape
export_claim_submission_historyClaim submission (many per claim)claim_submission_idCurrent state

Notes

  • Join to encounters on encounter_id (or claim_id). Order a claim’s submissions by submission_number, or filter is_latest_submission for the most recent.
  • Status codes here come from the payer’s 277 acknowledgement. They’re a different code system from export_encounter.claim_status. See the FAQ.

Common queries

Latest submission per encounter

SELECT
e.encounter_id,
e.date_of_service,
csh.claim_submission_id,
csh.submission_number,
csh.created_at
FROM export_encounter e
JOIN export_claim_submission_history csh
ON e.encounter_id = csh.encounter_id
AND csh.is_latest_submission