EthinylestradiolDesogestrelQualityChecker
Ethinylestradiol Desogestrel
Ethinylestradiol + Desogestrel Quality Checker — Combined Tablets (Novinet, Mercilon) (Ph. Eur., ICH Q6A)
ℹ️ The utility checks content of both active substances, impurities (17-epimer EE, 3-keto and epi-desogestrel), weight variation, disintegration, dissolution, microbiology (including pathogens), friability.
ℹ️ Does not use machine learning — rule-based logic only.
⚠️ Critical for COC production (Novinet, Mercilon). Strict desogestrel impurity control is mandatory due to impact on progestogenic activity and safety!
Usage:
EthinylestradiolDesogestrelQualityChecker.exe → demo mode (console output)
EthinylestradiolDesogestrelQualityChecker.exe input.csv output.json → evaluate your data
Input format:
BatchNumber,EthinylestradiolContent,DesogestrelContent,ImpurityEthinylestradiol,Impurity3KetoDesogestrel,ImpurityEpiDesogestrel,TotalImpuritiesDesogestrel,WeightVariationRSD,DisintegrationTime,DissolutionEthinylestradiol,DissolutionDesogestrel,HeavyMetals,TAMC,TYMC,EColiDetected,SalmonellaDetected,EthanolPPM,AcetonePPM,Friability
Example (EColiDetected/SalmonellaDetected: 0=not detected, 1=detected):
EEDG-2026-001,98.5,99.2,0.3,0.2,0.1,0.4,3.5,15.0,85.0,87.0,10,500,50,0,0,800,500,0.6
— WHY IS THIS NEEDED?
Combined tablets (ethinylestradiol + desogestrel) — highly effective third-generation COCs for:
• Contraception (Novinet, Mercilon, Jeanine)
• Acne and seborrhea treatment in women
• Menstrual cycle regulation
⚠️ CRITICAL:
• Dissolution of both components ≥80% — ensures bioavailability and contraceptive efficacy
• EE impurity (17-epimer) ≤0.5% — affects estrogenic activity
• 3-Keto-desogestrel ≤0.5% — oxidation product, reduces progestogenic activity
• Epi-desogestrel ≤0.5% — stereoisomer, affects pharmacokinetics
• Total desogestrel impurities ≤1.0% — critical for safety (thrombosis risk)
• Absence of pathogens (E. coli, Salmonella) — mandatory for oral preparations
Critical parameters:
• EE content: 90.0–110.0% of declared
• Desogestrel content: 90.0–110.0% of declared
• EE impurity (17-epimer): ≤0.5%
• 3-Keto-desogestrel: ≤0.5%
• Epi-desogestrel: ≤0.5%
• Total desogestrel impurities: ≤1.0%
• Weight variation (RSD): ≤5.0%
• Disintegration: ≤30 minutes
• EE dissolution: ≥80% (at 30 min)
• Desogestrel dissolution: ≥80% (at 30 min)
• Heavy metals: ≤20 ppm
• Microbiology: TAMC ≤1000 CFU/g, TYMC ≤100 CFU/g
• Absence of E. coli and Salmonella
• Friability: ≤1.0% (for uncoated tablets)
• Residual solvents: ethanol ≤5000 ppm, acetone ≤5000 ppm
⚠️ Note: Desogestrel is oxidation-sensitive! 3-Keto impurity control is critical for stability and safety. Dissolution is tested separately for each component (different HPLC methods).
input.csv
BatchNumber,EthinylestradiolContent,DesogestrelContent,ImpurityEthinylestradiol,Impurity3KetoDesogestrel,ImpurityEpiDesogestrel,TotalImpuritiesDesogestrel,WeightVariationRSD,DisintegrationTime,DissolutionEthinylestradiol,DissolutionDesogestrel,HeavyMetals,TAMC,TYMC,EColiDetected,SalmonellaDetected,EthanolPPM,AcetonePPM,Friability EEDG-2026-001,98.5,99.2,0.3,0.2,0.1,0.4,3.5,15.0,85.0,87.0,10,500,50,0,0,800,500,0.6
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 Ethinylestradiol Desogestrel Quality Checker utility is used for Ethinylestradiol Desogestrel. 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: Contraceptives
Tags: assay, contraceptives, dissolution, fixed-dose combinations, heavy metals, hormones, impurities, microbiology, radiopharma, residual solvents, solid dosage
2. Execution modes
EthinylestradiolDesogestrelQualityChecker.exe → demo mode (console output) EthinylestradiolDesogestrelQualityChecker.exe input.csv output.json → evaluate your 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 for COC production (Novinet, Mercilon). Strict desogestrel impurity control is mandatory due to impact on progestogenic activity and safety!
- ⚠️ CRITICAL:
- Dissolution of both components ≥80% — ensures bioavailability and contraceptive efficacy
- EE impurity (17-epimer) ≤0.5% — affects estrogenic activity
- 3-Keto-desogestrel ≤0.5% — oxidation product, reduces progestogenic activity
- Epi-desogestrel ≤0.5% — stereoisomer, affects pharmacokinetics
- Total desogestrel impurities ≤1.0% — critical for safety (thrombosis risk)
- Absence of pathogens (E. coli, Salmonella) — mandatory for oral preparations
- Critical parameters:
- EE content: 90.0–110.0% of declared
- Desogestrel content: 90.0–110.0% of declared
- EE impurity (17-epimer): ≤0.5%
- 3-Keto-desogestrel: ≤0.5%
- Epi-desogestrel: ≤0.5%
- Total desogestrel impurities: ≤1.0%
- Weight variation (RSD): ≤5.0%
- Disintegration: ≤30 minutes
- EE dissolution: ≥80% (at 30 min)
- Desogestrel dissolution: ≥80% (at 30 min)
- Heavy metals: ≤20 ppm
- Microbiology: TAMC ≤1000 CFU/g, TYMC ≤100 CFU/g
- Absence of E. coli and Salmonella
- Friability: ≤1.0% (for uncoated tablets)
- Residual solvents: ethanol ≤5000 ppm, acetone ≤5000 ppm
5. URS — user requirements
| ID | Requirement | Criticality | Acceptance criterion |
|---|---|---|---|
| URS-001 | The system shall accept an input.csv file for Ethinylestradiol Desogestrel 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 | EEDG-2026-001 | mandatory field; used for batch/lot traceability |
| 2 | EthinylestradiolContent | decimal | as specified | Ethinylestradiol Content | 98.5 | numeric value; compared with assay/purity limit from specification or method |
| 3 | DesogestrelContent | decimal | as specified | Desogestrel Content | 99.2 | numeric value; compared with assay/purity limit from specification or method |
| 4 | ImpurityEthinylestradiol | decimal | as specified | Impurity Ethinylestradiol | 0.3 | numeric value; compared with individual or total impurity limit |
| 5 | Impurity3KetoDesogestrel | decimal | as specified | Impurity3 Keto Desogestrel | 0.2 | numeric value; compared with individual or total impurity limit |
| 6 | ImpurityEpiDesogestrel | decimal | as specified | Impurity Epi Desogestrel | 0.1 | numeric value; compared with individual or total impurity limit |
| 7 | TotalImpuritiesDesogestrel | decimal | as specified | Total Impurities Desogestrel | 0.4 | mandatory numeric value; rule comparison is performed by the utility |
| 8 | WeightVariationRSD | decimal | as specified | Weight Variation RSD | 3.5 | mandatory numeric value; rule comparison is performed by the utility |
| 9 | DisintegrationTime | decimal | min | Disintegration Time | 15.0 | numeric value; dissolution/disintegration profile checked according to method |
| 10 | DissolutionEthinylestradiol | decimal | as specified | Dissolution Ethinylestradiol | 85.0 | numeric value; dissolution/disintegration profile checked according to method |
| 11 | DissolutionDesogestrel | decimal | as specified | Dissolution Desogestrel | 87.0 | numeric value; dissolution/disintegration profile checked according to method |
| 12 | HeavyMetals | decimal | as specified | Heavy Metals | 10 | numeric value; checked as elemental/metal impurity |
| 13 | TAMC | decimal | as specified | TAMC | 500 | numeric value; compared with microbiological limits |
| 14 | TYMC | decimal | as specified | TYMC | 50 | numeric value; compared with microbiological limits |
| 15 | EColiDetected | boolean / flag | 0/1 | EColi Detected | 0 | valid flag required; prohibited organisms and growth are normally expected as 0 / absent |
| 16 | SalmonellaDetected | boolean / flag | 0/1 | Salmonella Detected | 0 | valid flag required; prohibited organisms and growth are normally expected as 0 / absent |
| 17 | EthanolPPM | decimal | ppm | Ethanol PPM | 800 | numeric value; checked as residual solvent against the applicable limit |
| 18 | AcetonePPM | decimal | ppm | Acetone PPM | 500 | numeric value; checked as residual solvent against the applicable limit |
| 19 | Friability | decimal | as specified | Friability | 0.6 | mandatory numeric value; rule comparison is performed by the utility |
CSV example
BatchNumber,EthinylestradiolContent,DesogestrelContent,ImpurityEthinylestradiol,Impurity3KetoDesogestrel,ImpurityEpiDesogestrel,TotalImpuritiesDesogestrel,WeightVariationRSD,DisintegrationTime,DissolutionEthinylestradiol,DissolutionDesogestrel,HeavyMetals,TAMC,TYMC,EColiDetected,SalmonellaDetected,EthanolPPM,AcetonePPM,Friability EEDG-2026-001,98.5,99.2,0.3,0.2,0.1,0.4,3.5,15.0,85.0,87.0,10,500,50,0,0,800,500,0.6
7. FS — functional specification
| ID | Function | Implementation description |
|---|---|---|
| FS-001 | CLI entry point | The executable EthinylestradiolDesogestrelQualityChecker.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 Ethinylestradiol Desogestrel, 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": "EthinylestradiolDesogestrelQualityChecker",
"api": "Ethinylestradiol Desogestrel",
"batchNumber": "EEDG-2026-001",
"overallStatus": "PASS|WARNING|FAIL",
"checkedAtUtc": "2026-05-18T00:00:00Z",
"checks": [
{
"parameter": "BatchNumber",
"value": "EEDG-2026-001",
"unit": "as specified",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "EthinylestradiolContent",
"value": "98.5",
"unit": "as specified",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "DesogestrelContent",
"value": "99.2",
"unit": "as specified",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "ImpurityEthinylestradiol",
"value": "0.3",
"unit": "as specified",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "Impurity3KetoDesogestrel",
"value": "0.2",
"unit": "as specified",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "ImpurityEpiDesogestrel",
"value": "0.1",
"unit": "as specified",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "TotalImpuritiesDesogestrel",
"value": "0.4",
"unit": "as specified",
"status": "PASS|WARNING|FAIL",
"message": "Rule-based check result"
},
{
"parameter": "WeightVariationRSD",
"value": "3.5",
"unit": "as specified",
"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.
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.
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.
OpenContraceptives QC Suite
Quality-control package for contraceptives: hormonal APIs, fixed combinations, implants, rings and intrauterine systems.
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.
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.
OpenEndocrinology QC Suite
QC package for endocrinology: thyroid, pituitary/peptide hormones, corticosteroids, sex hormones and selected metabolic medicines.
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.
OpenGynecology QC Suite
QC package for gynecology: hormones, contraceptives, uterotonics, anti-infectives and women’s-health medicines.
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.
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.
OpenRadiology QC Suite
QC package for radiology and diagnostic imaging: radiopharmaceuticals, PET/SPECT, contrast media, iodinated and gadolinium products, plus particle, sterility and endotoxin checks.
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.
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.
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.
Open