Preparing for an Audit DMHRSi Time vs Workload

Preparing for an Audit: DMHRSi Time vs. Workload Reporting Navy Resources Symposium 4 June 2012 Herb Escobar Analytics and Services, Inc. hescobar@easincorporated. com

Objectives After completing this session the attendee can: • • Describe the Defense Medical Human Resources Reporting System internet (DMHRSi). Characterize data that can be analyzed with DMHRSi not available in MEPRS. Characterize the extent to which workload and timesheet reporting differs at MTF and MEPRS Code level in Navy Medicine. Describe methods that can be used to test the extent to which timesheet and workload reporting differ. 2

Outline • DMHRSi Data and Application • DMHRSi Data Quality Challenges • Tri-Service Labor Reporting vs. Workload Study • Questions 3

DMHRSi Data and Application 4

DMHRSi Overview • Defense Medical Human Resources System - internet (DMHRSi) • • • Repository for MHS human capital and labor cost assignment data Source for tri-Service medical human capital information Source of FTE data and personnel expenses in MEPRS and M 2 Self-reported labor hours across Functional Cost Codes (4 th-level MEPRS Codes) Labor hours across MEPRS Codes lead to personnel costs • • • Actual salary for Civilians Uniform composite pay tables for Military No personnel costs for Contractors 5

DMHRSi Data Sources • “DMHRSi Discoverer. Plus” is the integrated reporting tool • • Interactive Corporate Reports Ad-hoc queries Performance and documentation challenges SMART receives regular DMHRSi extracts 6

DMHRSi Data Sources (Cont. ) • Monthly DMHRSi HR extract available in MDR • Person-level assignment data from 1 Oct 2008 – Present • /mdr/pub/dmhrsi/hr/dmhrsi. sas 7 bdat • • EDIPN/NPI/SSN Name/Rank/Grade Person Category/Skill Type/Suffix Occupation Code/Taxonomy/Job/Position Assignment MTF/Organization/People Group Labor Reporting MTF/Organization/People Group Assignment Start/End Dates 7

Analytic Applications of DMHRSi data • Richness of DMHRSi data facilitates analyses not possible with MEPRS or M 2 personnel data alone • Workload and cost metrics by Facility/Service of assignment – Army or Air Force providers in Navy facilities • Assigned/Available MEPRS codes by person – where are people actually working • National Practitioner Identifier (NPI) and Electronic Data Interchange Person Number (EDIPN) facilitates linking workload from CAPER/SIDR to specific provider characteristics • Labor reporting vs. workload across Functional Cost Codes 8

DMHRSi Data Quality Challenges 9

DMHRSi Data Quality • Common of DQ issues observed – some easy to spot • • Manual data entry errors: UIC “KV!MFV 9 P" vs. "KV 1 MFV 9 P” Inconsistent data entry: “TMA” vs. “TRICARE MGT”, “PHS” vs. “Public Health” Caps vs. Lower Case: “Navy” vs. “NAVY” More serious DQ issues affect reconciliation of data transmitted to downstream systems 10

DMHRSi = MEPRS Correct 11

DMHRSi > MEPRS Incomplete Timecards Pulled? 12

DMHRSi < MEPRS Edits in MEPRS Only? 13

Intercepted DMHRSi to EASIV Raw File • • EASIV output file is sometimes intercepted and edited due to DMHRSi system performance challenges Easy to make mistakes & makes traceability of data impossible 14

Tri-Service Labor Reporting vs. Workload Study 15

Background • • Labor costs account for about 70% of MHS facility expenses. Accurate reporting of labor hours across facility work centers is critical for valid healthcare cost and productivity analysis. Do. D 6010. 13 M provides detailed labor reporting policy and instructions. First-of-its-kind study sponsored by the Methods, Measures and Analyses Directorate at TMA/DHCAPE through Axiom – Resource Management examined reported labor and associated workload across clinics. 16

Context 17

Method • • • Darnall AMC - Ft. Hood, NH Pensacola, and the 60 th Medical Group –Travis AFB Fiscal Year 2011 data were analyzed Person-specific Available hours by facility, fiscal month, and cost center were obtained from DMHRSi Labor Cost Assignment (LCA) module via Discoverer CAPER and SIDR workload records by facility, fiscal month, and cost center were extracted from the MHS Data Repository (MDR) EDIPN and NPI data were added to the LCA extract to facilitate provider-level matching to CAPER/SIDR workload datasets LCA data matched to CAPER/SIDR by facility, fiscal month, and 4 th-level Functional Cost Code 18

