Provider
Column | Data Type | Description |
---|
Maintenance Instructions
FYI: Terminologies Provider
and Other Provider Taxonomy
both will be updated simultaneously from same source data
-
Download the latest source files from the following locations:
-
NPPES Data Dissemination (monthly):
https://download.cms.gov/nppes/NPI_Files.html -
NUCC Health Care Provider Taxonomy (semi-annually in January and July):
https://nucc.org/index.php/code-sets-mainmenu-41/provider-taxonomy-mainmenu-40/csv-mainmenu-57 -
CMS Medicare Provider and Supplier Taxonomy Crosswalk (annually):
https://data.cms.gov/provider-characteristics/medicare-provider-supplier-enrollment/medicare-provider-and-supplier-taxonomy-crosswalk
-
-
Load the downloaded data into your data warehouse. These three files should be in three tables in a schema of your database.
- NPPES NPI Data (Note: source data comes zipped with many files, only the "npidata_pfile....csv" and "othername_pfile....csv" are required.)
- Snowsql may be used to load large file from local machine to snowflake.
- NUCC Health Care Provider Taxonomy
- CMS Medicare Provider and Supplier Taxonomy Crosswalk
- NPPES NPI Data (Note: source data comes zipped with many files, only the "npidata_pfile....csv" and "othername_pfile....csv" are required.)
-
Follow the steps outlined in the README here:
https://github.com/tuva-health/provider
You should have exported the seed to an S3 bucket by now
- Create a branch in docs. Update the
last_updated
column in the table above with the current date - Submit a pull request
The below steps are only required if the headers of the file need to be changed. The Tuva Project does not store the contents of the terminology file in GitHub.
- Create a branch in The Tuva Project
- Copy and paste the updated header into the Provider file
- Submit a pull request