SpecifiedMicroorganismsQualityChecker
Specified Microorganisms
Specified Microorganisms Quality Checker — Control of Specified Microorganisms
ℹ️ Utility checks for the absence of pathogenic microorganisms in non-sterile pharmaceutical products according to Ph. Eur. 2.6.13 and USP <62>:
• Escherichia coli — indicator of fecal contamination (must be absent in 1g/1ml)
• Salmonella — pathogen causing intestinal infections (must be absent in 10g/10ml)
• Pseudomonas aeruginosa — opportunistic pathogen (must be absent in 1g/1ml)
• Staphylococcus aureus — cause of purulent infections (must be absent in 1g/1ml)
• Candida albicans — yeast-like fungus (must be absent in 1g/1ml)
• Clostridium — anaerobic spore-forming bacteria (must be absent in 10g/10ml)
• Bile-Tolerant Gram-Negative Bacteria — limit <10^2 CFU/g or mL
⚠️ CRITICAL: Detection of any of the specific pathogens (E. coli, Salmonella, P. aeruginosa, S. aureus, C. albicans, Clostridium) leads to immediate batch rejection!
This is a patient safety requirement.
Usage:
SpecifiedMicroorganismsQualityChecker.exe → demo mode (console output)
SpecifiedMicroorganismsQualityChecker.exe input.csv output.json → evaluate your data
Input format:
BatchNumber,ProductName,EscherichiaColi,Salmonella,PseudomonasAeruginosa,StaphylococcusAureus,CandidaAlbicans,Clostridium,BileTolerantGramNeg
Example (0=Absent, 1=Present, number for bile-tolerant):
MICRO-2026-SPEC-001,Herbal Extract,0,0,0,0,0,0,50
— WHY IS THIS NEEDED?
Non-sterile pharmaceutical products (tablets, ointments, syrups, herbal raw materials) must not contain certain pathogenic microorganisms that may pose a risk to patient health, especially for immunocompromised individuals.
The test for specified microorganisms is a mandatory part of microbiological quality.
⚠️ CRITICAL:
• Escherichia coli — presence indicates unsatisfactory production hygiene or contaminated raw materials.
• Salmonella — highly toxic, even small amounts are dangerous.
• Pseudomonas aeruginosa — resistant to many antibiotics, dangerous for wounds and mucous membranes.
• Staphylococcus aureus — can produce toxins.
• Candida albicans — causes candidiasis.
• Clostridium — risk of gas gangrene and botulism (depending on species).
• Bile-Tolerant Gram-Negative Bacteria — their quantity is limited (<100 CFU/g) as they indicate general sanitary status.
Key features:
• Check of all main pathogens according to Pharmacopoeia
• Strict control of absence for dangerous species
• Quantitative control for bile-tolerant bacteria
• Generation of reports for regulatory authorities and LIMS LabWare
• Compliance with Ph. Eur. 2.6.13 and USP <62>
Critical parameters:
• Escherichia coli: Absent in 1g/1ml
• Salmonella: Absent in 10g/10ml
• Pseudomonas aeruginosa: Absent in 1g/1ml
• Staphylococcus aureus: Absent in 1g/1ml
• Candida albicans: Absent in 1g/1ml
• Clostridium: Absent in 10g/10ml
• Bile-Tolerant Gram-Negative Bacteria: < 10^2 CFU/g
💡 Usage tips:
1. Detection methods: Enrichment methods in selective media followed by identification (biochemical or molecular) are used.
2. Sampling: Must be representative. For solid forms, 10g or 1g is used depending on the test.
3. Neutralization of antimicrobial activity: If the product has preservative properties, neutralizers must be used in the medium.
4. Interpretation: A "Present" (1) result for any of the first six parameters automatically means FAIL.
5. Investigation: A positive result requires a thorough investigation of the source of contamination (raw materials, water, personnel, equipment).
⚠️ Note: The test for specified microorganisms differs from the Total Aerobic Microbial Count (TAMC/TYMC). TAMC counts all living cells, while this test looks for specific dangerous species that may be absent in the total count but be deadly.input.csv
BatchNumber,ProductName,EscherichiaColi,Salmonella,PseudomonasAeruginosa,StaphylococcusAureus,CandidaAlbicans,Clostridium,BileTolerantGramNeg MICRO-2026-SPEC-001,Herbal Extract Powder,0,0,0,0,0,0,50 MICRO-2026-SPEC-002,Cream Base A,0,0,1,0,0,0,10 MICRO-2026-SPEC-003,Oral Suspension Z,0,0,0,0,0,0,150
URS & FS — Specified Microorganisms
This document describes the user requirements and functional specification for SpecifiedMicroorganismsQualityChecker. 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, EscherichiaColi, Salmonella, PseudomonasAeruginosa, StaphylococcusAureus, CandidaAlbicans, Clostridium, BileTolerantGramNeg. | High | The CSV file is processed without manual header editing. |
| URS-002 | The utility shall perform deterministic evaluation for “Specified Microorganisms” 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 | MICRO-2026-SPEC-001 | Input parameter for deterministic QC evaluation. |
| 2 | ProductName | Herbal Extract Powder | Input parameter for deterministic QC evaluation. |
| 3 | EscherichiaColi | 0 | Input parameter for deterministic QC evaluation. |
| 4 | Salmonella | 0 | Input parameter for deterministic QC evaluation. |
| 5 | PseudomonasAeruginosa | 0 | Input parameter for deterministic QC evaluation. |
| 6 | StaphylococcusAureus | 0 | Input parameter for deterministic QC evaluation. |
| 7 | CandidaAlbicans | 0 | Input parameter for deterministic QC evaluation. |
| 8 | Clostridium | 0 | Input parameter for deterministic QC evaluation. |
| 9 | BileTolerantGramNeg | 50 | 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.
OpenGastroenterology QC Suite
QC package for gastroenterology: PPIs, antiemetics, prokinetics, IBD medicines, laxatives, enzymes and GI anti-infectives.
OpenInfectious Diseases QC Suite
QC utility package for infectious diseases: antibacterial, antiviral, antifungal and antiparasitic products, microbiology, sterility, endotoxins, viral safety and vaccine release checks.
OpenLabEx QC Suite
LabEx package for laboratory QC methods: chromatography, spectroscopy, microbiology, sterility, endotoxins, particles, dissolution, water, cleanrooms and sample preparation.
Open