Back to Home

Back to BO Review

Back to Rebuttal Tab

Rebuttal SQL

Table of Contents

• Overview
• Stored Procedures
• Tables
• Web Pages

Overview

All web pages, user controls, stored procedures, tables, important columns associated with the Rebuttal flow.

Stored Procedures

• smart.p11_Read_IntakeForm
  • @Option = 'Rebuttal'
    • Selects closed audits and FinalError = 1 (Error Resolved) and the date is within 3 business days.
    • @FromDate must be less than 3 business days, if @FromDate is NOT great or equal to DateClosed, Allow for Rebuttal Gridview will not show.
    • [Test] - Set DateClosed value past 3 business days.
      • See "DATEPART()", "FinalError", "Notes" in [Definitions]
  • @Option = 'RebuttalOpened'
    • Selects audits that have been open for rebuttal by BO, but waiting on BM approval.
      • FinalError = 1, RebuttalStageNo = 1
  • @Option = 'RebuttalReview'
    • Selects audits that are under SME Review.
      • StageNo = 10, RebuttalStageNo = 2
      • RebuttalStageNo = 3 - Rebuttal Approved, Finalized
      • RebuttalStageNo = 10 - Rebuttal Disaproved, Finalized
  • @Option = 'RebuttalBusinessDay'
    • Dynamically shows title "Allowed for Rebuttal - 3 Business days from Today"
  • @Option = 'RebuttalOpenedBM'
    • Selects audits awaiting BM approval
      • RebuttalStageNo = 1 - waiting for BM Approval
      • RebuttalStageNo = 2 - SME is working on audit (view only)
      • RebuttalStageNo = 3 - Rebuttal Approved, Finalized (view only)
      • RebuttalStageNo = 10 - Rebuttal Disaproved, Finalized (view only)

Tables

• [smart].p11_qry_IntakeForm_Short
• [smart].p11_AuditCheckList_FieldList

Web Pages

Web Pages

• p11_BO_Review.aspx
• p11_BM_Review.aspx