HCPCS Level 2

Column	Data Type	Description

Download CSV

Maintenance Instructions

1. Navigate to the CMS HCPCS Quarterly Update page

2. Download the latest ZIP file available.

3. Extract the file named HCPC<year>_<month>_ANWEB.xlsx from the ZIP.
   This is the only file needed.

4. Load the extracted Excel file into your data warehouse.

5. Transform the uploaded data into a new table that matches the Tuva Terminology standard:

   Source Column	Tuva Column
   hcpc	hcpcs
   seqnum	seqnum
   recid	recid
   long description	long_description
   short description	short_description

   • Ensure that null values are properly represented as null, not blank strings ('').

6. Unload the table to S3 as a .csv file (requires credentials with write permissions to the bucket):

-- example code for Snowflake
copy into s3://tuva-public-resources/terminology/hcpcs_level_2.csv
from 
(  select hcpcs, seqnum, recid, substr(long_description, 1, 2000), short_description
   from [table_created_in_step_5]
)
file_format = (type = csv field_optionally_enclosed_by = '"')
storage_integration = [integration_with_s3_write_permissions]
overwrite = true;

7. Create a branch in docs. Update the last_updated column in the table above with the current date
8. 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.

1. Create a branch in The Tuva Project
2. Copy and paste the updated header into the HCPCS Level II file
3. Submit a pull request