Monarch Exercise 35 - EPIC Resolute Billing, Master ATB vs EPIC Workqueues
Baba_Majekodunmi_703
Altair Employee
Altair EmployeeExercise 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:
- Which patient has the largest HAR Acct Balance for All Credit Balances?
- Which financial class has the most number of patients across All the Workqueues?
- 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.
0