WaterActivityQualityChecker
Water Activity
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
| ID | Requirement | Criticality | Acceptance criterion |
|---|---|---|---|
| URS-001 | The utility shall accept input.csv with approved columns: BatchNumber, ProductName, WaterActivity_Aw, Temperature_C, EquilibriumTime_min, ProductType. | High | The CSV file is processed without manual header editing. |
| URS-002 | The utility shall perform deterministic evaluation for “Water Activity” without machine learning. | High | The same input data produce the same JSON result. |
| URS-003 | The utility shall validate mandatory fields, numeric formats, flags, ranges and domain plausibility. | High | Schema and conversion errors are explicitly reported. |
| URS-004 | The utility shall generate output.json with PASS / WARNING / FAIL statuses, source values, warnings and failures. | High | The JSON result is suitable for review, deviation investigation and integration. |
| URS-005 | The documentation shall support IQ/OQ/PQ or CSV/CSA verification. | Medium | URS/FS, CSV/JSON contract and test scenarios are supplied with the utility. |
input.csv contract
| # | Field | Sample | Purpose |
|---|---|---|---|
| 1 | BatchNumber | AW-2026-TAB-001 | Input parameter for deterministic QC evaluation. |
| 2 | ProductName | Amoxicillin Tablets | Input parameter for deterministic QC evaluation. |
| 3 | WaterActivity_Aw | 0.35 | Input parameter for deterministic QC evaluation. |
| 4 | Temperature_C | 25.0 | Input parameter for deterministic QC evaluation. |
| 5 | EquilibriumTime_min | 15.0 | Input parameter for deterministic QC evaluation. |
| 6 | ProductType | Solid | Input parameter for deterministic QC evaluation. |
FS — Functional Specification
| ID | Function | Implementation |
|---|---|---|
| FS-001 | CSV import | Read input.csv; validate header, column count and encoding. |
| FS-002 | Schema validation | Check required fields and permitted input values. |
| FS-003 | Rule engine | Apply domain rules, limits and system suitability/specification checks described in the source utility description. |
| FS-004 | Status aggregation | Produce final status: FAIL for critical failure, WARNING for non-critical deviation, PASS for conformance. |
| FS-005 | JSON export | Write 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
FAILor 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.
OpenDental & 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.
OpenLabEx QC Suite
LabEx package for laboratory QC methods: chromatography, spectroscopy, microbiology, sterility, endotoxins, particles, dissolution, water, cleanrooms and sample preparation.
OpenToxicology 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