> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.joincandidhealth.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.joincandidhealth.com/_mcp/server.

# Claim Lifecycle

> Claim submissions and acknowledgements in Candid Data Share

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

## Tables

| Table                                                                                            | One row per                       | Primary key           | [Shape](/data-share/data-model#table-shapes) |
| ------------------------------------------------------------------------------------------------ | --------------------------------- | --------------------- | -------------------------------------------- |
| [`export_claim_submission_history`](/data-share/claim-lifecycle/export-claim-submission-history) | Claim submission (many per claim) | `claim_submission_id` | Current 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](/data-share/faq).

## Common queries

### Latest submission per encounter

```sql
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
```