Source Dataset Requirements for the Healthcare Providers Data Product

The Healthcare Providers data product includes a predefined, standardized schema for provider data. When you add data to your data product, you identify how columns in your source datasets correspond to the attributes in the unified schema.

To prepare, review the general Requirements for Source Datasets.

The tables below describe these attributes and explains which are:

  • Required: You cannot refresh your data until you map source columns to these attributes.
  • Suggested: For optimal enrichment and clustering results, map source columns to these attributes.
  • Optional: These attributes have minimal impact on your clustering and enrichment results. If your source data includes columns that match these attributes, map them to include that source data in your completed data product.

Attributes Other than Addresses

Note that the matching model can use either the combination of first and last name values or full name values, whichever is mapped from the source data.

Unified Attribute Description Type
Primary Key The primary key used in the source dataset to uniquely identify each record. See About Primary Keys for more information. Required
NPI National Provider Identifier. Suggested
Full Name The provider's full name. Either Full Name or First Name is Required
First Name The provider's first name. Either Full Name or First Name is Required
Middle Name The provider's middle name. Optional
Family Name The provider's last name. Suggested
Name Prefix Prefix for the provider's name. Optional
Name Suffix The provider's suffix, such as Jr. or Senior. Optional
Gender The provider's gender. Suggested
Phone The provider's phone number. Suggested
Email The provider's email. Suggested
Date of Birth The provider's date of birth. Suggested
Organization Name The name of the provider's organization. Optional
Credentials The provider's credentials. Optional
Degree The provider's degree of education. Optional
Graduation Year The provider's graduation year. Suggested
License Number The provider's license number. Suggested
License State The state where the provider was licensed. Suggested
License State The provider's license status. Optional
Provider Specialty The provider's specialty. Suggested

Address Attributes

You can configure multiple address types in the Healthcare Providers data product. Address attributes are organized into different groups, representing different types of addresses associated with the healthcare providers.

The data product schema includes Primary address attributes by default. You can choose to include attributes for additional address types, including: office, corporate, previous, mailing, shipping, registered, billing, and other addresses.

Within an attribute group, the attribute name is prefixed with the address type. For example: Primary: Address, Billing: City, and Mailing: Country.

Each attribute group includes the following address attributes:

Unified Address Attribute Description Type
Address Either line 1 of the address, or the complete address. Suggested for primary address. Optional for other address types.
Address Line 2 Line 2 of the address. Optional
City City of the address. Optional
State The state or region of the address. Optional
Postal Code Postal (zip) code of the address. Optional
Country Country of the address. Suggested for primary address. Optional for other address types.
Latitude The latitude of the address. Optional
Longitude The longitude of the address. Optional