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

> Provider information including billing and rendering providers

Provider information including billing and rendering providers. Deleting a provider in Candid removes its row with no tombstone, so incremental consumers miss deletes; pull this table in full daily (it is small).

**Primary Key:** `organization_provider_id`

## Identifiers

**`organization_provider_id`** `STRING` — required

Unique ID for the organization provider

---

**`tax_id`** `STRING`

Provider's tax ID

---

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

**`npi`** `STRING`

Provider's National Provider Identifier - FK to export_encounter.billing_provider_npi or export_encounter.rendering_provider_npi

---

**`provider_type`** `STRING`

Type of provider

---

**`is_rendering`** `BOOLEAN`

Whether the provider is a rendering provider

---

**`is_billing`** `BOOLEAN`

Whether the provider is a billing provider

---

**`first_name`** `STRING`

Provider's first name

---

**`last_name`** `STRING`

Provider's last name

---

**`provider_organization_name`** `STRING`

Provider's organization name

---

**`taxonomy_code`** `STRING`

Provider's taxonomy code

---

**`license_type`** `STRING`

Provider's license type

---

**`ptan`** `STRING`

Provider Transaction Access Number

---

**`employment_status`** `STRING`

Provider's employment status

---

**`is_enabled`** `BOOLEAN`

Whether the provider is enabled

---

## Timestamps

**`created_at`** `TIMESTAMP`

Time when the provider was created

---

**`updated_at`** `TIMESTAMP`

Time when the provider 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.

---