Skip to navigation

export_provider

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
STRINGRequired

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.