Altair Monarch Learning Series 2023 Exercise 11 Solution: FCR250 Failed Claim Requirements Analysis

Exercise Info

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?

Exercise Answer

Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.