Back to ER Diagram
Quality Management

Quality Management Logic

Inspection & Test Plans (ITP), inspections, Non-Conformance Reports (NCR), CAPA, snag lists, material testing, and commissioning management.

PostgreSQL
11 Tables
Schema: qms
ITP Tracking

Overview

Quality Management System (QMS) ensures construction quality through Inspection & Test Plans (ITP) that define hold/witness/review points. Inspections are conducted at each ITP checkpoint. Non-conformances raise NCRs with root cause analysis and CAPA. Snag lists track punch items before handover. Material testing records ensure compliance with specifications. Commissioning management tracks system testing and handover.


Create ITP

Inspect

NCR (if fail)

CAPA

Snag/Commission
11
QMS Tables
Hold/Witness
Inspection Points
Zero
NCR Target
100%
Snag Closure

Status States

StatusDescriptionAllowed ActionsNext States
PlannedITP created, inspections scheduledSchedule, Assign InspectorIn Progress
PassedInspection passed at checkpointRecord, Move to NextCompleted
FailedInspection failed — NCR raisedInvestigate, Assign CAPANCR Open
NCR OpenNon-conformance under investigationRoot Cause, Define CAPACAPA In Progress
CAPA In ProgressCorrective actions being implementedComplete, VerifyVerified
VerifiedCAPA effectiveness verifiedClose NCRClosed
CommissionedSystem tested and handed overIssue Certificate

Database Schema

qms.itp

  • itp_id — PK, Inspection & Test Plan
  • project_id — FK → project.project
  • itp_number, activity_description — Plan identifier and scope
  • specification_ref — Referenced standard (IS/BS/ASTM)
  • inspection_type — hold | witness | review
  • frequency — per_lot | per_floor | continuous
  • status — Active / Completed / Superseded

qms.inspection

  • inspection_id — PK
  • itp_id — FK → qms.itp
  • inspection_date, location — When and where inspected
  • result — pass | fail | conditional
  • inspector_id — FK → admin.user (QA/QC engineer)
  • client_witness — Whether client representative was present
  • remarks, photos_url — Observations and evidence

qms.ncr

  • ncr_id — PK, Non-Conformance Report
  • project_id — FK → project.project
  • inspection_id — FK → qms.inspection (optional)
  • ncr_number, description — Issue details
  • severity — minor | major | critical
  • root_cause, disposition — Analysis and decision (rework/accept/reject/repair)
  • status — Open → CAPA → Verified → Closed

qms.snag_list

  • snag_id — PK, punch list item
  • project_id — FK → project.project
  • location, description — Snag details
  • category — structural | finishing | MEP | external
  • assigned_to — FK → admin.user or subcontractor
  • target_date, closed_date — Resolution tracking
  • status — Open → In Progress → Closed

qms.commissioning

  • comm_id — PK
  • project_id — FK → project.project
  • system_name, description — System being commissioned
  • test_type — pre_commissioning | commissioning | performance
  • test_date, result — Testing details
  • punch_items_count, closed_count — Outstanding items tracking

Quality Process Steps

1

ITP Creation

Quality team creates ITP for each activity with inspection points (Hold/Witness/Review), frequency, acceptance criteria, and referenced specifications. Client approves ITP.

2

Inspection Execution

At each ITP checkpoint, QA/QC engineer conducts inspection. Hold points require client witness before proceeding. Results recorded with photos and measurements.

3

NCR Issuance

When inspection fails, NCR raised with severity classification. Root cause analysis conducted (5-Why, Fishbone). Disposition decided: rework, use-as-is, reject, or repair.

4

CAPA Implementation

Corrective actions defined with responsible person and target date. Preventive actions address systemic issues. CAPA effectiveness verified after implementation.

5

Snag Management

Before handover, comprehensive snag walk-through generates punch list. Snags categorized, assigned, and tracked to closure. Zero open snags required for handover certificate.

6

Commissioning

Systems tested progressively — pre-commissioning checks, commissioning tests, performance testing. Each test documented with results. Final commissioning certificate issued.

Quality Queries

NCR Analysis

-- NCR statistics by category and severity
SELECT n.severity,
       COUNT(*) AS total_ncrs,
       COUNT(CASE WHEN n.status = 'Closed' THEN 1 END) AS closed,
       COUNT(CASE WHEN n.status != 'Closed' THEN 1 END) AS open_ncrs,
       ROUND(AVG(EXTRACT(DAY FROM n.closed_date - n.created_at)), 1) AS avg_closure_days
FROM qms.ncr n
WHERE n.project_id = :project_id
GROUP BY n.severity
ORDER BY n.severity;

Validation Rules

Business Rules

  • Hold Point: Work cannot proceed past Hold point without signed inspection record
  • NCR Timeline: Critical NCRs must have CAPA within 48 hours
  • Snag Closure: Handover certificate blocked if open snags > 0
  • Material Test: Materials without valid test certificates cannot be used in permanent works

Integration Points

Connected Modules

  • Project: ITP linked to project activities and WBS
  • Receiving: Material inspection plan feeds GRN quality check
  • Subcontractor: NCRs against subcontractor work impact SC performance rating
  • Document: Inspection reports and test certificates stored in document management

Best Practices

Recommended

  • Conduct daily quality walks with documented checklists
  • Track NCR closure rate as key quality KPI
  • Use digital checklists with photo evidence for inspections
  • Implement quality cost tracking (prevention + appraisal + failure costs)