1 / 31

Financial Data

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

amela-herring
Download Presentation

Financial Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Financial Data

  2. 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

  3. MEPRS DataFlow EAS IV Repository (Full MEPRS dataset) Workload (CHCS) MDR(Large MEPRS dataset) Financial Data(STANFINS,STARS/FL,BASF) Local EAS IV Server (Monthly Processing) Personnel Data(UCAPERS,SPMS, EAS) (Nightly/Monthly Processing) M2(Smaller MEPRS dataset)

  4. Using the Data!

  5. Terminology • MEPRS Codes: Define the cost entities in an MTF • 4 character codes - imbedded hierarchical logic (each character means something!) • For example: AADA = Inpatient Dermatology

  6. Terminology • 1st character – “MEPRS1 Code” • A - Inpatient • B - Ambulatory • C - Dental • D - Ancillary • E - Support • F - Special Programs • G - Readiness Use MEPRS Manual for detailed descriptions of all codes:www.meprs.info

  7. Parents and Children • 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

  8. MEPRS Summary Data All data available by: • Timeframe (months, years) • MEPRS Code • All 4 char’s. Most questions only need 3. • Ex. MEPRS4 Code matches pattern DAA%

  9. Workload Data Types of Workload: • Inpatient: Dispositions, Bed Days. As incurred in a month • Outpatient Visits • Inpatient Visits: (Ambulatory workload for inpatients) • Total Visits

  10. Workload Data • 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

  11. San Diego’s Ambulatory Internal Medicine Clinic ordered 135K Lab RVUs from the lab at San Diego

  12. FTE Data • 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!

  13. Types of FTEs • 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

  14. Don’t add across months! 600 people each month, not 1200 people! • Assigned < Available (OT, Resource Sharing, etc)

  15. Expense Assignment • 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 AAAA (Internal Medicine) Work Center Direct $ Allocated $ Total Expenses $ + =

  16. Expense Assignment 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

  17. Expense Assignment • 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

  18. Expense Assignment 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

  19. Expense Variables 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

  20. Final Accounts Direct Expense Purified Expense Ancillary Expense +Support Expense Total Expense Inpatient (A), Ambulatory (B), Dental (C), Special Programs (F) and Readiness (G) are “FINAL ACCOUNTS”

  21. 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)! A - Inpatient B- Ambulatory C- Dental D - Ancillary E - Support F - Special Progs G - Readiness

  22. Support/Ancillary Accounts Direct Expense + Allocated from others -Allocated out 0 Total Expense If total expense too much greater than 0, probably an error in MEPRS

  23. Expense Assignment To get a “total expense” for ancillary and support accounts: Use Cost Center Expense

  24. Very close to 0 in total expense. Probably rounding

  25. Resources • MEPRS Manual • Describes MEPRS Codes • FTE/workload reporting • Expense allocation process • MEWACS • Web based reports on MEPRS data quality. Site specific • TMA Website/MEPRS

More Related