provider specialty code
prvdr_spclty_cdDefinition
ISO-11179 Definition
The standardized alphanumeric code identifying a healthcare provider specialty using the NUCC Health Care Provider Taxonomy code set maintained by the National Uniform Claim Committee. Taxonomy codes are ten-character alphanumeric identifiers organized in a hierarchical structure by provider type, classification, and specialization. For example, 207R00000X identifies Internal Medicine and 207RC0000X identifies Cardiovascular Disease as a subspecialty.
Providers report taxonomy codes in the NPI registry and on claims forms to communicate their specialty to payers. Healthcare data teams use prvdr_spclty_cd as the primary specialty identifier in provider master data, joining to NUCC taxonomy reference tables for specialty descriptions, and applying specialty-based claims editing rules that validate procedure code and specialty combinations for payment integrity.
Standard Abbreviation
prvdr_spclty_cd
Category
Production DDL — DIM_PROVIDER
CREATE OR REPLACE TABLE DIM_PROVIDER (
prvdr_key INTEGER NOT NULL -- surrogate key,
prvdr_npi VARCHAR(10) -- NPI number,
prvdr_tin VARCHAR(10) -- tax ID number,
prvdr_first_nm VARCHAR(100) -- first name,
prvdr_last_nm VARCHAR(100) -- last name,
prvdr_org_nm VARCHAR(255) -- organization name,
prvdr_typ_cd VARCHAR(20) -- provider type code,
prvdr_spclty_cd VARCHAR(10) -- specialty code,
prvdr_tax VARCHAR(10) -- taxonomy code,
prvdr_state_cd CHAR(2) -- state code,
prvdr_zip_cd VARCHAR(10) -- zip code,
prvdr_ntwk_sts VARCHAR(10) -- network status,
prvdr_accpt_pt_ind CHAR(1) -- accepting patients,
prvdr_excl_ind CHAR(1) -- exclusion indicator,
load_dt TIMESTAMP_NTZ NOT NULL -- load timestamp
);
Standard Snowflake DDL for the canonical provider table. Convert to BigQuery or Databricks →
Why This Term Matters
Provider data management is one of the most operationally complex data domains in healthcare because providers move, merge, and update their credentials continuously. A data engineer who understands provider terminology can build NPI validation, credentialing, and network adequacy pipelines that keep provider directories accurate and prevent claim rejections. Stale or incorrect provider data is a leading cause of prior authorization delays and CMS compliance findings.
Related Content
Related Definitions
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms