Medicare OREC
Column | Data Type | Description |
---|
Maintenance Instructions
- Navigate to the Medicare OREC.
- Scroll through the page and find the code and code value table section.
- Copy and paste the code list into any text editor or spreadsheet.
- Format the codes as a CSV and save
- Import the CSV file into any data warehouse
- 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/medicare_orec.csv
from [table_created_in_step_5]
file_format = (type = csv field_optionally_enclosed_by = '"')
storage_integration = [integration_with_s3_write_permissions]
OVERWRITE = TRUE;
- 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 medicare_orec file in GitHub.
- Create a branch in The Tuva Project
- Alter the headers as needed in medicare_orec file
- Submit a pull request