Back to Home

Daily Production Report

Table of Contents

• Overview
• Auditor and Errors
• Calculations
• Tables
• Stored Procedure
• Additional Information

Overview

Daily Production Report allows Quality Managers to monitor daily production at the auditor, plan, and field level compared to the counts in Daily Production Level. Drop downs can specify audits by Inspection Type, QR Team, Team Member, Month, and Platforms.

Audit must be closed (DateClosed = 1).

Auditor and Errors

The quality manager can click on an individual auditor to see report data only for that auditor.

The data in "Errors" tab only shows the count for Business Types (ie. New, Renewal, Cancellation) data. Can be specified with drop downs.

Calculations

• Ratio = ErrorPoint / FieldCount
• Error Removal Ratio = Plan With Errors / AuditCount

Tables

• smart.p11_IntakeForm
  • DateClosed: Report checks for closed audits only

Stored Procedure

• smart.p11_Report_DailyProduction_IntakeForm
  • Overall daily production
• smart.p11_Report_DailyProduction_Auditor
  • Auditor only report
• smart.p11_Report_DailyProduction_BusinessType
  • Business Type only (ie. New, Renewal, Cancellation)

Additional Information

Samples

Plan Count Field is controlled by a Report Plan Count dropdownlist. See Image below

• Checklist Setup Count (1): Default value - counts field errors
  • Samples List: 1,2,3,4,5,6,7,10,11,14,15,16,17,18,20
• Case Details Count (2): Count comes from Case Details
  • Samples List: 8,9,12,13,19,21,22

SQL Stored Procedures

• smart.p11_Report_DailyProduction_Auditor
• smart.p11_Report_DailyProduction_BusinessType
• smart.p11_Report_DailyProduction_IntakeForm

the IIF statement will display calculate by Case Details Count if ReportPlanNo = 2, otherwise calculate as Plan Count

iif(ReportPlanCountNo = 2, SUM(b.Plan1Count), SUM(a.PlanCount)) as PlanCount