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. Mapping ONLY required attributes does not provide sufficient information for clustering or enrichment.
- Suggested: For optimal enrichment and clustering results, map source columns to as many of these attributes as possible.
- 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, Licenses, Phone Numbers, and Emails
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. | You are required to map either the first and family name or the full name attributes. |
First Name | The provider's first name. | You are required to map either the first and family name or the full name attributes. |
Middle Name | The provider's middle name. | Optional |
Family Name | The provider's last name. | You are required to map either the first and family name or the full name attributes. |
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 |
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 |
Provider Specialty | The provider's specialty. | Suggested |
Address Attributes
You can configure multiple address types. Address attributes are organized into different groups, representing different types of addresses associated a person.
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
- Other
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 |
Address Line 3 | Line 3 of the address. | Optional |
Address Line 4 | Line 4 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 |
Provider License Attributes
You can configure up to 20 provider licenses. For each license, you can provide the following attribute:
Unified License Attribute | Description | Type |
---|---|---|
License: Number | The provider's license number. | Suggested |
License: State | The state where the provider was licensed. | Suggested |
License: Country | The country where the provider was licensed. | Suggested |
License: Status | The provider's license status. | Optional |
Phone Attributes
You can configure multiple phone number types. Phone number attributes are organized into different groups, representing different types of phone numbers associated with a person.
The data product schema includes Mobile phone number attributes by default. You can choose to include attributes for additional phone number types, including:
- Home
- Work
- Office
- Other
Within an attribute group, the attribute name is prefixed with the phone number type (for example: Mobile: Phone
).
Each phone number group includes the following attribute:
Unified Phone Attribute | Description | Type |
---|---|---|
Phone | Phone number. | Suggested for mobile number. Optional for other phone numbers. |
Email Attributes
You can configure multiple email address types. Email address attributes are organized into different groups, representing different types of email addresses associated with a person.
The data product schema includes Personal email address attributes by default. You can choose to include attributes for additional email address types, including:
- Work
- Office
- Other
Within an attribute group, the attribute name is prefixed with the email address type (for example: Personal: Email
).
Each email address group includes the following attributes:
Unified Email Attribute | Description | Type |
---|---|---|
Email address. | Suggested for personal email. Optional for other email addresses. |
Updated 7 days ago