NPPES Enrichment

NPPES enrichment adds detailed practice, credential, specialty, name, and other information to healthcare provider and organization entities.

The National Plan & Provider Enumeration System (NPPES) is a comprehensive, uniform system for identifying and uniquely enumerating health care providers and plans at the national level. The NPPES enrichment service matches healthcare providers and healthcare organizations using National Plan Identifier (NPI) numbers and returns additional attributes, including the business and practice information, endpoints, and NPI lifecycle.

This service is included without additional licensing in the Healthcare Providers data product for provider data, and in the B2B Customers data product for healthcare organization data. For health care organization mastering, we recommend mapping NPI numbers to "Registration Number" in the B2B Customers data product schema. Values mapped to "Registration Number" will be matched against the NPPES database. Match statuses for B2B Customers enrichment is available here.

Output Attributes for NPPES Enrichment

The following attributes are provided by the enricher for each matching provider.

Output Attribute Name Description Available for Provider or Organization
tamr_nppes_enrich_status The status of NPPES enrichment:
  • MATCH_NPI: a match was found, based on exact match of the NPI number
  • MATCH_NAME_ADDRESS: a match was found based on the provider name and full address
  • MATCH_LICENSE_NUMBER: a match was found based on the license number
  • MATCH_NAME_CITY: a match was found based on the provider name and city
  • MATCH_NAME_STATE: a match was found based on the provider name and state
  • MATCH_NAME_PHONE: a match was found based on the provider name and phone number
  • MATCH_EMAIL: a match was found based on the email address
  • DEACTIVATED_NPI: a match was found for the NPI number, but the NPI is marked as deactivated
  • NO_MATCH_MISSING_NPI: no match is possible because the input NPI is empty
  • NO_MATCH: no match was found for the NPI number
Provider only
nppes_tamr_enrich_status The status of the NPPES enrichment:
  • MATCH_NAME_ADDRESS: The enrichment attributes provided by NPPES were matched to this organization based on the organization name and full address.
  • MATCH_NAME_CITY: The enrichment attributes provided by NPPES were matched to this organization based on the organization name, city, country, and either region or postal code.
  • MATCH_HIERARCHY_COUNTRY: The enrichment attributes provided by NPPES were matched this company based on the combination of the organization name, domestic ultimate parent, and country. This match is typically less precise than one based on name and full address.
  • MATCH_REGISTRATION_NUMBER: The enrichment attributes provided by NPPES were matched to this organization based on the organization's registration number (typically the NPI number).
  • MATCH_NAME_COUNTRY: The enrichment attributes provided by NPPES were matched to this organization based on the organization and country.
  • MATCH_PHONE: The enrichment attributes provided by NPPES were matched to this organization based on the cleaned phone number.
  • MATCH_WEBSITE: The enrichment attributes provided by NPPES were matched to this organization based on the cleaned website.
  • NOT_AVAILABLE_IN_SELECTED_SOURCE: NPPES does not have information associated with this organization’s Tamr Enrich ID.
  • UNRECOGNIZED_TAMR_ENRICH ID: Tamr Enrich does not recognize the ID.
  • NO_MATCH_INVALID_NAME: A match was not found due to an invalid organization name. Either the name was empty, or the name contained only special characters or generic legal form information (for example CORP or LLC).
  • NO_MATCH_INVALID_COUNTRY: A match was not found due to an invalid (empty) country.
  • NO_MATCH: A match was not found.

    Note: This value may not match the Tamr Enrich ID tamr_firmographic_match_status. This happens when a higher level match is available in one of the other supported data providers. For example, a match based on “MATCH_NAME_ADDRESS” was found in Pitchbook, and a match based on “MATCH_NAME_COUNTRY” was found in NPPES (the selected provider). In this case, the value of the Tamr Enrich ID tamr_firmographic_match_status is "MATCH_NAME_ADDRESS" while the value of nppes_tamr_enrich_status is "MATCH_NAME_COUNTRY".

