TOCWaterQualityChecker

TOC Water

LabEx laboratory QC CSV→JSON URS & FS utilities / cleanroom
Open selection
TOC Water Quality Checker — Control of Total Organic Carbon in Water

ℹ️  Utility checks the quality of Purified Water (PW) and Water for Injection (WFI) according to USP <643> (TOC) and USP <645> (Conductivity):
     • Total Organic Carbon (TOC): ≤ 500 ppb (µg/L)
     • Conductivity: ≤ 1.3 µS/cm at 25°C (Stage 1)
     • System Suitability (SST): Standard response 85-115% of theoretical
     • Blank: ≤ 100 ppb (background control)

⚠️  CRITICAL: High TOC level (>500 ppb) indicates possible bacterial contamination, resin degradation, or organic leakage!
     Conductivity exceedance indicates insufficient demineralization.

Usage:
  TOCWaterQualityChecker.exe                            → demo mode (console output)
  TOCWaterQualityChecker.exe input.csv output.json      → evaluate your data

Input format:
BatchNumber,WaterType,TOC_ppb,Conductivity_uS_cm,Temperature_C,ResponseStandard_ppb,BlankResponse_ppb

Example:
  WFI-2026-LOOP-001,WFI,120.0,0.9,25.0,480.0,50.0

— WHY IS THIS NEEDED?
Water is the most used component in pharmaceutical manufacturing.
TOC control replaces the obsolete "Oxidizable Substances" test and is a more sensitive indicator of organic contamination.
Conductivity controls the presence of ionic impurities. These two parameters are key for water release into production.

⚠️  CRITICAL:
• TOC ≤ 500 ppb — strict limit for PW and WFI worldwide (USP, EP, JP).
• Conductivity depends on temperature. At 25°C limit is 1.3 µS/cm. For other temperatures, USP <645> tables are used.
• System Suitability (SST) must be performed daily or before a series of measurements using sucrose or benzoquinone standard.
• High background (Blank) makes measurements unreliable.

Key features:
• Simultaneous check of TOC and Conductivity
• System Suitability (SST) control
• Temperature consideration for conductivity interpretation
• Generation of reports for Engineering and QC departments, and LIMS LabWare
• Compliance with USP <643>, USP <645>, Ph. Eur. 2.2.44

Critical parameters:
• TOC: ≤ 500 ppb
• Conductivity: ≤ 1.3 µS/cm (at 25°C)
• Standard Response (SST): 85-115%
• Blank: ≤ 100 ppb

💡 Usage tips:
1. Sampling: Use dedicated TOC taps, flushing the system with water for 2-5 minutes beforehand.
2. Bubbles: Avoid air bubbles in the instrument cell, as CO₂ from air affects conductivity and TOC.
3. Calibration: Calibrate the instrument with sucrose standard (500 ppb C) regularly.
4. Interpretation: If TOC is normal but conductivity is high — problem with ion exchange resins or RO. If vice versa — problem with biofilm or organics.
5. Storage: TOC samples cannot be stored long; analysis should be performed immediately or within 24 hours under refrigeration.

⚠️ Note: USP allows testing in three stages (Stage 1, 2, 3). This utility focuses on Stage 1 (online or lab analysis without complex temperature compensation tables), which is the most common scenario for rapid control.

input.csv

BatchNumber,WaterType,TOC_ppb,Conductivity_uS_cm,Temperature_C,ResponseStandard_ppb,BlankResponse_ppb
WFI-2026-LOOP-001,WFI,120.0,0.9,25.0,480.0,50.0
PW-2026-TANK-002,PW,450.0,1.1,24.5,490.0,80.0
WFI-2026-FAIL-003,WFI,600.0,0.8,25.0,485.0,45.0

URS & FS — TOC Water

This document describes the user requirements and functional specification for TOCWaterQualityChecker. The utility is intended for QC laboratory use as a rule-based check of data prepared from an instrument, LIMS, ELN, MES or an approved input.csv.

URS — User Requirements Specification

IDRequirementCriticalityAcceptance criterion
URS-001The utility shall accept input.csv with approved columns: BatchNumber, WaterType, TOC_ppb, Conductivity_uS_cm, Temperature_C, ResponseStandard_ppb, BlankResponse_ppb.HighThe CSV file is processed without manual header editing.
URS-002The utility shall perform deterministic evaluation for “TOC Water” without machine learning.HighThe same input data produce the same JSON result.
URS-003The utility shall validate mandatory fields, numeric formats, flags, ranges and domain plausibility.HighSchema and conversion errors are explicitly reported.
URS-004The utility shall generate output.json with PASS / WARNING / FAIL statuses, source values, warnings and failures.HighThe JSON result is suitable for review, deviation investigation and integration.
URS-005The documentation shall support IQ/OQ/PQ or CSV/CSA verification.MediumURS/FS, CSV/JSON contract and test scenarios are supplied with the utility.

input.csv contract

#FieldSamplePurpose
1BatchNumberWFI-2026-LOOP-001Input parameter for deterministic QC evaluation.
2WaterTypeWFIInput parameter for deterministic QC evaluation.
3TOC_ppb120.0Input parameter for deterministic QC evaluation.
4Conductivity_uS_cm0.9Input parameter for deterministic QC evaluation.
5Temperature_C25.0Input parameter for deterministic QC evaluation.
6ResponseStandard_ppb480.0Input parameter for deterministic QC evaluation.
7BlankResponse_ppb50.0Input parameter for deterministic QC evaluation.

FS — Functional Specification

IDFunctionImplementation
FS-001CSV importRead input.csv; validate header, column count and encoding.
FS-002Schema validationCheck required fields and permitted input values.
FS-003Rule engineApply domain rules, limits and system suitability/specification checks described in the source utility description.
FS-004Status aggregationProduce final status: FAIL for critical failure, WARNING for non-critical deviation, PASS for conformance.
FS-005JSON exportWrite machine-readable output.json for LIMS/ELN/MES and QA/QC review.

OQ/PQ scenarios

  • OQ-001: a valid sample row shall be processed without schema error.
  • OQ-002: a missing mandatory column shall produce a schema error.
  • OQ-003: a non-numeric value in a numeric field shall produce a conversion error.
  • OQ-004: a critical parameter outside the limit shall produce FAIL or a critical finding.
  • PQ-001: user real batches shall be checked with retention of input.csv, output.json, utility version and checksum.

Included in packages

Biopharmaceuticals Extended QC Suite

Extended QC utility coverage for mAbs, biosimilars, proteins, insulins, vaccines, mRNA/LNP, HCP, sterile release, microbiology, water, cleanroom and stability workflows.

Open

Dental & Dental Materials QC Suite

QC utility package for dental medicinal products, oral-care products and dental materials: anaesthetics, antiseptics, analgesic/anti-infective products, polymers/minerals, resins, bonding workflows, microbiology, stability and material QC.

Open

LabEx QC Suite

LabEx package for laboratory QC methods: chromatography, spectroscopy, microbiology, sterility, endotoxins, particles, dissolution, water, cleanrooms and sample preparation.

Open