Skip to main content

Place of Service

ColumnData TypeDescription
Download CSV

Maintenance Instructions​

  1. Navigate to the Place of Service Code Set
  2. Scroll through the page and find the Place of Service Codes for Professional Claims section
  3. Copy and paste the code list into any text editor or spreadsheet
  4. Clean the data: Remove the row with the "Place of Service Name" as “unassigned” from the data
  5. Format the codes as a CSV and save
  6. Import the CSV file into any data warehouse
  7. Upload the CSV file from the data warehouse to S3 (credentials with write permissions to the S3 bucket are required)
-- example code for Snowflake
copy into s3://tuva-public-resources/terminology/place_of_service.csv
from [table_created_in_step_6]
file_format = (type = csv field_optionally_enclosed_by = '"')
storage_integration = [integration_with_s3_write_permissions]
OVERWRITE = TRUE;
  1. Create a branch in docs. Update the last_updated column in the table above with the current date
  2. 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 place_of_service file in GitHub.

  1. Create a branch in The Tuva Project
  2. Alter the headers as needed in place of service file
  3. Submit a pull request