Features of Healthcare Providers Mastering

This template enhances your data with NPPES enrichment and standardized address values, and consolidates similar records into grouped entities.

About the Data Quality and Enrichment Services

The healthcare providers mastering template includes these data quality and enrichment services:

  • Address Standardization, Validation, and Geocoding. This service examines values for the template's address attributes, and adds any resulting validated, standardized values to each record in new enrichment-specific attributes. The original values mapped from your source datasets remain present and unchanged.
  • NPPES Enrichment. This service matches each mastered healthcare provider to a National Provider Identifier (NPI), and adds detailed practice, credential, specialty, name, and other information from the National Plan & Provider Enumeration System (NPPES).

See the linked topics above for processing details and added attributes.

About the Clustering Model

The healthcare providers mastering model groups records as follows:

First, by trusted_id. Records with the same trusted_id are always clustered together. Records with different trusted_ids are never clustered together.

Records with null/empty trusted_id are clustered based on similarity, meaning that they may be clustered with records that have a trusted _id.

Then, by similarity.
Records with null or empty trusted_ids are clustered based on similarities between these attribute fields:

  • Full address
  • Street address
  • City
  • Region
  • Country code
  • Postal code
  • First three digits of the postal code
  • Phone Number
  • First name
  • Last name
  • Middle name
    Note: Records that are highly similar but have different middle name values will not be grouped together, unless these records have the same trusted_id.
  • Name suffix
  • Organization name
  • Speciality
  • Credentials

Note: Generic descriptions, rather than specific attribute names, are listed to represent both the standard schema and the attributes added by the enrichers and other data transformations.