> 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.

# export_non_insurance_payer

> Non-insurance (third-party) payer information

Non-insurance (third-party) payer information.

**Primary Key:** `id`

## Identifiers

**`id`** `STRING` — required

Unique ID for the non-insurance payer

---

## Organization

**`organization_id`** `STRING`

User's unique organization ID in the Candid system

---

**`organization_name`** `STRING`

User's Organization / Company Name

---

**`external_organization_id`** `STRING`

Organization's External ID - the ID that the organization uses to map to their own upstream system

---

## Details

**`name`** `STRING`

Name of the non-insurance payer

---

**`description`** `STRING`

Description of the non-insurance payer

---

**`category`** `STRING`

Category of the non-insurance payer

---

**`enabled`** `BOOLEAN`

Whether the non-insurance payer is enabled

---

**`is_deleted`** `BOOLEAN`

Whether the non-insurance payer was deleted in the Candid system. Deleted non-insurance payers remain in this table as tombstones so incremental consumers can remove them.

---

**`clinical_trials`** `JSON`

Array of clinical trials configured on this non-insurance payer (clinical_trial_id, clinical_trial_number, clinical_trial_name, clinical_trial_phase, clinical_trial_type, is_deactivated). Join on clinical_trial_id to the clinical_trials arrays on export_patient and export_patient_non_insurance_payer_history.

---

## Timestamps

**`created_at`** `TIMESTAMP`

Time when the non-insurance payer was created

---

**`updated_at`** `TIMESTAMP`

Time when the non-insurance payer or any of its clinical trials was last updated.

---

## Sync columns

**`_cds_row_version`** `TIMESTAMP`

Time when this row's delivered data last changed. Use this for incremental ingestion.

---

**`_cds_row_fingerprint`** `STRING`

Hash of this row's delivered data. Changes whenever any value in the row changes.

---