2012 navy medicine audit readiness training symposium
Post on 19-Jan-2016
21 Views
Preview:
DESCRIPTION
TRANSCRIPT
DQ MEPRS Audit ReadinessDQ MEPRS Audit Readiness
2012 Navy Medicine Audit Readiness Training Symposium
MEPRS Processing – PETRA and R2DQ
RE-W-3-B
DQ MEPRS Audit Readiness
Context: MEPRS Reporting Procedures. Purpose: To teach the audience how to
leverage the PETRA/R2DQ process for EAS reporting and analysis.
Outcome: Improve knowledge on the benefits these tools have to improve EAS data and assist in the managerial accounting decisions at the local level.
FOR OFFICIAL USE ONLY 2
DQ MEPRS Audit Readiness
MEPRS Processing – PETRA and R2DQ
Mr. Marshall Letter of 27 Jan 2012 formalizes MEPRS Processing.
Pre-EAS Transmission approval via the PETRA.
Post-EAS Transmission Financial Reconciliation via the R2DQ.
FOR OFFICIAL USE ONLY 3
DQ MEPRS Audit Readiness
MEPRS Processing – PETRA and R2DQ Goals for the new process: - Comply w/TMA 45 day transmission
deadline. - Reduction/elimination of reprocessing. - Reduced MEWACs outliers. - Improved DQ alignment in MEPRS/EAS data. - Reduce/eliminate DMHRSi mismatched JONs. - R2DQ Financial Reconciliation more timely
submission and compliance.
FOR OFFICIAL USE ONLY 4
DQ MEPRS Audit Readiness
Transmission Compliance
FOR OFFICIAL USE ONLY 5
DQ MEPRS Audit Readiness
Transmission Compliance Number of Days to Initial Transmission
FOR OFFICIAL USE ONLY 6
DQ MEPRS Audit Readiness
EAS Transmissions Average
FOR OFFICIAL USE ONLY 7
DQ MEPRS Audit Readiness
Goal – Reduction of Reprocessing
FOR OFFICIAL USE ONLY 8
DQ MEPRS Audit Readiness
Goal – Reduction of Reprocessing
FOR OFFICIAL USE ONLY 9
DQ MEPRS Audit Readiness
MEWACS OutlierUnallocated Expenses
FOR OFFICIAL USE ONLY 10
From MEWACS Executive Summary
DQ MEPRS Audit Readiness
MEWACS Outliers
FOR OFFICIAL USE ONLY 11
DQ MEPRS Audit Readiness
MEWACS OUTLIERS
FOR OFFICIAL USE ONLY 12
Army: 7 Sites
Navy: 3 Sites
Air Force: 7 Sites
From MEWACS FY12 FM05 Executive Summary
DQ MEPRS Audit Readiness
DQ Checks FY 11 and 12 2nd Quarter FY 12 BSO 18 DQ Checks
7 yellow flagged items, 3 explained by ERSAs (we don’t report inpatient ERSA workload) for a total of 4 DQ issues
2nd Quarter FY 11 BSO 18 DQ Checks 40 red and yellow flagged items
FOR OFFICIAL USE ONLY 13
NEW PROCESS RESULTED IN 90% REDUCTION OF BSO 18MEPRS DATA QUALITY ISSUES
DQ MEPRS Audit Readiness
DMHRSi Mismatched JONJune 2011
FOR OFFICIAL USE ONLY 14
DQ MEPRS Audit Readiness
DMHRSi Mismatched JONApril 19, 2012
FOR OFFICIAL USE ONLY 15
DQ MEPRS Audit Readiness
R2DQ Financial Reconciliation Prior to new R2DQ, Financial Reconciliation could
not be done until NAVMISSA loaded the data in the Fin Recon website (2-4 weeks after EAS transmission).
With the new process, the SMART R2DQ file is available every day. EAS R2DQ can be run the day after EAS transmission.
R2DQ can be run day after EAS Transmission and updated day after revised SMART DMHRSi file.
FOR OFFICIAL USE ONLY 16
DQ MEPRS Audit Readiness
R2DQ Financial Reconciliation Allows for 100% military labor reconciliation. Next month’s PETRA is not approved until there is
an approved R2DQ for the previous month. R2DQ is not approved with any military labor
difference. This ensures that MEPRS data is correct and
reconciled before the next month’s data is transmitted, avoiding retransmissions and un-reconciled military labor.
FOR OFFICIAL USE ONLY 17
DQ MEPRS Audit Readiness
R2DQ Financial Reconciliation How can the PETRA show no difference in the
financial DEAR and Pure, but the R2DQ show financial differences?
What are some reasons why the military labor does not reconcile on the R2DQ?
FOR OFFICIAL USE ONLY 18
DQ MEPRS Audit Readiness
R2DQ Financial Reconciliation R2DQ can NOT have financial differences if the
PETRA shows no difference, UNLESS:1.Something was changed after PETRA approval
but before transmission (and no new PETRA was submitted), OR
2.Source DEAR or Pure financial data was manipulated (i.e. lines were deleted).
FOR OFFICIAL USE ONLY 19
DQ MEPRS Audit Readiness
Military Labor ReconciliationWhy might military labor not reconcile?Mismatched JONs
Common occurrence in FY 12 – a military labor JON was removed from STARS. If a JON has been used in DMHRSi for ANY month in the FY, it must not be removed from STARS.
Text file was manipulated/data changed AFTER NMSC DMHRSi team reviewed.
File provided to DMHRSi SMART not the same file as DMHRSi file imported into EAS.
Updated R2DQ SMART file was not retrieved and loaded to the R2DQ.
FOR OFFICIAL USE ONLY 20
DQ MEPRS Audit Readiness
Points of Contact Colleen Rees, Colleen.Rees@med.navy.mil, 202-762-3538
Randy Van Nostrand, Randy.VanNostrand.ctr@med.navy.mil, 703-773-7312 ext. 602
Kate Burchess, Kathryn.Burchess.ctr@med.navy.mil, 703-773-7312 ext 104
Bonnie Rehbein, Bonnie.Rehbein.ctr@med.navy.mil, 703-773-7312 ext. 603
FOR OFFICIAL USE ONLY 21
DQ MEPRS Audit Readiness
Questions
FOR OFFICIAL USE ONLY 22
top related