financial data
DESCRIPTION
Financial Data. MEPRS Overview. MEPRS = Medical Expense and Performance Reporting System Costs, workload and FTEs Summary data only MEPRS Business Rules estimate “work center” costs Tri-Service Cost “Accounting” system. MEPRS Data Flow. EAS IV Repository (Full MEPRS dataset). Workload - PowerPoint PPT PresentationTRANSCRIPT
Financial DataFinancial Data
2TMA / WISDOM Excerpt
• MEPRS = Medical Expense and Performance Reporting System
• Costs, workload and FTEs
• Summary data only
• MEPRS Business Rules estimate “work center” costs
• Tri-Service Cost “Accounting” system
MEPRS Overview
3TMA / WISDOM Excerpt
MEPRS Data Flow
Workload(CHCS)
Financial Data(STANFINS,STARS/FL,
BASF)
Personnel Data(UCAPERS,SPMS, EAS)
Local EAS IV Server
MDR(Large MEPRS dataset)
M2(Smaller MEPRS dataset)
(Monthly Processing)(Nightly/Monthly
Processing)
EAS IV Repository(Full MEPRS dataset)
4TMA / WISDOM Excerpt
Using the Data!Using the Data!
5TMA / WISDOM Excerpt
• MEPRS Codes: Define the cost entities in an MTF
• 4 character codes - imbedded hierarchical logic
(each character means something!)• For example:
AADA = Inpatient Dermatology
Terminology
6TMA / WISDOM Excerpt
• 1st character – “MEPRS1 Code”– A - Inpatient– B - Ambulatory– C - Dental– D - Ancillary– E - Support– F - Special Programs– G - Readiness
Terminology
Use MEPRS Manual for
detailed descriptions of all
codes:www.meprs.info
7TMA / WISDOM Excerpt
• MEPRS uses a unique parent/child structure
• Smaller MTFs report through parents
• Both parent and child (DMISID) levels of reporting are available in M2
• Parent DMISID of Record (MEPRS Parent) vs. Parent DMISID
Parents and Children
8TMA / WISDOM Excerpt
All data available by:
• Timeframe (months, years)
• MEPRS Code – All 4 char’s. Most questions only need 3.
– Ex. MEPRS4 Code matches pattern DAA%
MEPRS Summary Data
9TMA / WISDOM Excerpt
Types of Workload:• Inpatient: Dispositions, Bed Days. As
incurred in a month
• Outpatient Visits
• Inpatient Visits: (Ambulatory workload for inpatients)
• Total Visits
Workload Data
10TMA / WISDOM Excerpt
• Weighted Rx workload:– Primarily contains prescriptions– Also bulk issue, unit doses, sterile products
• Lab/Rad Weighted Workload (Relative Value Units)
• Workload ordered by a particular work center and filled at the reporting MTF
Workload Data
11TMA / WISDOM Excerpt
12TMA / WISDOM Excerpt
13TMA / WISDOM Excerpt
14TMA / WISDOM Excerpt
San Diego’s Ambulatory Internal Medicine Clinic ordered 135K Lab RVUs from the lab at San Diego
15TMA / WISDOM Excerpt
• Assigned FTEs: From Service Personnel Systems
– Monthly Assigned Staff
– Won’t include borrowed labor or R/S
• Available FTEs: From Timesheets
– Monthly Available FTEs
• Monthly Numbers: Don’t add people across months!
FTE Data
16TMA / WISDOM Excerpt
• Clinician: MD, DO, DDS, Interns/Residents
• “Other Clinician”: MD, DO, DDS
• Professionals: PAs, NPs, Midwives, etc
• Interns/Residents
• RN: Registered Nurse
• Para-Professionals: LPNs, X-Ray Techs, etc.
• Admin: Administrative Staff
Types of FTEs
17TMA / WISDOM Excerpt
18TMA / WISDOM Excerpt
• Don’t add across months! 600 people each month, not 1200 people!
•Assigned < Available (OT, Resource Sharing, etc)
19TMA / WISDOM Excerpt
• Expenses are estimates.• All work centers have direct expenses: The
original work center that captures an expense – Often includes salaries, supplies and such
• Work centers also have costs allocated to them
Expense Assignment
Allocated $
AAAA (Internal Medicine) Work Center
Direct $
Total Expenses $
+ =
20TMA / WISDOM Excerpt
Allocated expenses:– Shared expenses
• “Purified” as MEPRS calls them
– Ancillary Services (MEPRS D codes)• Rx, lab, rad, ICU, etc.
– Support Services (MEPRS E codes)• Commanders salary, housekeeping, utilities
• Allocation process is the same
Expense Assignment
21TMA / WISDOM Excerpt
• Expenses are allocated based on “performance factors”– Laundry: lbs of laundry– Commander’s salary: FTEs– Lab: weighted workload ordered– Pharmacy: weighted procedures– Housekeeping: square footage– Cost Pools: Minutes of service or OBD
Expense Assignment
22TMA / WISDOM Excerpt
Sample Allocation:– OB/GYN Supply Cabinet
(MEPRS Code ACX): $10,000– OB Workload (ACA):
500 OBDs, 83% of total workload– GYN Workload (ACB):
100 OBDs; 17% of total workload
– Purified to OB: $10,000*83% or $8,300
– Purified to GYN: $10,000*17% or $1,700
Expense Assignment
23TMA / WISDOM Excerpt
Allocated Expense Measures from MEPRS:• Ancillary Expense: Sum of all allocated expenses
to a given work center from ancillary accounts• Some components of ancillary expense (lab, rad
and rx stepdown)• Purified Expense (shared)• Support Expense
Expense Variables
24TMA / WISDOM Excerpt
Direct Expense
Purified Expense
Ancillary Expense
+Support Expense
Total Expense
Final Accounts
Inpatient (A), Ambulatory (B), Dental (C), Special Programs (F) and Readiness (G) are “FINAL ACCOUNTS”
25TMA / WISDOM Excerpt
26TMA / WISDOM Excerpt
A - Inpatient
B- Ambulatory
C- Dental
D - Ancillary
E - Support
F - Special Progs
G - Readiness
Expense Assignment
Note: Ancillary and Support Accounts should have total expense = 0 in the M2 (their expenses are already captured in the other work centers)!
27TMA / WISDOM Excerpt
Direct Expense
+ Allocated from others
-Allocated out
0 Total Expense
Support/Ancillary Accounts
If total expense too much greater than 0, probably an error in MEPRS
28TMA / WISDOM Excerpt
To get a “total expense” for ancillary and support accounts:
Use Cost Center Expense
Expense Assignment
29TMA / WISDOM Excerpt
30TMA / WISDOM Excerpt
Very close to 0 in total expense. Probably rounding
31TMA / WISDOM Excerpt
• MEPRS Manual
– Describes MEPRS Codes
– FTE/workload reporting
– Expense allocation process
• MEWACS
– Web based reports on MEPRS data quality. Site specific
• TMA Website/MEPRS
Resources