Back to Home

Back to QR Review

QR Review SQL

Table of Contents

Overview

Tables and stored procedure used to select, update checklist fields in QR Review.

Tables

p11_AuditChecklist_FieldList

Stores the errors at the field level. Has data for all error information One of the most important tables for error calculations Primary Key UniqueAuditFieldNo. Foreign Key UniqueAuditChecklistNo and UniqueInstanceNo1

p11_AuditChecklist_Confirmed

Stores the information for confirmation of no errors at the field level. Primary Key UniqueNo. Foreign Key UniqueAuditChecklistNo

p11_AuditChecklist_PlanName

Stores which plans the error is for On the error popup page, a QR can select a subset of plans to assess the error on. This table let's you know which ones.Primary Key UniqueNo. Foreign Key UniqueAuditChecklistNo and UniquePlanNameNo

Stored Procedure

  1. Smart.p11_Read_IntakeForm @option = Checklist