Back to Home

Benefit Results Report

Table of Contents

• Overview
• Dropdown Checkbox List
• Drop Downs
• Calculations
• Tables
• Stored Procedures

Overview

Benefit Result Report pulls all audits or can be narrowed down by drop downs, shows overall calculations, and these calculations are based on BO Team, Business Owner, and audit detail. The condition to see data from this report is when the Audit is closed.

Images 1: Shows a benefit results report in cumulative view

Image 2: Shows a benefit results report in a monthly view

Dropdown Checkbox List

Multiple inspection types can be selected from the Dropdown Checkbox List.

1. Business Type: (or Inspection Type) CIT, ePro, Benefit/SBC, Facets, Non Facets

Drop Downs

User can narrow down the report by using drop down filters.

1. Month Range: From Month, Year - To Month, Year
2. Effective Date
3. Business Owner Team
4. Monthly/YTD
5. Location: On Site, Off Site, GSP

Calculations

1. Quality Metric = 1 - (ErrorPoint / OpportunityPoint) Definition
2. Error Rate = ErrorPoint / OpportunityPoint
3. Total Audits
4. Total Audits Correct
5. First Pass % = TotalAuditsCorrect / Total Audits
6. Total Opportunity
7. Total Errors
8. Average Errors = Total Errors / Total Audits

Tables and Views

• smart.p11_qry_IntakeForm_short

  • [DateClosed] used to filter all audits in closed state and From, To Month dropdowns
  • [TransactionEffectiveDate] determines if audit shows in report

• smart.p11_Team

• smart.p11_CodeList

Stored Procedures

• smart.p11_Report_BenefitResult