README.md

PDE

Centers for Medicare and Medicaid Services (CMS) Prescription Drug Event file processing
Developed in MS SQL

http://cms.hhs.gov/Medicare/Prescription-Drug-Coverage/PrescriptionDrugCovContra/RxContracting_ReportingOversight.html

ImportPDE
Imports the detail records from the PDE submission file into a SQL table. (requires function nCobol2Int)

fnCobol2Int
Converts the PDE amount format (olde COBOL format!) to integer

SQLCreate_tbl_PDE_Edit
Creates and populates the PDE edit table

ImportPDE_Reject
Imports a PDE reject file, updates the PDE reject flag in tbl_PDE and sends an email containing a spreadsheet with the reject errors