SpecifiedMicroorganismsQualityChecker

Specified Microorganisms

LabEx laboratory QC CSV→JSON URS & FS microbiology solid dosage forms utilities / cleanroom
Open selection
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

IDRequirementCriticalityAcceptance criterion
URS-001The utility shall accept input.csv with approved columns: BatchNumber, ProductName, EscherichiaColi, Salmonella, PseudomonasAeruginosa, StaphylococcusAureus, CandidaAlbicans, Clostridium, BileTolerantGramNeg.HighThe CSV file is processed without manual header editing.
URS-002The utility shall perform deterministic evaluation for “Specified Microorganisms” 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
1BatchNumberMICRO-2026-SPEC-001Input parameter for deterministic QC evaluation.
2ProductNameHerbal Extract PowderInput parameter for deterministic QC evaluation.
3EscherichiaColi0Input parameter for deterministic QC evaluation.
4Salmonella0Input parameter for deterministic QC evaluation.
5PseudomonasAeruginosa0Input parameter for deterministic QC evaluation.
6StaphylococcusAureus0Input parameter for deterministic QC evaluation.
7CandidaAlbicans0Input parameter for deterministic QC evaluation.
8Clostridium0Input parameter for deterministic QC evaluation.
9BileTolerantGramNeg50Input 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

Gastroenterology QC Suite

QC package for gastroenterology: PPIs, antiemetics, prokinetics, IBD medicines, laxatives, enzymes and GI anti-infectives.

Open

Infectious Diseases QC Suite

QC utility package for infectious diseases: antibacterial, antiviral, antifungal and antiparasitic products, microbiology, sterility, endotoxins, viral safety and vaccine release checks.

Open

LabEx QC Suite

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

Open