Transcript MEPRS Connecting the Dots

Tri-Service MEPRS Conference
26Jul10
The Cost Accounting System which provides
consistent principles, standards, policies,
definitions, and requirements for the
accounting and reporting of expenses,
manpower, and performance of Army, Air
Force, and Navy fixed military medical and
dental facilities.






Read, Understand, Implement Policy & Guidance
File & Table Builds/Updates
Understanding EAS Business Rules
EAS IV Repository
Quality Data
System Interfaces (source files)
CHCS
 DMHRSi
 WMSNi
 GFEBS/STANFINS


Software

Available Training
5M2U (Five Minute MEPRS University) http://www.meprs.info/5M2U/
 QUEST - http://www.meprs.info/quest.cfm
 DMHRSi – Help Function

 Tutor Process


EASi – Help Function
CHCS System Administrator (local)
 CHCS User Desktop Guide

EAS
Local MEPRS Office Personnel
 System Services – User Management


EAS IV Repository

AMPO
 Must take and pass a short exam on MEPRS data (5-6 Qs)
 Complete/Submit a Request thru MTF MEPRS Coordinator to AMPO/TMA

DMHRSi

Local SAA – Submit request to [email protected]
 Employee Self Service
 Timekeeper Specialist

Labor Cost Assignment (LCA) - all LCA Roles
 Must submit request to AMPO

CHCS/WAM

Local CHCS DBA
 Secondary Menu – DGNAS WAM USER
 Security Keys – DGNAS USER

Internet Explorer

Required links
 EASi: https://eas.csd.disa.mil/eas4i/welcome.jsp
 DMHRSi: https://dmhrsi.satx.disa.mil/OA_HTML/AppsLocalLogin.jsp
 AKO: https://www.us.army.mil/suite/login/login.fcc
 EAS IV Repository
sp
https://eascr.csd.disa.mil/businessobjects/enterprise115/desktoplaunch/logonFullClient.j
 GFEBS: https://prodep.gfebs-erp.army.mil/irj/portal

MS Office

Excel
 Analysis
 Reports
 Pivot Tables

Word
 Policies/guidance

Power Point
 Presentations

Business Objects Xi



EASi Reports
EAS IV Repository AdHoc Reports/Queries
Acrobat Reader

*.pdf files

MEPRS Management Improvement Group (MMIG)
Responsible for:




Development, implementation and management of MEPRS policies,
Procedures and business practices,
Integrating the collection, processing and reporting


Ensures MHS business practice standardization and procedural
compliance related to





Standard workload, financial, and labor data in the EAS.
the preparation,
validation,
audit,
submission and reporting of MEPRS data.
Operates under the auspices of the TMA Resource
Management Steering Committee (RMSC).

FY Funding Guidance Letter


MEPRS Annex
Required Documents













Criteria for a Stand-alone Work Center
FY Reporting Components by FCC
ASN Order and Data Set Guidelines
G Account Readiness Business Rules
MTF Processing & Submission Dates
Financial Reconciliation Helpful Hints
Narrative format
GME – GDE Guidance & Business Rules
EASi Tables - (downloadable from within EASi)
CHCS Workload Desktop Guide
DMHRSi LCA Student Guide????
EAS Functional User’s Guide
EAS IV Repository Functional User’s Guide

CHCS


WAM
DMHRSi

EAS Create File

WMSNi

GFEBS/STANFINS
GFEBS – auto upload to EASi
 STANFINS – manual retrieval and upload into EASi

MEPRS DATA
FEEDERS - FLOW - SOURCES
Workload
CHCS/AHLTA
WWR
CHCS:
Admissions / Discharges
Bed Days
Visits
Ancillary Workload
ADS
CHCS
TPOCS
WAM
EAS IV
REPOSITORY
MEPRS data is available from
Multiple sources:
EASi
EASIV Repository
M2
MDR
Web Viewer
Business
Objects
EAS IV
However, not all data elements
may be present or produce
similar results –timing – level
of aggregation – Service –
specific v. DoD Standardized
LEGEND:
Subsystem
Financial
Expense
STANFINS
Obligation
GFEBS
Civilian Salary
Main Account / BS
Limit
Functional Area/AMSCO
Commitment Item /EOR
Data
Personnel
DMHRSi
Database
Display
Personnel data
Man Hour
Data via the EAS Create file
Document

EASi



CHCS





Account Subset Definition Table (ASD Table)
Datasets
Site Definable MEPRS Table
CHCS Templates
Schedule Management
Provider File & Table
DMHRSi



Project #
Task List
Organizations

WMSNi

GFEBS/STANFINS


Cost Center Table (GFEBS)
APC Table (STANFINS)

STANFINS - Data Elements















Schedule Type
MEPRS FCC
Dept FY
Basic Symbol/Limit (BSL (APPROP))
Army Management Structure Code (AMSCO (PEC))
Element of Resource (EOR (SUEE/SEEC))
FYTD Expenses
FYTD Obligations
Operating Agency (OA)
Allotment Serial Number (ASN)
Source of Funds (SOF)
Calendar Month
Calendar Year
Limit
Program Directors Code

