Altair Monarch Exercise 9 - Patient Service Codes

Baba_Majekodunmi_703

Exercise Info

• Application (Classic vs Data Prep Studio): Data Prep Studio
  
• Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate
• Skills/Features Tested: Report Trapping, Filters, Formula Field, Group By
  
• Systems of Record: Not Applicable
• Estimated Time to Solve: 10 mins
• Exercise files required are attached
  • Patient.txt
  • Service Codes Rejected.xlsx

Exercise Overview

You are a Patient Financial Services (PFS) Operations Analyst, and you need to identify the list of recently rejected services that were provided to patients, and those services that were not rejected, and the total amount for those lists (rejected and non-rejected)

The list of services are on the Patient.txt file which also includes the service codes. For this exercise you're only interested in the service codes that start with A. The Excel files contains a list of all Service codes that were recently rejected.

Your manager has encouraged you to use an inner join and negative join to help you answer these questions in the Data Prep Studio.

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.