NPPES Provider Taxonomy and License Numbers
Snowflake table name : CYBERSYN.NPPES_PROVIDER_TAXONOMY_AND_LICENSE_NUMBERS
| Name | Description | Type | Example |
|---|---|---|---|
| National Provider Identifier, which is a unique id assigned to a provider by the CMS National Plan and Provider Enumeration System | NUMBER |
|
| Healthcare provider taxonomy identifier designed to categorize the type, classification, and specialization of providers, maintained by the National Uniform Claim Committee (NUCC) | VARCHAR |
|
| Boolean field indicating whether taxonomy listed in the same row is the primary taxonomy for the particular NPI | BOOLEAN |
|
| A major grouping of services or occupations of health care providers. This is the broadest level of taxonomy | VARCHAR |
|
| A more specific service or occupation related to the provider grouping. This is the middle level of taxonomy | VARCHAR |
|
| A more specialized area of the classification in which a provider chooses to practice or make services available. This is the most granular level of taxonomy | VARCHAR |
|
| Description of the practice type which may include group with members having one taxonomy (single specialty), multiple taxonomies (multi-specialty), or multiple locations and taxonomies (multiple single). | VARCHAR |
|
| State-issues license number for a medical provider. | VARCHAR |
|
| State abbreviation where provider license number was issues. | VARCHAR |
|
| Unique US state or territory geographic identifier joinable to the geography_index and geography_relationships tables | VARCHAR |
|
Last updated