Monarch Exercise 35 - EPIC Resolute Billing, Master ATB vs EPIC Workqueues

Baba_Majekodunmi_703

Exercise Info

• Application (Classic vs Data Prep Studio): Data Prep Studio
  
• Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate
• Skills/Features Tested:  Append & Join
  
• Systems of Record: EPIC Resolute Billing
  
• Estimated Time to Solve: 15 mins
• Exercise files required are attached Below, in both Zip files for May 2023 and June 2023:
  
  • HB_CREDIT_BALANCE.xlsx
  • HB_CREDIT_BALANCE_DEFERRED.xlsx
  • HB_DENIALS_FOLLOW_UP.xlsx
  • HB_DENIALS_FOLLOW_UP_DEFERRED.xlsx
  • HB_INSURANCE_FOLLOW_UP.xlsx
  • HB_INSURANCE_FOLLOW_UP_DEFERRED.xlsx
  • MASTER Aged Trial Balance by Patient.xlsx

Exercise Overview

You are a Revenue Integrity Analyst at a Health System and your Manager has asked you to combine multiple files from the EPIC Workqueues for the month of May 2023, then for the Month of June 2023, to answer the following questions:

1. Which patient has the largest HAR Acct Balance for All Credit Balances?
2. Which financial class has the most number of patients across All the Workqueues?
3. Which patients are on All Workqueues, that are not on the Aged Trial Balance?

Answer

• Please upload your answers below in the comment section for the exercise
• A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Exercises' section.