Organization only
nppes_npi The National Provider Identifier, which is a unique 10-digit identification number issued to health care providers in the United States by the Centers for Medicare and Medicaid Services (CMS). Both
nppes_entity_type_code The type of provider (type 1 is an individual and type 2 is an organization). Both
nppes_replacement_npi The replacement NPI, if the provider has been issued one. Both
nppes_employer_identification_number_ein The Employer Identification Number, which is a nine-digit number assigned by the IRS. Provider only
nppes_provider_organization_name_legal_business_name The legal business name of the provider’s organization. Both
nppes_provider_last_name_legal_name The provider's legal last name. Provider only
nppes_provider_first_name The provider's first name. Provider only
nppes_provider_middle_name The provider's middle name. Provider only
nppes_provider_name_prefix_text The provider's name prefix, such as Dr., Ms., or Mr. Provider only
nppes_provider_name_suffix_text The provider's name suffix, such as Jr. or Sr. Provider only
nppes_provider_credential_text The provider's credential text, such as MD. Provider only
nppes_provider_other_organization_name The first other name used by this provider's organization, such as a former legal business name or another name under which the organization has done business. Both
nppes_provider_other_organization_name_type_code The code that represents the type of other organization name for the first other name, such as a former legal business name. Both
nppes_provider_other_last_name Other last name used by this provider. Provider only
nppes_provider_other_first_name Other first name used by this provider. Provider only
nppes_provider_other_middle_name Other middle name used by this provider. Provider only
nppes_provider_other_name_prefix_text Other name prefix used by this provider, such as Dr., Ms., or Mr. Provider only
nppes_provider_other_name_suffix_text Other name suffix used by this provider, such as Jr. or Sr. Provider only
nppes_provider_other_credential_text Other credentials for this provider. Provider only
nppes_provider_other_last_name_type_code The code that represents the type of other last name, such as a former or professional name. Provider only
nppes_provider_first_line_business_mailing_address The first line of the provider’s business mailing address. Both
nppes_provider_second_line_business_mailing_address The second line of the provider's business mailing address. Both
nppes_provider_business_mailing_address_city_name The city name of the provider's business mailing address. Both
nppes_provider_business_mailing_address_state_name The state name of the provider's business mailing address. Both
nppes_provider_business_mailing_address_postal_code The postal code of the provider's business mailing address. Both
nppes_provider_business_mailing_address_country_code_if_outside_u_s The country code of the provider's business mailing address, for addresses outside of the United States. Both
nppes_provider_business_mailing_address_telephone_number The telephone number associated with the provider's business mailing address. Both
nppes_provider_business_mailing_address_fax_number The fax number associated with the provider's business mailing address. Both
nppes_provider_first_line_business_practice_location_address The first line of the provider’s business practice location address. Both
nppes_provider_second_line_business_practice_location_address The second line of the provider's business practice location address. Both
nppes_provider_business_practice_location_address_city_name The city name of the provider's business practice location address. Both
nppes_provider_business_practice_location_address_state_name The state name of the provider's business practice location address. Both
nppes_provider_business_practice_location_address_postal_code The postal code of the provider's business practice location address. Both
nppes_provider_business_practice_location_address_country_code_if_outside_u_s The country code of the provider's business practice location address, if the address is outside of the United States. Both
nppes_provider_business_practice_location_address_telephone_number The telephone number associated with the provider's business practice location address. Both
nppes_provider_business_practice_location_address_fax_number The fax number of the provider's business practice location address. Both
nppes_provider_enumeration_date The date on which the NPI was assigned. Both
nppes_last_update_date The date on which the NPI was last updated. Both
nppes_npi_deactivation_reason_code The reason code associated with NPI deactivation, such as DT for Death or DB for disbandment. Both
nppes_npi_deactivation_date The date on which the NPI was deactivated. Both
nppes_npi_reactivation_date The date on which the NPI was reactivated. Both
nppes_provider_gender_code The provider's gender. Provider only
nppes_provider_license_number_1 The provider's medical license number. Both
nppes_provider_license_number_2 The provider's medical license number. Both
nppes_provider_license_number_3 The provider's medical license number. Both
nppes_provider_license_number_4 The provider's medical license number. Both
nppes_provider_license_number_5 The provider's medical license number. Both
nppes_provider_license_number_state_code_1 The state code of the state in which the provider is licensed, such as CA or MA. Both
nppes_provider_license_number_state_code_2 The state code of the state in which the provider is licensed, such as CA or MA. Both
nppes_provider_license_number_state_code_3 The state code of the state in which the provider is licensed, such as CA or MA. Both
nppes_provider_license_number_state_code_4 The state code of the state in which the provider is licensed, such as CA or MA. Both
nppes_provider_license_number_state_code_5 The state code of the state in which the provider is licensed, such as CA or MA. Both
nppes_certification_date The date on which the NPI was certified. Both
nppes_authorized_official_last_name The last name of the authorized official for this provider. Organization only
nppes_authorized_official_first_name The first name of the authorized official for this provider. Organization only
nppes_authorized_official_middle_name The midle name of the authorized official for this provider. Organization only
nppes_authorized_official_title_or_position The title of the authorized official for this provider. Organization only
nppes_authorized_official_telephone_number The telephone number for the authorized official for this provider. Organization only
nppes_num_secondary_practice_addresses The number of secondary practice addresses for the provider. Both
nppes_secondary_practice_address_line_1_1 The first line of secondary practice address 1. Both
nppes_secondary_practice_address_line_2_1 The second line of secondary practice address 1. Both
nppes_secondary_practice_city_name_1 The city name of secondary practice address 1. Both
nppes_secondary_practice_state_name_1 The state name of secondary practice address 1. Both
nppes_secondary_practice_postal_code_1 The postal code of secondary practice address 1. Both
nppes_secondary_practice_country_code_1 The country code of secondary practice address 1, for addresses outside of the United States. Both
nppes_secondary_practice_telephone_number_1 The phone number associated with secondary practice address 1. Both
nppes_secondary_practice_telephone_extension_1 The phone number extension associated with secondary practice address 1. Both
nppes_secondary_practice_fax_number_1 The fax number associated with secondary practice address 1. Both
nppes_secondary_practice_address_line_1_2 The first line of secondary practice address 2. Both
nppes_secondary_practice_address_line_2_2 The second line of secondary practice address 2. Both
nppes_secondary_practice_city_name_2 The city name of secondary practice address 2. Both
nppes_secondary_practice_state_name_2 The state name of secondary practice address 2. Both
nppes_secondary_practice_postal_code_2 The postal code of secondary practice address 2. Both
nppes_secondary_practice_country_code_2 The country code of secondary practice address 2, for addresses outside of the United States. Both
nppes_secondary_practice_telephone_number_2 The phone number associated with secondary practice address 2. Both
nppes_secondary_practice_telephone_extension_2 The phone number extension associated with secondary practice address 2. Both
nppes_secondary_practice_fax_number_2 The fax number associated with secondary practice address 2. Both
nppes_secondary_practice_address_line_1_3 The first line of secondary practice address 3. Both
nppes_secondary_practice_address_line_2_3 The second line of secondary practice address 3. Both
nppes_secondary_practice_city_name_3 The city name of secondary practice address 3. Both
nppes_secondary_practice_state_name_3 The state name of secondary practice address 3. Both
nppes_secondary_practice_postal_code_3 The postal code of secondary practice address 3. Both
nppes_secondary_practice_country_code_3 The country code of secondary practice address 3, for addresses outside of the United States. Both
nppes_secondary_practice_telephone_number_3 The phone number associated with secondary practice address 3. Both
nppes_secondary_practice_telephone_extension_3 The phone number extension associated with secondary practice address 3. Both
nppes_secondary_practice_fax_number_3 The fax number associated with secondary practice address 3. Both
nppes_secondary_practice_address_line_1_4 The first line of secondary practice address 4. Both
nppes_secondary_practice_address_line_2_4 The second line of secondary practice address 4. Both
nppes_secondary_practice_city_name_4 The city name of secondary practice address 4. Both
nppes_secondary_practice_state_name_4 The state name of secondary practice address 4. Both
nppes_secondary_practice_postal_code_4 The postal code of secondary practice address 4. Both
nppes_secondary_practice_country_code_4 The country code of secondary practice address 4, for addresses outside of the United States. Both
nppes_secondary_practice_telephone_number_4 The phone number associated with secondary practice address 4. Both
nppes_secondary_practice_telephone_extension_4 The phone number extension associated with secondary practice address 4. Both
nppes_secondary_practice_fax_number_4 The fax number associated with secondary practice address 4. Both
nppes_secondary_practice_address_line_1_5 The first line of secondary practice address 5. Both
nppes_secondary_practice_address_line_2_5 The second line of secondary practice address 5. Both
nppes_secondary_practice_city_name_5 The city name of secondary practice address 5. Both
nppes_secondary_practice_state_name_5 The state name of secondary practice address 5. Both
nppes_secondary_practice_postal_code_5 The postal code of secondary practice address 5. Both
nppes_secondary_practice_country_code_5 The country code of secondary practice address 5, for addresses outside of the United States. Both
nppes_secondary_practice_telephone_number_5 The phone number associated with secondary practice address 5. Both
nppes_secondary_practice_telephone_extension_5 The phone number extension associated with secondary practice address 5. Both
nppes_secondary_practice_fax_number_5 The fax number associated with secondary practice address 5. Both
nppes_num_othernames The number of other names used by this provider's organization. Both
nppes_othernames_provider_other_organization_name_1 Other name 1 used by this provider's organization. Both
nppes_othernames_provider_other_organization_name_2 Other name 2 used by this provider's organization. Both
nppes_othernames_provider_other_organization_name_3 Other name 3 used by this provider's organization. Both
nppes_othernames_provider_other_organization_name_4 Other name 4 used by this provider's organization. Both
nppes_othernames_provider_other_organization_name_5 Other name 5 used by this provider's organization. Both
nppes_othernames_provider_other_organization_name_type_code_1 The code that represents the type of other organization name 1, such as a former legal business name. Both
nppes_othernames_provider_other_organization_name_type_code_2 The code that represents the type of other organization name 2, such as a former legal business name. Both
nppes_othernames_provider_other_organization_name_type_code_3 The code that represents the type of other organization name 3, such as a former legal business name. Both
nppes_othernames_provider_other_organization_name_type_code_4 The code that represents the type of the other organization name 4, such as a former legal business name. Both
nppes_othernames_provider_other_organization_name_type_code_5 The code that represents the type of the other organization name 5, such as a former legal business name. Both
nppes_num_endpoints The number of endpoints for this provider. Endpoints provide a simple, secure, scalable, and standards-based way to send authenticated, encrypted health information directly to known, trusted recipients over the Internet. Both
nppes_endpoint_type_1 The type of endpoint for endpoint 1, such as address for direct messaging, RESTful URL, SOAP URL, and so on. Both
nppes_endpoint_type_description_1 The description of endpoint 1. Both
nppes_endpoint_1 Endpoint 1 for sending authenticated, encrypted healthcare informaion over the Internet. Both
nppes_endpoint_type_2 The type of endpoint for endpoint 2, such as address for direct messaging, RESTful URL, SOAP URL, and so on. Both
nppes_endpoint_type_description_2 The description of endpoint 2. Both
nppes_endpoint_2 Endpoint 2 for sending authenticated, encrypted healthcare informaion over the Internet. Both
nppes_endpoint_type_3 The type of endpoint for endpoint 3, such as address for direct messaging, RESTful URL, SOAP URL, and so on. Both
nppes_endpoint_type_description_3 The description of endpoint 3. Both
nppes_endpoint_3 Endpoint 3 for sending authenticated, encrypted healthcare informaion over the Internet. Both
nppes_endpoint_type_4 The type of endpoint for endpoint 4, such as address for direct messaging, RESTful URL, SOAP URL, and so on. Both
nppes_endpoint_type_description_4 The description of endpoint 4. Both
nppes_endpoint_4 Endpoint 4 for sending authenticated, encrypted healthcare informaion over the Internet. Both
nppes_endpoint_type_5 The type of endpoint for endpoint 5, such as address for direct messaging, RESTful URL, SOAP URL, and so on. Both
nppes_endpoint_type_description_5 A description of endpoint 5. Both
nppes_endpoint_5 Endpoint 4 for sending authenticated, encrypted healthcare informaion over the Internet. Both
nppes_primary_healthcare_provider_taxonomy_code The primary taxonomy code for the provider, which is a unique 10-character code that designates a provider's classification and specialization. Both
nppes_primary_healthcare_provider_taxonomy_description The description of the provider's primary specialty, based on their primary taxonomy code. Both
nppes_other_specialties_descriptions (Deprecated; not included in data product output) The description of the provider's additional specialty, based on their non-primary taxonomy code. Both
nppes_other_specialties_code (Deprecated; not included in data product output) An additional taxonomy code for the provider, which is a unique 10-character code that designates a provider's classification and specialization. Both
nppes_other_specialties_code_1 Other speciality code 1 for the provider, which is a unique 10-character code that designates a provider's classification and specialization. Both
nppes_other_specialties_code_2 Other speciality code 2 for the provider, which is a unique 10-character code that designates a provider's classification and specialization. Both
nppes_other_specialties_code_3 Other speciality code 3 for the provider, which is a unique 10-character code that designates a provider's classification and specialization. Both
nppes_other_specialties_code_4 Other speciality code 4 for the provider, which is a unique 10-character code that designates a provider's classification and specialization. Both
nppes_other_specialties_code_5 Other speciality code 5 for the provider, which is a unique 10-character code that designates a provider's classification and specialization. Both
nppes_other_specialties_descriptions_1 The description of the provider's other specialty 1, based on their non-primary taxonomy code. Both
nppes_other_specialties_descriptions_2 The description of the provider's other specialty 2, based on their non-primary taxonomy code. Both
nppes_other_specialties_descriptions_3 The description of the provider's other specialty 3, based on their non-primary taxonomy code. Both
nppes_other_specialties_descriptions_4 The description of the provider's other specialty 4, based on their non-primary taxonomy code. Both
nppes_other_specialties_descriptions_5 The description of the provider's other specialty 5, based on their non-primary taxonomy code. Both