Centers for Medicare and Medicaid Services (CMS) Risk Adjustment Processing System (RAPS) Files
ImportRAPSResponse.sql:
Imports a RAPS response file into RAPSResponseIn (a staging table)
Then parses out the AAA, BBB, CCC, YYY & ZZZ records into separate tables:
RAPSResponseAAA - File Header
RAPSResponseBBB - Batch Header
RAPSResponseCCC - Detail (up to 10 diagnoses in each record)
RAPSResponseYYY - Batch Trailer
RAPSResponseZZZ - File Trailer
TransformRAPSResponse.sql:
Creates 1 record in RAPSResponseDDD for each diagnoses in RAPSResponseCCC
File layout is located here:
https://www.cms.gov/Regulations-and-Guidance/Guidance/Transmittals/Downloads/R116MCM.pdf
at page 16
fileparse.py
A script to split out the response files from multiple files per file to a single file per output file.