What to do when two different providers have the same NPI.
Issue # and location
Issue summary
While we should only have one records per provider in the PROVIDER table it is possible for the NPI to be duplicated.
Convention type
Table
CDM table
PROVDER
CDM field
NA
Links to issue discussion
- NPI for Multiple Physicians #44
- Multiple Provider Specialities #43
- This states we can only have one record
- CDM GitHub.io PROVIDER
- Mapping Facility NPI #s into the Care_Site table?
- Although this is about CARE_SITES not providers
- Provider table
- Seems to be a fair amount of discussion about what happens when you have multiple records for one provider with same NPI
Provenance of data
General
The ratified convention
The PROVIDER table contains a list of uniquely identified healthcare providers. However, duplicate NPI numbers may occur because the source data might provide the NPI representing the care site rather than the individual provider’s NPI. NPI should not represent a primary key within the PROVIDER table.
Date of ratification/published
June 2018
Downstream implications
NA
Link to DQD check
NA
Related conventions/further information
- NPI = National Provider Identifier
- not a primary key, it can be duplicated, but each provider should only have one record in the provider table.
- provider THEMIS rule , NPI THEMIS rule