GFEBS - Data Elements
Header Record









Detail Record









Trailer Record

Source System
Calendar Year
Calendar Month
DMIS ID
MEPRS FCC
Commitment Item (EOR/SUEE/SEEC)
Main Acct Code (BS)
Limit
Period of Availability (FY Date)
Reimbursable Flag Indicator
Functional Area (AMSCO)
FYTD Obligations
FYTD Expenses
Cost Center (OA/ASN)
Order
WBS Element
Fund Center
Number of Bytes
Number of Records

Data Elements

Detail Record




Header Record







Source System
Version
*Unit Identification Code (UIC)
*Group/Parent DMIS ID
*Calendar Year
*Calendar Month
Filler












Trailer Record


Total Number of Bytes
Total Number of Records








* Denotes key element

*Unit Identification Code (UIC)
*DMIS ID
*Functional Cost Code
*Service Unique Expense Element
*Service Unique Program Element
*Basic Symbol Limit
*Skill Type
*Skill Type Suffix
*Service Unique Occupation Code
*Personnel Category
*Duty Indicator
*Source of Funds
Available Salary Expense
Nonavailable Salary Expense
Assigned FTE
Available FTE
Nonavailable Sick/Hosp FTE
Nonavailable Leave FTE
Nonavailable Other FTE
Available Workhours
Nonavailable Hosp/Sick
Workhours
Nonavailable Leave Workhours
Nonavailable Other Workhours

Derived Data Elements
*Service Unique Expense Element
 *Basic Symbol / Limit

 Pers Category
 Reservist
 Reserve Type
 Contractor
 Contractor Type
 Skill Type
 Local National
 LN Type
 Country Code

*Duty Indicator
 Assigned Organization
 Group
 Project / Task Charged
***Labor Cost Assignment Desk Reference Guide***
Provides detailed information on the exact mapping of the derived data elements

Obtaining WMSN file for Import into EASi

Previous process:

MTFs contacted AMPO Help Desk (Greg Mitchell)

Current process.


Contact USAMITC Helpdesk to create a trouble ticket to have
the WMSN file sent.
[email protected]

EAS Functional User’s Guide

Error Codes – defined
 Import Errors
 Initial Validation Checks
 ECU Warnings/Errors
 Document reason for correction – Audit report is more
useful if documented in comments; not just code
 Pre-Allocation Validation
 Warnings - must be addressed, cannot be over-ridden
 Errors

DoD 6010.13-M, Appendix 1, Table 1





Identifies possible datasets
Data to capture (Raw/Weighted)
Allocation Factor (Raw/Weighted)
Service Unit
FY Guidance
 Identifies FCC Includes/Excludes
 ASN Order

Auditable financial data

Financial
 Compare and validate financial data from the source system correctly
interfaced into EASi
 All adjustments made to the STANFINS data in EASi have been documented
 Enter data from the STANFINS AVK 329 (218) Report
 Compare data from
 218 Report
 EAS Systems Interface Financial Pure Report
 Reconcile 218 Report to EAS Systems Interface Financial Pure Report

Personnel
 Compare and validate all personnel financial data from DMHRSi interfaced
correctly into EASi
 All adjustments made to the DMHRSi source data in EASi have been
documented.
 DMHRSi EASIV Summary View Report and EASi Personnel Pure Month Net
 EASi Personnel Pure and Personnel Accepted Report Month Net
 EASi Month Net Personnel Accepted and Direct Expense Accepted Reports

EASi Final Reconciliation
 Compare amounts from the
 EASi Financial Pure Civilian Pay YTD
 Direct Expense Accepted Civilian Pay YTD (DMHRSi)
 Determine amounts that are automatically deleted by EASi after financial
data is interfaced into EASi

Adjustment Explanation Tab
 Month net differences between the DMHRSi EAS IV Summary View Report and the
EASi Personnel Pure Report
 Month net adjustments made in EASi to increase or Decrease Personnel Salary Data
 Shows difference between EASi Personnel Pure and EASi Personnel Accepted Reports
 Personnel Adjustments that do not increase/decrease personnel salaries
 Transfer adjustments only
 Financial Adjustments (entries added to Financial Pure data (YTD amts only))




Depreciation
SAIC - centrally funded salary
DENCOM (Dental Asst, Dentists) - centrally funded salary
Marriage & Family Therapy Social workers – centrally funded

Adjustment Explanation Tab
 YTD Miscellaneous adjustments added to EASi Financial Pure Data
 YTD Miscellaneous adjustments deleted to EASi Financial Pure Data
 Higher headquarters costs in financial pure - (BZ***)
 Payroll EORs in #EMPTY in financial pure
















