Back to Home

Daily Production Report GateKeeper

Table of Contents

• Overview
• Calculations
• Tables
• Stored Procedure

Overview

Daily Production GateKeeper Report allows Quality Managers to monitor daily production based on the inspection inventory.

• This report is specific to Proclaim (9), Proclaim Benefits and Proclaim Structures
• The Plan Count comes from the Class Count number field in the Intake Form

Calculations

• DocumentTypeNo counted from smart.p11_IntakeForm
• Not In Scope selections are saved in a separate table. smart.p11_Not_In_Scope

1. The first gridView dgv_Auditor displays the Production Report based on the DateEntered Timestamp with the ReportMonth dropdown.

   • Although the secondary gridview shows an Audit Count total of 3, an Intake Form with BOTH (Structure & Benefits) were created simulataneously which counts as 1. See below Audit Count
     • Audit Count
       • Structure = 1
       • Benefits = 1
       • Both (Structure & Benefits) = 1
       • Not In Scope = 1

2. The second gridview dgv_IntakeForm displays the Audit Count for each individual DocumentType

Tables

• smart.p11_IntakeForm
  • DateEntered: Report checks for DateEntered time stamp audits only
    • NOTE: Daily Production Report uses DateClosed to filter report data.
• smart.p11_Not_In_Scope
  • When Not In Scope Radiobutton is selected when creating a new intake form it is saved in this table

Stored Procedure

• smart.p11_Report_DailyProduction_GateKeeper
  • Option = Primary
    • dgv_Auditor data
  • Option = Secondary
    • dgv_IntakeForm data