HeavyMetalsChecker
Heavy Metals
Heavy Metals Checker — Контроль тяжёлых металлов (Ph. Eur. 2.4.8, 2.4.27)
ℹ️ Утилита проверяет соответствие содержания тяжёлых металлов требованиям Европейской фармакопеи.
ℹ️ Не использует машинное обучение — только правила.
Использование:
HeavyMetalsChecker.exe → демо-режим (вывод в консоль)
HeavyMetalsChecker.exe input.csv output.json → оценка ваших данных
Формат input.csv:
ProductName,BatchNumber,ProductType,Lead_ppm,Arsenic_ppm,Cadmium_ppm,Mercury_ppm
Пример:
Lactose_Monohydrate,B20250110,Excipient,0.5,0.3,0.1,0.05
ProductType: ActiveSubstance, Excipient, HerbalPreparation
— ЗАЧЕМ ЭТО НУЖНО?
Тяжёлые металлы (Pb, As, Cd, Hg) — токсичные примеси, которые могут попасть в ЛС из:
• сырья растительного происхождения,
• минеральных компонентов,
• оборудования и воды.
Ph. Eur. 2.4.8 применяется ко всем субстанциям, а 2.4.27 — к растительному сырью.
Отклонение = риск для пациента и отзыв препарата.
input.csv
ProductName,BatchNumber,ProductType,Lead_ppm,Arsenic_ppm,Cadmium_ppm,Mercury_ppm Lactose_Monohydrate,B20250110,Excipient,0.5,0.3,0.1,0.05
URS & FS — user requirements and functional specification
This document defines user requirements and functional specification for the quality-control utility. It supports deployment discussion, IQ/OQ preparation and QC workflow integration.
1. Scope
The Heavy Metals Checker utility is used for Heavy Metals. The actual input.csv is the source of truth for the input structure; control criteria are defined by the executable and the domain description.
The utility does not use machine learning; decisions are produced by deterministic rules.
Categories: EAEU pharmacopoeia, Pharmacopoeial methods
Tags: dissolution, EAEU, heavy metals, herbal, impurities, microbiology, minerals, particulate contamination, Ph. Eur., pharmacopoeia, residual solvents, specification, water quality
2. Execution modes
HeavyMetalsChecker.exe → демо-режим (вывод в консоль) HeavyMetalsChecker.exe input.csv output.json → оценка ваших данных
3. Key controlled areas
- dissolution / disintegration
- residual solvents
- heavy metals / elemental impurities
- pH and physicochemical parameters
4. Domain limits and critical parameters
The source description does not contain a separate critical-limit list; rules implemented in the executable and defined by the CSV schema apply.
5. URS — user requirements
| ID | Requirement | Criticality | Acceptance criterion |
|---|---|---|---|
| URS-001 | The system shall accept an input.csv file for Heavy Metals with the exact columns listed in the “Input data contract” section. | High | A file with the correct header is processed without manual editing; missing mandatory columns produce FAIL/import error. |
| URS-002 | The system shall support execution without arguments in demo mode and execution with input.csv output.json for user data. | Medium | Both execution scenarios produce a predictable result or clear diagnostic error. |
| URS-003 | The system shall perform rule-based controls for: dissolution / disintegration, residual solvents, heavy metals / elemental impurities, pH and physicochemical parameters. | High | Each controlled parameter receives a status and message; the result does not depend on hidden Excel formulas or ML. |
| URS-004 | The system shall preserve traceability between batch/lot, source values, applied rules and final verdict. | High | Output includes batch identifier, source values, parameter statuses and critical findings. |
| URS-005 | The system shall generate machine-readable output.json for LIMS/ELN/MES, batch record and QA/QC review. | High | JSON contains overall status, check array, warnings, failures and source-file reference. |
| URS-006 | The system shall support use in the client validation package: URS/FS, IQ/OQ preparation, installation and operational scenario checks. | High | The document, test scenarios and reproducible CSV/JSON flow are suitable for audit and internal approval. |
| URS-007 | The system shall clearly separate technical data errors from specification nonconformities. | Medium | Schema/type errors are not mixed with pharmacopoeial deviations and are reported separately. |
6. input.csv data contract
The source of truth for the input schema is the actual input.csv header. Column names are technical identifiers and are not translated.
| # | Column | Type | Unit | Description | Sample | Control rule |
|---|---|---|---|---|---|---|
| 1 | ProductName | identifier | as specified | Product Name | Lactose_Monohydrate | mandatory value; format and acceptability are checked by the utility |
| 2 | BatchNumber | identifier | as specified | Batch Number | B20250110 | mandatory field; used for batch/lot traceability |
| 3 | ProductType | text | as specified | Product Type | Excipient | mandatory value; format and acceptability are checked by the utility |
| 4 | Lead_ppm | decimal | ppm | Lead ppm | 0.5 | numeric value; checked as elemental/metal impurity |
| 5 | Arsenic_ppm | decimal | ppm | Arsenic ppm | 0.3 | numeric value; checked as elemental/metal impurity |
| 6 | Cadmium_ppm | decimal | ppm | Cadmium ppm | 0.1 | numeric value; checked as elemental/metal impurity |
| 7 | Mercury_ppm | decimal | ppm | Mercury ppm | 0.05 | numeric value; checked as elemental/metal impurity |
CSV example
ProductName,BatchNumber,ProductType,Lead_ppm,Arsenic_ppm,Cadmium_ppm,Mercury_ppm Lactose_Monohydrate,B20250110,Excipient,0.5,0.3,0.1,0.05
7. FS — functional specification
| ID | Function | Implementation description |
|---|---|---|
| FS-001 | CLI entry point | The executable HeavyMetalsChecker.exe supports demo mode and input.csv output.json processing mode. |
| FS-002 | CSV parser | The import module reads CSV, validates header, column presence/order, value count and encoding. Decimal values are expected with a dot separator. |
| FS-003 | Field conversion | Each column is converted to the expected type: identifier, text, decimal number, date/time or boolean flag. |
| FS-004 | Domain rule engine | For Heavy Metals, explicit rules are applied: range, minimum, maximum, absence of prohibited flag, data completeness or calculation-based check. |
| FS-005 | Criticality handling | Critical violations produce FAIL; non-critical deviations and incomplete data produce WARNING; full conformance produces PASS. |
| FS-006 | JSON writer | output.json stores overall status, per-parameter results, source values, warnings, failures and diagnostic messages. |
| FS-007 | Integration contract | The CSV → JSON format is stable for invocation from LIMS/ELN/MES, scheduled task or wrapper service. |
| FS-008 | Error handling | Schema error, missing file, non-numeric value or JSON write failure returns diagnosable error without silent PASS. |
8. output.json contract
The output file must be suitable for automated processing, audit review and correlation with the source input.csv row.
{
"utility": "HeavyMetalsChecker",
"api": "Heavy Metals",
"batchNumber": "B20250110",
"overallStatus": "PASS|WARNING|FAIL",
"checkedAtUtc": "2026-05-18T00:00:00Z",
"checks": [
{
"parameter": "ProductName",
"value": "Lactose_Monohydrate",
"unit": "as specified",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "BatchNumber",
"value": "B20250110",
"unit": "as specified",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "ProductType",
"value": "Excipient",
"unit": "as specified",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "Lead_ppm",
"value": "0.5",
"unit": "ppm",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "Arsenic_ppm",
"value": "0.3",
"unit": "ppm",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "Cadmium_ppm",
"value": "0.1",
"unit": "ppm",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "Mercury_ppm",
"value": "0.05",
"unit": "ppm",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
}
],
"criticalFindings": [],
"sourceFile": "input.csv"
}9. OQ/PQ test scenarios
| ID | Scenario | Expected result |
|---|---|---|
| TC-001 | Valid CSV with expected header and sample row | All rows are processed; output contains PASS/WARNING/FAIL and parameter-level detail. |
| TC-002 | A mandatory input.csv column is missing | Import is rejected or the row receives FAIL with schema reference. |
| TC-003 | A numeric field contains text or a blank value | Type conversion error is recorded; the result is not hidden as PASS. |
| TC-004 | A parameter is outside specification or critical limit | Critical parameters produce FAIL; non-critical deviations produce WARNING according to the rule. |
10. QA/QC, CSV and change control
- Before production use, the client records executable version, checksum, specification/monograph version, test CSV, expected JSON and IQ/OQ results.
- Column names must not be changed without updating the validator and test scenarios.
- The source CSV, output.json and utility version should be stored together as an evidence package.
- Any change in control rules must go through change control and repeated OQ scenario verification.
Included in packages
Algeria: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenArgentina: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenAustralia: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenBangladesh: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenBrazil: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenCanada: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenChina: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenColombia: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenDemocratic Republic of the Congo: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenEAEU Pharmacopoeia QC Suite
Package for EAEU pharmacopoeial methods: specifications, dissolution, microbiology, impurities and general tests.
OpenEgypt: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenEthiopia: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenEuropean Pharmacopoeia QC Suite
Utilities for general pharmacopoeial methods and tests in the European regulatory context.
OpenFrance: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenGermany: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenIndia: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenIndonesia: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenIran: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenItaly: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenJapan: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenKenya: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenMexico: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenMyanmar: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenNigeria: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenPakistan: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenPhilippines: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenRussia: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenSaudi Arabia: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenSouth Africa: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenSouth Korea: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenSudan: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenTanzania: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenThailand: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
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.
OpenTurkey: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenUganda: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenUnited Kingdom: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenUnited States: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
OpenVietnam: national essential medicines QC package
QC utility package aligned with the country essential/reimbursed medicines list analogue and cross-checked against WHO EML. Only utilities already present in the portal are included; the package is a validation/discussion starting map, not an official registry copy.
Open