Transcript MEPRS Data Sources and Differences: EAS IV Repository vs. M2

MEPRS Data Sources and Differences:
EAS IV Repository vs. M2
Herb Escobar
Axiom Resource Management
[email protected]
210-481-2526
Presentation Objectives
After this presentation, participants will be
able to:




Demonstrate an understanding of the
differences between what MEPRS data
elements are in EAS IV and the M2
Explain reasons why the data are different
Describe the different purposes for which
MEPRS data in EAS IV and the M2 are used
List key references available to aid in
understanding data differences
2
MEPRS Data Flow
EAS IV
Repository
STARS/FL,
BASF)
Personnel Data
(UCAPERS,
SPMS, EAS)
(Small MEPRS Dataset)
(Full MEPRS dataset)
Workload
(CHCS)
Financial Data
(STANFINS,
MEWACS
MDR
Local EAS IV
Server
(Nightly/Monthly
Processing)
(Large MEPRS dataset)
(Monthly
Processing)
M2
(Smaller MEPRS dataset)
3
MEPRS ≠ MEPRS

While there are many
sources of MEPRS
data….







MEQS III
Local MTF EAS IV
EAS IV Repository
MEWACS
MHS Data Repository
(MDR)
MHS Data Mart (M2)

Not all MEPRS sources
produce the same
data…





Service-specific vs.
DoD-standardized
Timing differences
Availability of data
elements
Level of aggregation
Processing errors
This presentation will focus on MEPRS on the M2
4
MEPRS on the M2
Historical MEPRS expense
data processed and applied
to patient-level inpatient and
ambulatory (Professional
Encounters) records.
Mostly raw MEPRS fields
from the EAS IV Repository
with a few data elements and
calculations added.
5
Inpatient Admissions /
Professional Encounters
• Patient-Level expense data
from MEPRS are available
in both Summary and Detail
data classes
• Measures are shown as
Raw and Total (estimated to
completion)
• Inpatient Admission
records updated monthly;
Professional Encounters
are updated weekly…
• …However, MEPRS data
used to estimate all
expense elements are
updated once per year
6
Inpatient Admissions / Professional
Encounters (Cont.)

Processed expense data from MEPRS
applied to person-level records

Patient Level Cost Allocation (PLCA)
Full Costs
 Variable Costs




Prospective Payment System (PPS) Earnings
TRICARE For Life (TFL) Earnings
MTF and Peer Group Norms
7
Patient-Level Cost Allocation (PLCA)

MEPRS Expenses applied to inpatient records






Direct expenses per Day
Support expenses per Day
Ancillary expenses per RWP
Surgical expenses per DRG Weight
Clinician salaries per PWP
MEPRS Expenses applied to ambulatory records


All expenses are APG-based…
…Except Clinician salaries per RVU
8
How PLCA Works
1
Raw Data From EAS IV Repository (FY02)
3rd Level
Parent Functional
DMIS ID Cost Code Dispositions
0098
2
ABA
213
0098
1,080
278,461
1,434,141
Occupied
Bed Days
Total RWP
Total PWP
1,221
419
364
Clinical
Salary
Total
Expenses
352,391
83,644
2,064,994
ABA
290
PLCA Unit Costs for ABA at DMIS ID 0098 (FY02) Uploaded
-to MDR & M2
3rd Level
Clinician
Parent Functional
Direct
Salary
Ancillary
Support
DMIS ID Cost Code (Per Day)
(Per PWP)
(Per RWP)
(Per Day)
0098
4
Other Direct
Stepdown
Expense
From E
Raw Data From SIDRS (M2) (FY02)
Parent Disposition
DMIS ID
FCC
Dispositions
3
Occupied
Bed Days
Stepdown
Expense
From D
ABA
Applicationto
Patient Record*:
$257.83
$312.78
$4,655.11
$326.29
ABA Days
5
$1,289
PWP
1.59
$482
RWP
1.54
$7,402
ABA Days
5
$1,631
Total Cost
for John Doe
$10,804
9
*Inflation factor added to forward-year data
Full vs. Variable Costs


Full costs in the M2 include all MEPRS expense
components as applied via PLCA
Variable costs are also applied via PLCA, however not
all expenses are included*:





24.00
25.20
25.25
25.30
25.55
26.05
26.10
41.00
80% of both Military and Civilian Labor
80% of Contracts
100% of Travel and Transportation
100% of Supplies
Other expenses included at 100%:
PRINTING & REPRODUCTION
LAUNDRY & DRY CLEANING
CUSTODIAL SERVICES
EDUCATION & TRAINING
CO-OP AND SUPPLEMENTAL CARE
AVPOL
FUELS
GRANTS, SUBSIDIES &
CONTRIBUTIONS
41.10 FREE RECEIPTS/UNFUNDED/NON
REIMBURSABLE
42.00 INSURANCE CLAIMS AND
INDEMNITIES
43.00 INTEREST AND DIVIDENDS
44.00 REFUNDS
*Identified using MEPRS SEECs
10
System Production
Data / MEPRS
• Raw MEPRS data from
EAS IV Repository, plus…
• DMIS ID Attributes from the
M2 DMIS ID Index Table
• Tmt DMIS Name
• Tmt DMIS Military Service
• Tmt DMIS Region
• Tmt DMIS HSSC Region
• Tmt Parent DMIS Name
• Tmt Parent DMIS Id
• Tmt DMIS MSMA
• Calculated Normative Data
(Observed, expected, and
peer normative values)
• “Cost Center Expense”,
“CHCS Days”, “MTF Peer”
(Not all objects shown)
• Data updated monthly
11
Other M2 vs. EAS IV Repository
Data Differences

Common terminology does not mean
equal values…





Occupied Bed Days (OBDs)
Relative Value Units (RVUs)
Beneficiary Categories
Available FTEs
DMIS ID Attributes
12
OBD Differences



ICU bed days in MEPRS are rolled up into the
MEPRS code corresponding to the attending
provider’s specialty
ICU workload in MEPRS is reported as hours of
service in DJ** FCCs
M2 shows ICU workload as OBDs reported in
CHCS using A*** FCCs
13
RVU Differences



Ambulatory RVU amounts reported in the EAS IV
Repository will be greater than M2
RVUs in MEPRS are based on Work plus NonFacility Practice Expense components
M2 RVUs are based solely on Work values
14
Beneficiary Category Differences
EAS IV
Repository
Beneficiary Category
1 = ACTIVE DUTY
2 = FAM MBR OF ACTIVE DUTY
3 = RETIRED
4 = FAM MBR OF RETIRED
5 = OTHER
9 = NOT REPORTED
N = NOT APPLICABLE
M2
Beneficiary’s Category
Ben Cat Common
1 = Dependent of Active
Duty/Guard/Reserve
2 = Retirees
3 = Dependent of Retirees,
Survivors, Other, NATO,
DCO, and Unknown
4 = Active Duty and Guard
ACT = Active Duty Member
DA = Dependent of Active
Duty/Guard/Reserve
DCO = Direct Care Only
DR = Dependent of Retired
DS = Dependent of Survivor
GRD = Guard
NAT = NATO
OTH = Other
RET = Retired
UNK =Unknown
15
Available FTE Differences



Available FTEs and Purified Available FTEs are
shown separately in the EAS IV Repository
(Class 7)
In M2, the Available FTEs represents the sum of
Available and Purified Available FTEs by FCC as
reported in the EAS IV Repository
In other words, Available FTEs in M2 equal
Available FTEs shown in the EAS IV Repository
Class 10 (Personnel Allocated)
16
DMIS ID Attributes Differences

M2 maps DMIS ID attributes from the DMIS ID
Index Table Specification, not values contained in
the EAS IV Repository








Tmt DMIS Name
Tmt DMIS Military Service
Tmt DMIS Region
Tmt DMIS HSSC Region
Tmt Parent DMIS Name
Tmt Parent DMIS Id
Tmt DMIS MSMA
Though the M2 and EAS IV Repository rely on
the same table for DMIS ID information, timing
and synchronization issues may result
17
18
References are Available!



All M2 functional specifications are available at
http://www.tricare.osd.mil/hpae/m2.cfm
Download the M2 Data Dictionary from
https://eidsportal.ha.osd.mil/sapportal/common/eids/
resources/products/m2/m2_datadictionary.xls
Additional M2 tools and resources:
https://eidsportal.ha.osd.mil
[email protected]
210-481-2526
19