EORs 15NZ, 17NZ, etc. - Any Payroll EORs which are expired, in # Empty, & deleted by EASi
DLA Supply Credit Card adjustments - (BYDLA)
Bad Debt on collections - (BYBAD)
OPLOC default database APC (Formerly GPAY,9999) - (BZDFS)
Delete VET Regional Command - (BZVET)
Delete Regional Medical Command - (BZRMC)
Delete Regional Dental Command - (BZRDC)
Delete Tri-Care Regional Office (TRO) - (BZTRO)
Delete Multi-Market Service Office (MSMO) – (BYMSO)
Delete Regional BRAC Office/Team – (BZBRC)
Delete Community Based Health Care Organization (CBHCO) – (BZCBH)
DHP Inventory in financial pure – (BYRIN)
Delete VET Direct Expenses and Obligations – (BYVET)
Korean payroll in financial pure – (EOR 2566)
Delete accounts receivable – (EOR 4601)
Delete amounts processed in – (EOR 2721)

Adjustment Explanation Tab
 Financial Section – Miscellaneous items which do not add or delete EASi Financial Pure
Data Report
 MEPRS FCC Change
 AMSCO Change
 EOR Change

EASi Final Reconciliation

YTD Amounts in the EASi Financial Pure Report and the Financial Direct Expense
Accepted Report
 Military salary YTD – Direct Expense Accepted Report (EORs 1190, 119A, 119B, 119*, 117F, &
A420)
 Total YTD EASi Financial Direct Expense Accepted Report (no filters)

Required format
 Required information
 Items of Noncompliance – known violations of business rules
 Inpatient Care (This section should include the date when the Inpatient Workload and Man-hour
Reconciliation was completed.)
 Ambulatory Care (This section should include the date when the Outpatient Workload and Manhour Reconciliation was completed.)
 Dental Care
 Ancillary Care
 Administrative and Support Services
 (Note: In this section, verification should be provided every month on the work centers by
MEPRS/FCC and EOR which do not receive support from Logistics to assist in validating
entries in the EEA* datasets)
 Special Programs
 Medical Readiness


Required information

Personnel Issues

Financial Issues
 Include a listing of month net credit expense balances (by MEPRS/FCC) which were created by
Budget adjustments.

Other Comments. General issues can be included in this section.
 Square Footage: Square footage changes by MEPRS/FCC and square footage amount per month
 MEPRS/FCCs Activated and/or Deactivated by fiscal month. Cumulative YTD changes

Date Financial reconciliation was completed

Date forwarded to the MEPRS Functional Mailbox

MEPRS Monthly Retransmission: The monthly MEPRS was retransmitted on (Date) because an
adjustment was made in EASi to correct (provide summary explanation). The recertified financial
reconciliation for this retransmission was submitted to the MEPRS Functional Mailbox on (Date).

Site Summary Reports
File/Table Builds/Updates
 EASi Errors/Warnings
 Data Set Checks/Balances


AMPO Discrepancy Report
EASi Errors/Warnings (Pre-allocation Validation)
 MEPRS Code Occurrence Report (MCOR)


Unauthorized FTE Errors Reported in Anesthesia and
Nursing Accounts
Assigned Personnel Report
 Summary View Report


AdHoc query tool

MEPRS Code Occurrence Report
Assist with identifying cause for discrepancy
 Identifies total cost/expense

 Financial Pure
 Direct
 Purified
 Providing FCCs Allocated expense
 FTEs

Active User Acct, never used – 58.9%(545/321)



What EAS Data is contained in M2?
Where does it come from?
How is it derived?


MEWACS is a web application that identifies anomalies in MEPRS data
transmitted to the EAS IV Repository. MEWACS highlights MEPRS
reporting compliance, data trends, and allocation activities using colorcoded indicators. When data points appear anomalous, MEWACS flags
the issues and alerts the user that an error may have occurred during data
processing or transmission. This alarm system prompts MTFs to
investigate their data and apply the necessary corrective actions in a
timely manner. By reviewing MEWACS routinely, MTF personnel can
ensure EAS IV Repository data provide an accurate representation of
their site operations. MEWACS is available at www.MEPRS.info to help
sites validate their EAS IV Repository data.
Each month, the TMA MEPRS Program Office takes a data snapshot of
the EAS IV Repository and presents the information in MEWACS. The
extraction includes up to 36 months of data, reflecting new and corrected
transmissions in the MEWACS application

Review & Analyses



Business Case Analysis



Used to determine potential levels of access to care
Used in PPS and PBAM
Prospective Payment System (TMA)


MTFs are required to submit to show how they expect to perform and become/ remain fiscally solvent
Provider Productivity


MTFs are required to submit when new service is planned to be offered
Business Plans


Cost per Sq Ft of “Dead Space”
Contract Augmentation of contract in-patient services (RTF – Substance Abuse)
Used to determine Service Level funding
Performance-Based Adjustment Model (MEDCOM)

Used to determine MTF level funding
Sum of MTF score determines initial MTF Rank
MTFs ranked based on
Peer Group
MTF Score determined by points earned
EAS Timeliness
DMHRSi TC Compliance
Missing Narratives
Missing financial Reconciliations
AMPO Discrepancies
DQ Discrepancies
Unauthorized FTE Discrepancies
EASi Timeliness
DMHRSi Timecard Compliance
Score is derived from point values assessed for compliance with: