/PDE

Centers for Medicare and Medicaid Services (CMS) Prescription Drug Event (PDE). Using MS SQL.

Primary LanguageTSQL

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