DQ MEPRS Audit Readiness
FCC Validation and DMLSS
RE-W-3-C
2012 Navy Medicine Audit Readiness Training Symposium
DQ MEPRS Audit Readiness
Context: Audit Readiness requires database alignment for workload (CHCS/AHLTA), personnel (DMHRSi), facility/supplies/equipment (DMLSS) and financial accounts (STARS-FL/SMART/EAS).
Purpose: Educate audience on the FCC Validation Tool improve DQ and EAS reporting.
Outcome: Audience will take corrective actions to align data bases and/or comply with policy.
FOR OFFICIAL USE ONLY 2
DQ MEPRS Audit Readiness
FCC Validation Created 2011 to highlight system
alignment issues. Upgraded 2012 to include
- minimum workload requirement highlights, - Job Order Number details.
FOR OFFICIAL USE ONLY 3
DQ MEPRS Audit Readiness
FCC Validation Published quarterly on the DQ SharePoint. The tool provides multiple filters to enable
users to focus on the relevant source system relationships, minimum workload, square footage, JONs, and database synchronization.
Sites will correct the issues that are flagged before the next update.
FOR OFFICIAL USE ONLY 4
DQ MEPRS Audit Readiness
FCC Validation
FOR OFFICIAL USE ONLY 5
https://es.med.navy.mil/bumed/nmdq/default.aspx
Each Quarterly FCC Validation is on the DQ SharePoint
DQ MEPRS Audit Readiness
FCC Validation
FOR OFFICIAL USE ONLY 6
Quarterly Validations
Validation reference contains explanations of the fields
DQ MEPRS Audit Readiness
FCC Validation Demonstration, Explanation, Discussion and
Questions on FCC Validation How to address the “I’m special” communities
FOR OFFICIAL USE ONLY 7
DQ MEPRS Audit Readiness
DMLSS Items of Interest Myth Busters: Myth 1: DMLSS doesn’t have anything to do
with MEPRS. Fact: MEPRS receives DMLSS financial
transactions via STARS for supplies, pharmaceuticals and equipment purchased via DMLSS
How are these purchases tracked?
FOR OFFICIAL USE ONLY 8
DQ MEPRS Audit Readiness
DMLSS Items of Interest Myth 2: DMLSS Customer Number must
contain the 4th Level MEPRS code. Fact: This has been a convention with many
sites but is NOT required.
FOR OFFICIAL USE ONLY 9
DQ MEPRS Audit Readiness
DMLSS Items of Interest Myth 3: Resources Shop doesn’t have
anything to do with DMLSS. Fact: The Customer ID table contains MEPRS
code and Expense Center. The Expense Center is the JON. Resource Shop is responsible for ensuring these data are correct. Additionally, each catalog has JONs that must be maintained.
FOR OFFICIAL USE ONLY 10
DQ MEPRS Audit Readiness
DMLSS Items of Interest Myth 4: MEPRS Coordinator plays no part in
DMLSS. Fact: MEPRS Coordinator has a vested interest in
working with DMLSS staff to ensure 1. The correct MEPRS codes are on
each room on the blueprints for the facility, to ensure accurate square footage, AND
2. The capital equipment (depreciable equipment) has the correct MEPRS code., to ensure depreciation is calculated correctly.
FOR OFFICIAL USE ONLY 11
DQ MEPRS Audit Readiness
DMLSS Items of Interest DMLSS Tables of Interest to MEPRS
Coordinators, Catalog – JONs, Room Inventory MEPRS codes – Square
Footage, Equipment Inventory MEPRS codes –
Depreciation.
FOR OFFICIAL USE ONLY 12
DQ MEPRS Audit Readiness
DMLSS Items of Interest An upcoming addition to DMLSS will include
DMIS ID, which will make obtaining reports for square footage and capital equipment easier to sort into core facility and branch clinic
FOR OFFICIAL USE ONLY 13
DQ MEPRS Audit Readiness
DMLSS Customer Detail
FOR OFFICIAL USE ONLY
DQ MEPRS Audit Readiness
DMLSS Equipment Record
FOR OFFICIAL USE ONLY
DQ MEPRS Audit Readiness
Customer Catalog
FOR OFFICIAL USE ONLY
DQ MEPRS Audit Readiness
Customer Catalog Record
FOR OFFICIAL USE ONLY
DQ MEPRS Audit Readiness
Catalog Record Job Order Number (Expense Center)
FOR OFFICIAL USE ONLY
DQ MEPRS Audit Readiness
DMLSS Room Inventory
FOR OFFICIAL USE ONLY
DQ MEPRS Audit Readiness
Square Footage Reporting
FOR OFFICIAL USE ONLY
DQ MEPRS Audit Readiness
Points of Contact Colleen Rees, [email protected], 202-762-3538
Randy Van Nostrand, [email protected], 703-773-7312 ext. 602
Kate Burchess, [email protected], 703-773-7312 ext 104
Bonnie Rehbein, [email protected], 703-773-7312 ext. 603
FOR OFFICIAL USE ONLY 21
DQ MEPRS Audit Readiness
Questions
FOR OFFICIAL USE ONLY 22