Monarch Learning Series 2023 Exercise 11 - FCR250 Failed Claim Requirements Analysis

Baba_Majekodunmi_703

Exercise Info

• Application (Classic vs Data Prep Studio): Data Prep Studio
  
• Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
• Skills/Features Tested: Detail & Append Templates, Join (Inner Join), Analyze
  
• Systems of Record: Allscripts McKesson HBOC STAR Patient Accounting
  
• Estimated Time to Solve: 15 mins
• Exercise files required are attached in the Zip File Below;
  
  • FCR250 - Failed Claim Requirements.txt
  • Physician Data.xlsx

Exercise Overview

You are a Revenue Cycle Analyst at a Healthcare System and your Manager has asked you to perform some research on Failed Claims. Specifically to answer the following questions:

1. What is the Total of 'Account Balance' in the FCR250 Failed Claim Requirements text file?
2. How many unique Attending Physicians (Attend Phys) were associated with a failed claim?
3. Which Attending Physician had the most number (count) of Failed Claims?
   1. What is their first & last name?
   2. What department do the work in?

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.

Altair_CommunityBlog_Default-14.jpg

FCR250G - Failed Claims Requirements.txt

Physician Data.xlsx