aquaroyal72/cms_raps

Centers for Medicare and Medicaid Services (CMS) Risk Adjustment Processing System (RAPS) Files

CMS_RAPS

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.