export_provider
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
Unique ID for the organization provider
Provider’s tax ID
Organization
User’s unique organization ID in the Candid system
User’s Organization / Company Name
Organization’s External ID - the ID that the organization uses to map to their own upstream system
Details
Provider’s National Provider Identifier - FK to export_encounter.billing_provider_npi or export_encounter.rendering_provider_npi
Type of provider
Whether the provider is a rendering provider
Whether the provider is a billing provider
Provider’s first name
Provider’s last name
Provider’s organization name
Provider’s taxonomy code
Provider’s license type
Provider Transaction Access Number
Provider’s employment status
Whether the provider is enabled
Timestamps
Time when the provider was created
Time when the provider was last updated
Sync columns
Time when this row’s delivered data last changed. Use this for incremental ingestion.
Hash of this row’s delivered data. Changes whenever any value in the row changes.