Method (Cont. ) • • • All skill types were included in the LCA analysis dataset (i. e. , providers, nurses, techs, etc. ) Only MEPRS-B CAPERs were included Provider 1 – 5 Work RVUs and individual providers in CAPERs were included (only 1 – 3 were populated) CAPER/LCA match on EDIPN then NPI SIDR analyses included Attending, Admitting, and procedure-specific providers; Total RWPs retained SIDR/LCA match on NPI 19

Matching CAPER/LCA by Child DMISID • • Aggregate Provider Work RVUs used Match by Fiscal Year, Fiscal Month, Parent DMISID, Child DMISID, and 4 th-Level Cost Center per MEPRS labor reporting policy Variance noted across aggregated by Child MTFs Color coding criteria is not per policy; no prior quantitative assessments have been performed 20

Matching CAPER/LCA by Summary Cost Center • • • Aggregate Provider Work RVUs used Match by Fiscal Year, Fiscal Month, Parent DMISID, Child DMISID, and 4 th-Level Cost Center per MEPRS labor reporting policy Variance noted across clinical services 21

22

Matching SIDR/LCA by Summary Cost Center • • • Attending Provider Total RWPs shown (Admitting Provider also analyzed with poorer results) Match by Fiscal Year, Fiscal Month, Parent DMISID, Child DMISID, and 4 th-Level Cost Center per MEPRS labor reporting policy Variance noted across clinical services, poor match overall 23

Matching CAPER/LCA – MTF Aggregate • • • Aggregate Provider Work RVUs reported Match by Fiscal Year, MEPRS -B, and Parent DMISID Provider Salary data from MEPRS 24

Matching SIDR/LCA – MTF Aggregate • • • Aggregate Total RWPs reported Match by Fiscal Year, MEPRS-A, and Parent DMISID Provider Salary data from MEPRS 25

Matching LCA MEPRS-B FTEs in CAPER • • Comparison of Providers with labor hours reported in MEPRS-B Cost Centers vs. CAPER workload Match by Parent DMISID, MEPRS-B, EDIPN, and NPI Participating in Readiness or supporting non-clinical administrative services? Per Do. D 6010 -13 M APP 3, nonclinical administration hours should be recorded in overhead (E) Cost Centers 26

Matching LCA MEPRS-A FTEs in SIDR • • • Comparison of Providers with labor hours reported in MEPRS-A Cost Centers vs. SIDR workload Match by Parent DMISID, Fiscal Month, 3 rd-Level FCC, NPI, EDIPN Participating in Readiness or supporting non-clinical administrative services? ICU workload in SIDR in A-FCCs vs. DJ* in LCA Per Do. D 6010 -13 M APP 3, nonclinical administration hours should be recorded in overhead (E) Cost Centers 27

Matching LCA MEPRS-A FTEs in SIDR • • Comparison of Providers with labor hours reported in MEPRS -A Cost Centers vs. SIDR workload Match by Parent DMISID, NPI, EDIPN Significant improvement over 3 rd-Level FCC comparison Almost all MEPRS-A Provider FTEs in LCA report some SIDR workload 28

Clinic-Level vs. Aggregate Analysis • • MHS policy prescribes workload, labor, and expense data reporting by functional cost center (clinic-level) However, some analytical applications rely on inpatient and outpatient aggregates Clinic-Level MHS Cost Data Applications Inpatient / Outpatient Aggregate Cost Data Applications “Make vs. Buy” Analysis Annual MERCHF Reconciliation Program Evaluation (i. e. , PCMH) Third Party Collection ASAs Product-line Performance Metrics PMPM Calculations Patient-Level Costs for M 2/MDR PPS Analysis Business Planning 29

Study Conclusions • • Study demonstrates ability to link reported labor hours by provider to specific workload production Unquestionable problem dictating further attention and examination Next Steps • • Follow-on study will seek to validate initial results and expand analyses Explore centrally developed metrics to monitor: • • DMHRSi Labor vs. workload match DMHRSi Available FTE vs. EASIV Available FTE 30

Review of Objectives 31

Objectives Review After completing this session the attendee can: • • Describe the Defense Medical Human Resources Reporting System internet (DMHRSi). Characterize data that can be analyzed with DMHRSi not available in MEPRS. Characterize the extent to which workload and timesheet reporting differs at MTF and MEPRS Code level in Navy Medicine. Describe methods that can be used to test the extent to which timesheet and workload reporting differ. 32

Preparing for an Audit: DMHRSi Time vs. Workload Reporting Navy Resources Symposium 4 June 2012 Herb Escobar Analytics and Services, Inc. hescobar@easincorporated. com