Finding 2024-002
Bridges Interface Controls
Management Views
DTMB disagrees with the condition and the effect of the OAG’s finding. The OAG sampled 85 total files across eight interfaces. Of these, seven appeared to present issues. For five of the sampled files, detailed exception results no longer...
Finding 2024-002
Bridges Interface Controls
Management Views
DTMB disagrees with the condition and the effect of the OAG’s finding. The OAG sampled 85 total files across eight interfaces. Of these, seven appeared to present issues. For five of the sampled files, detailed exception results no longer existed. DTMB maintains summary tables for 10 years and purges detailed exception records at the beginning of each calendar year for anything older than 12 months. This purge process was communicated to the OAG during the fiscal year 2022 audit, and sampling was performed prior to purging for the fiscal year 2023 audit. When informed that the sample included files for which the detailed exception records had been purged, the OAG requested DTMB run a simulation processing of the original interface file in a testing environment to recreate detailed exception records. DTMB’s technical teams informed the OAG that rerunning in the current test environment would likely differ from the original results due to code changes that occurred in the test environment subsequent to when the original interface files were run in production. The OAG requested DTMB to proceed with rerunning the files in the current test environment. As a result, the OAG identified five instances where the detailed exception records from the simulation in the test environment did not exactly match the summary table from the original production interface results.
For the 2 remaining files out of 85 (2.4 percent) that were cited, it should be clarified that the reconciliation being discussed is not data that was lost or misplaced between systems, but reconciliation of two exceptions correctly logged and correctly not counted in a summary report because they were alerts during processing, not errors that would be forwarded for review. These results do not present a significant deficiency in the ability of MDHHS to review the detailed exceptions. Also, these 2 records are insignificant when compared to the 11.6 million records processed in the 85 sampled files (0.000001 percent). Therefore, the current controls are reasonable to ensure that data processed from the source system to the receiving system is processed accurately, completely, and timely.
Planned Corrective Action
DTMB disagrees with the finding and does not intend to take further action.
Anticipated Completion Date
Not applicable
Responsible Individual(s)
Nathan Buckwalter, DTMB