WaterActivityQualityChecker

Water Activity

LabEx laboratory QC CSV→JSON URS & FS microbiology solid dosage forms utilities / cleanroom
Open selection
Water Activity Quality Checker — Control of Water Activity (Aw)

ℹ️  Utility checks Water Activity (Aw) of pharmaceutical products according to Ph. Eur. 2.9.39 and USP <1112>:
     • Water Activity (Aw) — thermodynamic activity of water in the system (ratio of vapor pressure of product to vapor pressure of pure water)
     • Critical limits: 
       - Aw < 0.60: Safe for most solid forms (no microbial growth)
       - Aw 0.60–0.75: Mold and yeast growth possible
       - Aw > 0.75: Bacterial growth possible
     • Temperature control (standard 25°C)
     • Equilibrium time monitoring

⚠️  CRITICAL: Exceedance of Aw > 0.60 significantly accelerates hydrolysis of active ingredients and increases risk of microbiological spoilage!
     Unlike moisture content (LOD), Aw shows specifically the "free" water available for reactions.

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

Input format:
BatchNumber,ProductName,WaterActivity_Aw,Temperature_C,EquilibriumTime_min,ProductType

Example:
  AW-2026-TAB-001,Amoxicillin Tabs,0.35,25.0,15.0,Solid

— WHY IS THIS NEEDED?
Water activity is a key stability parameter for non-sterile products.
It determines shelf life, packaging selection (barrier properties), and storage conditions.
For hygroscopic substances, Aw control is critical to prevent caking and polymorphic changes.

⚠️  CRITICAL:
• Aw ≠ Moisture Content. A product with low moisture can have high Aw if water is weakly bound.
• Temperature: Measurement must be performed at controlled temperature as Aw depends on T.
• Equilibrium: Measurement is complete only when Aw change stabilizes (drift < specified value).
• Calibration: Instrument must be calibrated using saturated salt solutions (LiCl, MgCl2, NaCl, etc.).

Key features:
• Assessment of microbial growth risk based on Aw level
• Control of measurement conditions (temperature, time)
• Support for different product types with individual limits
• Generation of reports for Stability departments and LIMS LabWare
• Compliance with GMP and Pharmacopoeia requirements

Critical parameters:
• Water Activity (Aw): < 0.60 (for solids), < 0.75 (for some semisolids)
• Temperature: 25.0 ± 0.5°C
• Equilibrium Time: < 60 min (typical)

💡 Usage tips:
1. Sample Preparation: Avoid prolonged contact of sample with air before measurement.
2. Sample Volume: Fill instrument cup evenly, avoiding voids but not overfilling the sensor.
3. Sample Temperature: Ideally, sample temperature should be close to measurement temperature (25°C) to speed up equilibrium.
4. Cleaning: Aw sensors are very sensitive to contamination. Clean them with mild non-abrasive agents.
5. Interpretation: If Aw is high, consider using desiccants in primary packaging or changing formulation (adding humectants).

⚠️ Note: Water activity is a more accurate predictor of stability than moisture percentage, especially for complex multi-component systems (tablets with different excipients).

input.csv

BatchNumber,ProductName,WaterActivity_Aw,Temperature_C,EquilibriumTime_min,ProductType
AW-2026-TAB-001,Amoxicillin Tablets,0.35,25.0,15.0,Solid
AW-2026-POW-002,Lactose Monohydrate,0.45,25.0,20.0,Solid
AW-2026-CREAM-003,Hydrocortisone Cream,0.85,25.0,45.0,SemiSolid

URS & FS — Water Activity

This document describes the user requirements and functional specification for WaterActivityQualityChecker. 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, ProductName, WaterActivity_Aw, Temperature_C, EquilibriumTime_min, ProductType.HighThe CSV file is processed without manual header editing.
URS-002The utility shall perform deterministic evaluation for “Water Activity” 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
1BatchNumberAW-2026-TAB-001Input parameter for deterministic QC evaluation.
2ProductNameAmoxicillin TabletsInput parameter for deterministic QC evaluation.
3WaterActivity_Aw0.35Input parameter for deterministic QC evaluation.
4Temperature_C25.0Input parameter for deterministic QC evaluation.
5EquilibriumTime_min15.0Input parameter for deterministic QC evaluation.
6ProductTypeSolidInput 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

Toxicology QC Suite

QC utility package for toxicologically relevant risks: genotoxic impurities, residual solvents, elemental impurities, heavy metals, mercury, mycotoxins, pesticides, extractables/leachables and degradation impurities.

Open