The federal Centers for Medicare and Medicaid Services (CMS) publishes a wide range of information on U.S. hospitals, which all carry the unique identifier, the CCN number (CMS Certification Number)*. On the other hand (which often seems to not know what its counterpart is doing), CMS also publishes the frequently updated NPPES database (National Plan and Provider Enumeration System), commonly known as the NPI Registry, which uses the NPI number (National Provider Identifier) as its unique identifier. While hospitals and other medical organizations will have only one CCN Number, they are required to have at least one NPI number, and they're permitted to have as many as they like (and they do seem to like quite a few).
And, between these two ID systems, the CCN and the NPI, ne'er the twain shall meet.
CarePrecise has developed a sophisticated system to "roll up" an organization's NPI-numbered records with its CCN number (and with the PAC ID for practice groups, which stands for "PECOS Associate Control ID"). This mighty trick produces some eye-opening data, such as contact names and titles, license information, specializations, market data added by CarePrecise to NPI records, and the ability to crossmatch groups to their members and hospital affiliations, directly from their NPI numbers. It also permits integration across the complete line of CarePrecise provider data packages, and all of the information that CarePrecise collects or creates and then merges to the NPI records.
Currently, these CarePrecise rollups (or "crosswalks" if you prefer) are the only available such thing in a relatively comprehensive dataset. The full rollup of all medical facility NPI numbers is available for hospitals, and a single "priority" NPI number is currently available for practice groups, with a full rollup of all PAC ID-to-NPI linkages in development with a tentative release date in May 2023.
The hospital CCN-to-NPI crosswalk is part of the Authoritative Hospital Database (APD), and the Group PAC ID-to-NPI link is part of the Authoritative Physician Database (APD) and CarePrecise Platinum.
The "rolling up" is made possible by several CarePrecise innovations, starting with the CoLoCode (co-location code) affixed to almost every provider in the 7 million+ record CarePrecise master reference database. To fill in additional linkages, the Placekey is used. Placekey is a unique "point of interest" identifier, also attached to essentially every one of the 7 million+ CarePrecise provider records, which can readily be used to link data between data suppliers for a variety of purposes.
* The CMS Certification Number has replaced the term Medicare Provider Number, Medicare Identification Number or OSCAR Number. The CCN is used to verify Medicare/Medicaid providers for survey and certification, assessment-related activities and communications. Note that CarePrecise includes the old OSCAR Number in its CarePrecise Complete and CarePrecise Advanced/Platinum datasets, if reported by the provider in their NPI record(s) or available through third-parties, but this is a small fraction of records, and the OSCAR numbers have changed, hence the need for a CCN-to-NPI crosswalk.