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

MEPRS Data Sources & Applications:
EAS IV Repository vs. M2
2007 Tri-Service MEPRS Conference
Lansdowne, VA
Herb Escobar
[email protected]
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
MEWACS
MEPRS Data Flow
(Small MEPRS Dataset)
EAS IV Repository
(Full MEPRS dataset)
MDR
(Large MEPRS dataset)
MTF EAS IV
file
build and
processing
(Monthly
Processing)
(Nightly/Monthly
Processing)
M2
(Smaller MEPRS dataset)
3
MEPRS ≠ MEPRS

While there are varied
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
are used throughout MHS
for beneficiary group
costing, RVU costing, DRG
costing, variable costs
definition, PPS, Business
Plans, MTF Valuation, etc.
• Inpatient Admission (SIDR)
records updated monthly;
Professional Encounters
(SADR) are updated weekly.
• However, MEPRS data
used to estimate all
expense elements are
updated once per year
6
M2 Full vs. Variable Costs


Full costs in the M2 include Total MEPRS expenses
as applied to patient records via PLCA
Variable (marginal) costs are defined using MEPRS
SEECs and also applied via PLCA, however not all
expenses are included:





80% of both Military and Civilian Labor
80% of Contracts
100% of Travel and Transportation
100% of Supplies
No MHS consensus on Fixed/Variable definitions
7
Raw MEPRS in M2
• Summary Raw MEPRS data
from EAS IV Repository:
-
Dispositions & Admissions
Visits
FTEs
Expenses
• Calculated fields added:
-
Total FTEs
MTF Expenses
Cost Center Expense
MILPAY/CIVPAY/Oth O&M*
Normative measures
MTF Peer
• MEPRS data in M2 are
updated once per month
8
* Coming soon
MEPRS Differences between M2 and
EAS IV Repository on 30 July 2007
Inpatient (A)
FY07 FM
01
02
03
04
05
06
07
08
09
10
01
02
03
04
05
06
07
08
09
10
01
02
03
04
05
06
07
08
09
10
Ambulatory (B)
EASIV
Repository
$1,956,925
$2,332,877
$2,450,191
$2,754,777
$2,788,940
$2,204,985
$2,484,415
$3,013,740
M2 Patient
Level Costs
$2,408,023
$2,105,553
$1,940,636
$2,443,248
$1,915,766
$2,471,343
$1,925,343
$2,135,194
$1,469,659
M2 MEPRS
Table
$1,956,925
$2,332,877
$2,437,923
$2,722,123
$2,767,515
$2,204,985
$2,484,415
EASIV
Repository
$9,754,759
$9,592,418
$11,068,489
$11,157,801
$10,889,557
$10,100,973
$11,755,521
$9,875,425
$1,561,359
$1,829,734
$1,783,437
$1,486,242
$1,951,240
$1,426,553
$1,364,901
$2,138,622
$1,352,525
$1,671,325
$1,544,188
$1,677,311
$1,262,445
$1,347,627
$1,328,341
$1,138,317
$902,973
$36,187
$12,100,218
$12,698,040
$12,043,994
$12,654,504
$11,673,874
$13,206,444
$14,683,930
$13,047,789
$1,261,874
$1,558,158
$1,754,788
$1,782,517
$1,486,096
$1,951,238
$1,426,509
$1,364,876
$5,685,322
$6,469,988
$4,911,513
$5,447,682
$6,198,396
$5,174,642
$5,044,975
$8,414,977
$11,434,617
$10,735,451
$19,129,308
$15,785,531
$13,595,697
$15,919,474
$13,949,665
$15,970,065
$13,855,967
$18,743,025
$20,426,088
$15,202,516
$18,865,718
$17,721,220
$11,434,617
$10,735,451
$19,129,308
$15,785,531
$13,595,697
$15,919,474
$13,949,665
M2 Patient
Level Costs
$8,614,194
$8,100,656
$7,724,090
$9,438,636
$8,436,554
$9,670,485
$9,303,885
$9,100,856
$8,589,347
$2,887,986
$6,677,821
$6,422,497
$6,065,932
$7,306,817
$6,493,684
$7,428,257
$7,111,980
$7,214,999
$6,226,770
$2,290,718
$18,855,101
$18,400,752
$16,533,596
$17,999,197
$19,304,209
$21,402,308
$20,186,800
$19,687,209
$16,115,651
$6,225,204
Difference from EAS IV
M2 MEPRS
M2 Patient
Table
Level Costs
$9,754,811
23%
$9,584,669
-10%
$11,101,155
-21%
$11,013,201
-11%
$10,833,284
-31%
$10,100,973
12%
$11,755,521
-23%
-29%
M2 MEPRS
Table
0%
0%
1%
1%
1%
0%
0%
100%
$5,676,876
$6,225,263
$4,912,277
$5,448,173
$6,198,436
$5,174,809
$5,045,955
-13%
-9%
-13%
13%
-35%
-6%
-3%
-47%
0%
4%
0%
0%
0%
0%
0%
100%
$15,970,065
$13,855,967
$18,743,025
$20,426,088
$15,202,516
$18,865,718
$17,721,220
6%
18%
-37%
-20%
-14%
-17%
5%
0%
0%
0%
0%
0%
0%
0%
9
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
10
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** codes; OBDs in admitting A functional cost codes
M2 Inpatient Admission data shows ICU workload as
OBDs reported in CHCS using A*** codes, where:





AAH = DJA (Medical ICU)
AAC = DJC (Coronary Care Unit)
ABC = DJB (Surgical ICU)
ADC = DJD (Neonatal ICU)
ADE = DJE (Pediatric ICU)
11
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 (Total)
Multiple RVUs are reported in M2





Work RVUs
Organizational RVUs
Simple RVUs
PPS Work RVUs
Raw vs. Total RVUs,
12
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
13
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 Functional
Cost Code 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)
14
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
15
Future MEPRS Data in M2

Detailed FTE data from Class 7 of EAS IV Repository






Expense calculations




Available / Assigned / Purified FTEs
Non-Available FTEs
Personnel Category / Skill Type / Suffix
DoD & Service Occupation Codes
Available FTE Salary Expense
MILPAY / CIVPAY / Other O&M
ICU Workload and Stepdown Expense
Pharmacy Supply Costs
Reference tables



MTF-specific 4th-level Functional Code Definitions
Personnel Category / Skill Type / Suffix Definitions
DoD & Service Occupation Codes Definitions
16
References are Available!



All M2 functional specifications are available
at http://www.tricare.mil/ocfo/BEA/m2.cfm
Additional M2 tools and resources:
https://eidsportal.ha.osd.mil
MEPRS information available at
http://www.meprs.info
17
2007 Tri-Service MEPRS Conference
Lansdowne, VA
Herb Escobar
[email protected]