ValganciclovirQualityChecker
Valganciclovir
Valganciclovir Quality Checker — Antiviral Agent (Ph. Eur., USP)
ℹ️ The utility checks assay, ganciclovir (hydrolysis), D-valine (isomer), methanol, dissolution profile.
ℹ️ Does not use machine learning — rule-based logic only.
⚠️ CRITICAL! Ganciclovir ≤0.5%. D-valine ≤0.2%. Methanol ≤3000 ppm!
Usage:
ValganciclovirQualityChecker.exe → demo mode
ValganciclovirQualityChecker.exe input.csv output.json → evaluate data
Input format:
BatchNumber,Assay_Percent,Melting_Point_Min,Melting_Point_Max,Ganciclovir_Content_Percent,D-Valine_Isomer_Percent,Other_Related_Substances_Percent,Total_Impurities_Percent,Loss_On_Drying_Percent,Residual_Solvent_Methanol_ppm,Residual_Solvent_Ethanol_ppm,Residual_Solvent_Acetonitrile_ppm,Heavy_Metals_ppm,Sulfated_Ash_Percent,Dissolution_30min_Percent,Dissolution_60min_Percent,Weight_Variation_RSD,Friability_Percent,Microbial_Count_TAMC,Microbial_Count_TYMC,EColi_Detected,Salmonella_Detected
Example:
VGC-SUB-2026-001,99.5,193,197,0.2,0.05,0.1,0.4,4.5,200,300,50,5,0.05,0.0,0.0,0.0,0.0,20,5,0,0
— WHY IS THIS NEEDED?
Valganciclovir — prodrug of ganciclovir (L-valyl ester):
• Hydrolysis: Valganciclovir is unstable and easily hydrolyzes to ganciclovir and valine. High content of free ganciclovir (>0.5%) indicates drug degradation during synthesis or storage.
• Stereochemistry: Only the L-valyl ester is active. Presence of the D-valyl isomer is critical to control (≤0.2%) as it may be toxic or inactive.
• Synthesis often involves methanol and ethanol. Limits are strict.
• Hygroscopicity: Valganciclovir hydrochloride is hygroscopic, so loss on drying may be higher than usual (up to 5%), but requires control.
• Dissolution profile is important for ensuring rapid conversion to ganciclovir in vivo.
⚠️ CRITICAL:
• Assay: 98–102%
• Melting Point: 190–200°C (with decomposition)
• Ganciclovir (Hydrolysis Product): ≤ 0.5% (Critical!)
• D-Valine Isomer: ≤ 0.2% (Critical!)
• Other Impurities: ≤ 0.3%
• Total Impurities: ≤ 1.0%
• Methanol: ≤ 3000 ppm
• Ethanol: ≤ 5000 ppm
• Acetonitrile: ≤ 410 ppm
• Heavy Metals: ≤ 10 ppm
• Loss on Drying: ≤ 5.0%
• Dissolution: ≥ 80% in 30 min, ≥ 85% in 60 min
• Microbiology: standard limits
⚠️ Note: Utility adapted for checking specific prodrug impurities: hydrolysis product (ganciclovir) and stereoisomer (D-valine). If dissolution data absent (0), check skipped (for substance). For finished forms, deviation from dissolution profile is critical defect. Ganciclovir control is a stability priority.
input.csv
BatchNumber,Assay_Percent,Melting_Point_Min,Melting_Point_Max,Ganciclovir_Content_Percent,D-Valine_Isomer_Percent,Other_Related_Substances_Percent,Total_Impurities_Percent,Loss_On_Drying_Percent,Residual_Solvent_Methanol_ppm,Residual_Solvent_Ethanol_ppm,Residual_Solvent_Acetonitrile_ppm,Heavy_Metals_ppm,Sulfated_Ash_Percent,Dissolution_30min_Percent,Dissolution_60min_Percent,Weight_Variation_RSD,Friability_Percent,Microbial_Count_TAMC,Microbial_Count_TYMC,EColi_Detected,Salmonella_Detected VGC-SUB-2026-001,99.5,193,197,0.2,0.05,0.1,0.4,4.5,200,300,50,5,0.05,0.0,0.0,0.0,0.0,20,5,0,0
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 Valganciclovir Quality Checker utility is used for Valganciclovir. 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: Global API expansion
Tags: antivirals, API, biologics, dissolution, essential medicines, global market, heavy metals, impurities, microbiology, oncology
2. Execution modes
ValganciclovirQualityChecker.exe → demo mode ValganciclovirQualityChecker.exe input.csv output.json → evaluate data
3. Key controlled areas
- assay / content
- purity and impurities
- dissolution / disintegration
- residual solvents
- microbiology and pathogens
- heavy metals / elemental impurities
- pH and physicochemical parameters
4. Domain limits and critical parameters
- ⚠️ CRITICAL! Ganciclovir ≤0.5%. D-valine ≤0.2%. Methanol ≤3000 ppm!
- Hydrolysis: Valganciclovir is unstable and easily hydrolyzes to ganciclovir and valine. High content of free ganciclovir (>0.5%) indicates drug degradation during synthesis or storage.
- Stereochemistry: Only the L-valyl ester is active. Presence of the D-valyl isomer is critical to control (≤0.2%) as it may be toxic or inactive.
- ⚠️ CRITICAL:
- Assay: 98–102%
- Melting Point: 190–200°C (with decomposition)
- Ganciclovir (Hydrolysis Product): ≤ 0.5% (Critical!)
- D-Valine Isomer: ≤ 0.2% (Critical!)
- Other Impurities: ≤ 0.3%
- Total Impurities: ≤ 1.0%
- Methanol: ≤ 3000 ppm
- Ethanol: ≤ 5000 ppm
- Acetonitrile: ≤ 410 ppm
- Heavy Metals: ≤ 10 ppm
- Loss on Drying: ≤ 5.0%
- Dissolution: ≥ 80% in 30 min, ≥ 85% in 60 min
- Microbiology: standard limits
- ⚠️ Note: Utility adapted for checking specific prodrug impurities: hydrolysis product (ganciclovir) and stereoisomer (D-valine). If dissolution data absent (0), check skipped (for substance). For finished forms, deviation from dissolution profile is critical defect. Ganciclovir control is a stability priority.
5. URS — user requirements
| ID | Requirement | Criticality | Acceptance criterion |
|---|---|---|---|
| URS-001 | The system shall accept an input.csv file for Valganciclovir 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: assay / content, purity and impurities, dissolution / disintegration, residual solvents, microbiology and pathogens, 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 | BatchNumber | identifier | as specified | Batch Number | VGC-SUB-2026-001 | mandatory field; used for batch/lot traceability |
| 2 | Assay_Percent | decimal | % | Assay % | 99.5 | numeric value; compared with assay/purity limit from specification or method |
| 3 | Melting_Point_Min | decimal | °C | Melting Point Min | 193 | mandatory numeric value; rule comparison is performed by the utility |
| 4 | Melting_Point_Max | decimal | °C | Melting Point Max | 197 | mandatory numeric value; rule comparison is performed by the utility |
| 5 | Ganciclovir_Content_Percent | decimal | % | Ganciclovir Content % | 0.2 | numeric value; compared with assay/purity limit from specification or method |
| 6 | D-Valine_Isomer_Percent | decimal | % | D-Valine Isomer % | 0.05 | mandatory numeric value; rule comparison is performed by the utility |
| 7 | Other_Related_Substances_Percent | decimal | % | Other Related Substances % | 0.1 | numeric value; compared with individual or total impurity limit |
| 8 | Total_Impurities_Percent | decimal | % | Total Impurities % | 0.4 | mandatory numeric value; rule comparison is performed by the utility |
| 9 | Loss_On_Drying_Percent | decimal | % | Loss On Drying % | 4.5 | mandatory numeric value; rule comparison is performed by the utility |
| 10 | Residual_Solvent_Methanol_ppm | decimal | ppm | Residual Solvent Methanol ppm | 200 | numeric value; checked as residual solvent against the applicable limit |
| 11 | Residual_Solvent_Ethanol_ppm | decimal | ppm | Residual Solvent Ethanol ppm | 300 | numeric value; checked as residual solvent against the applicable limit |
| 12 | Residual_Solvent_Acetonitrile_ppm | decimal | ppm | Residual Solvent Acetonitrile ppm | 50 | numeric value; checked as residual solvent against the applicable limit |
| 13 | Heavy_Metals_ppm | decimal | ppm | Heavy Metals ppm | 5 | numeric value; checked as elemental/metal impurity |
| 14 | Sulfated_Ash_Percent | decimal | % | Sulfated Ash % | 0.05 | mandatory numeric value; rule comparison is performed by the utility |
| 15 | Dissolution_30min_Percent | decimal | % | Dissolution 30min % | 0.0 | numeric value; dissolution/disintegration profile checked according to method |
| 16 | Dissolution_60min_Percent | decimal | % | Dissolution 60min % | 0.0 | numeric value; dissolution/disintegration profile checked according to method |
| 17 | Weight_Variation_RSD | decimal | as specified | Weight Variation RSD | 0.0 | mandatory numeric value; rule comparison is performed by the utility |
| 18 | Friability_Percent | decimal | % | Friability % | 0.0 | mandatory numeric value; rule comparison is performed by the utility |
| 19 | Microbial_Count_TAMC | decimal | as specified | Microbial Count TAMC | 20 | numeric value; compared with microbiological limits |
| 20 | Microbial_Count_TYMC | decimal | as specified | Microbial Count TYMC | 5 | numeric value; compared with microbiological limits |
| 21 | EColi_Detected | boolean / flag | 0/1 | EColi Detected | 0 | valid flag required; prohibited organisms and growth are normally expected as 0 / absent |
| 22 | Salmonella_Detected | boolean / flag | 0/1 | Salmonella Detected | 0 | valid flag required; prohibited organisms and growth are normally expected as 0 / absent |
CSV example
BatchNumber,Assay_Percent,Melting_Point_Min,Melting_Point_Max,Ganciclovir_Content_Percent,D-Valine_Isomer_Percent,Other_Related_Substances_Percent,Total_Impurities_Percent,Loss_On_Drying_Percent,Residual_Solvent_Methanol_ppm,Residual_Solvent_Ethanol_ppm,Residual_Solvent_Acetonitrile_ppm,Heavy_Metals_ppm,Sulfated_Ash_Percent,Dissolution_30min_Percent,Dissolution_60min_Percent,Weight_Variation_RSD,Friability_Percent,Microbial_Count_TAMC,Microbial_Count_TYMC,EColi_Detected,Salmonella_Detected VGC-SUB-2026-001,99.5,193,197,0.2,0.05,0.1,0.4,4.5,200,300,50,5,0.05,0.0,0.0,0.0,0.0,20,5,0,0
7. FS — functional specification
| ID | Function | Implementation description |
|---|---|---|
| FS-001 | CLI entry point | The executable ValganciclovirQualityChecker.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 Valganciclovir, 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": "ValganciclovirQualityChecker",
"api": "Valganciclovir",
"batchNumber": "VGC-SUB-2026-001",
"overallStatus": "PASS|WARNING|FAIL",
"checkedAtUtc": "2026-05-18T00:00:00Z",
"checks": [
{
"parameter": "BatchNumber",
"value": "VGC-SUB-2026-001",
"unit": "as specified",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "Assay_Percent",
"value": "99.5",
"unit": "%",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "Melting_Point_Min",
"value": "193",
"unit": "°C",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "Melting_Point_Max",
"value": "197",
"unit": "°C",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "Ganciclovir_Content_Percent",
"value": "0.2",
"unit": "%",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "D-Valine_Isomer_Percent",
"value": "0.05",
"unit": "%",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "Other_Related_Substances_Percent",
"value": "0.1",
"unit": "%",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "Total_Impurities_Percent",
"value": "0.4",
"unit": "%",
"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. |
| TC-005 | Positive pathogen/microbiological flag or microbiological limit excursion | Critical FAIL is produced with the offending parameter. |
| TC-006 | Insufficient dissolution or excessive disintegration time | FAIL/WARNING is produced according to method criticality. |
| TC-007 | Residual solvent above applicable limit | FAIL is produced with solvent name and measured value. |
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
OpenWorld API Extension QC Suite
Extended package for 130 additional high-demand APIs and biological products prepared as a market-coverage backlog.
Open