The PROVIDER table contains a list of uniquely identified healthcare providers. These are individuals providing hands-on healthcare to patients, such as physicians, nurses, midwives, physical therapists etc.

It is assumed that every provider with a different unique identifier is in fact a different person and should be treated independently.

Provider Name

This is the National Provider Number issued to health care providers in the US by the Centers for Medicare and Medicaid Services (CMS).

This is the identifier issued by the DEA, a US federal agency, that allows a provider to write prescriptions for controlled substances.

This field either represents the most common specialty that occurs in the data or the most specific concept that represents all specialties listed, should the provider have more than one. This includes physician specialties such as internal medicine, emergency medicine, etc. and allied health professionals such as nurses, midwives, and pharmacists.

This is the location that the provider primarily practices in.

Year of Birth

This field represents the recorded gender of the provider in the source data.

Use this field to link back to providers in the source data. This is typically used for error checking of ETL logic.

This is the kind of provider or specialty as it appears in the source data. This includes physician specialties such as internal medicine, emergency medicine, etc. and allied health professionals such as nurses, midwives, and pharmacists.

This is often zero as many sites use proprietary codes to store physician speciality.

This is provider's gender as it appears in the source data.

This is often zero as many sites use proprietary codes to store provider gender.

The PROVIDER table contains a list of uniquely identified healthcare providers. These are individuals providing hands-on healthcare to patients, such as physicians, nurses, midwives, physical therapists etc.

It is assumed that every provider with a different unique identifier is in fact a different person and should be treated independently.

Provider Name

This is the National Provider Number issued to health care providers in the US by the Centers for Medicare and Medicaid Services (CMS).

This is the identifier issued by the DEA, a US federal agency, that allows a provider to write prescriptions for controlled substances.

This field either represents the most common specialty that occurs in the data or the most specific concept that represents all specialties listed, should the provider have more than one. This includes physician specialties such as internal medicine, emergency medicine, etc. and allied health professionals such as nurses, midwives, and pharmacists.

This is the location that the provider primarily practices in.

Year of Birth

This field represents the recorded gender of the provider in the source data.

Use this field to link back to providers in the source data. This is typically used for error checking of ETL logic.

This is the kind of provider or specialty as it appears in the source data. This includes physician specialties such as internal medicine, emergency medicine, etc. and allied health professionals such as nurses, midwives, and pharmacists.

This is often zero as many sites use proprietary codes to store physician speciality.

This is provider's gender as it appears in the source data.

This is often zero as many sites use proprietary codes to store provider gender.

The PROVIDER table contains a list of uniquely identified healthcare providers. These are individuals providing hands-on healthcare to patients, such as physicians, nurses, midwives, physical therapists etc.

It is assumed that every provider with a different unique identifier is in fact a different person and should be treated independently.

Provider Name

This is the National Provider Number issued to health care providers in the US by the Centers for Medicare and Medicaid Services (CMS).

This is the identifier issued by the DEA, a US federal agency, that allows a provider to write prescriptions for controlled substances.

This field either represents the most common specialty that occurs in the data or the most specific concept that represents all specialties listed, should the provider have more than one. This includes physician specialties such as internal medicine, emergency medicine, etc. and allied health professionals such as nurses, midwives, and pharmacists.

This is the location that the provider primarily practices in.

Year of Birth

This field represents the recorded gender of the provider in the source data.

Use this field to link back to providers in the source data. This is typically used for error checking of ETL logic.

This is the kind of provider or specialty as it appears in the source data. This includes physician specialties such as internal medicine, emergency medicine, etc. and allied health professionals such as nurses, midwives, and pharmacists.

This is often zero as many sites use proprietary codes to store physician speciality.

This is provider's gender as it appears in the source data.

This is often zero as many sites use proprietary codes to store provider gender.