InfraLUM_ID_Ciprofloxacin

InfraLUM ID Ciprofloxacin

Lumex QC URS & FS input.csv output.json rule-based LIMS-ready InfraLUM

Utility description: InfraLUM ID Ciprofloxacin

InfraLUM ID Ciprofloxacin — Ciprofloxacin Identification by IR Spectroscopy

ℹ️  Utility checks IR spectrum compliance with reference (Ph. Eur. / Russian Pharmacopoeia) for ACID FORM:
    • Correlation coefficient with reference spectrum: ≥0.995
    • Peak 3050 cm⁻¹ (aromatic C-H stretching): ±15 cm⁻¹
    • Peak 1715 cm⁻¹ (COOH carbonyl): ±10 cm⁻¹ — ACID FORM MARKER
    • Peak 1620 cm⁻¹ (quinolone C=O + C=C): ±10 cm⁻¹
    • Peak 1500 cm⁻¹ (aromatic C=C skeletal): ±10 cm⁻¹
    • Peak 1270 cm⁻¹ (C-F stretching): ±10 cm⁻¹ — FLUOROQUINOLONE MARKER
    • Baseline noise: ≤0.005 Abs

⚠️  IMPORTANT: This utility is designed exclusively for CIPROFLOXACIN ACID FORM.
    Ciprofloxacin hydrochloride has a significantly different IR spectrum:
    • Peak 1715 cm⁻¹ (COOH) is absent or significantly shifted (carboxylate ~1580 cm⁻¹).
    • Broad NH₂⁺/NH⁺ bands appear in the 2400–3000 cm⁻¹ region.
    Using the acid form reference for hydrochloride will result in false FAIL!

Usage:
  InfraLUM_ID_Ciprofloxacin.exe                            → demo mode (console output)
  InfraLUM_ID_Ciprofloxacin.exe input.csv output.json      → evaluate your data

Input format:
BatchNumber,CorrelationCoefficient,Peak3050_cm1,Peak1715_cm1,Peak1620_cm1,Peak1500_cm1,Peak1270_cm1,BaselineNoiseAbs,PreparationMethod

Example (PreparationMethod: KBr / ATR / Nujol):
  CIP-ID-2026-091,0.9992,3048.0,1716.0,1618.0,1502.0,1268.0,0.0016,KBr

— WHY IS THIS NEEDED?
Ciprofloxacin is a 2nd-generation fluoroquinolone, broad-spectrum antimicrobial agent.
• Structure contains quinolone core, carboxyl group, fluorine, piperazine ring, and cyclopropyl substituent.
• Fluorine at C-6 is the key structural element defining fluoroquinolone class membership.
• Carboxyl group at C-3 is essential for binding to bacterial DNA gyrase.
• Reference spectrum established in Ph. Eur. Ciprofloxacin and Russian Pharmacopoeia FS.2.4.00186.18.
• InfraLUM FT-08/FT-10 instruments are widely used in Russian QC laboratories.

⚠️  CRITICAL:
• Correlation ≥0.995 — strict matching criterion with reference.
• Peak 1715 cm⁻¹ (COOH C=O) — confirms acid form of the substance.
  Absence of this peak with other peaks present indicates salt form.
• Peak 1270 cm⁻¹ (C-F) — specific fluoroquinolone marker.
  Absence of C-F peak may indicate nalidixic acid (non-fluorinated quinolone).
• Peak 1620 cm⁻¹ (quinolone C=O) — sensitive to metal chelation.
  Shift of this peak may indicate complexation with Fe³⁺, Al³⁺, Ca²⁺.
• Noise >0.005 Abs renders spectrum unsuitable for identification.

Key features:
• Uses NAMED TUPLE (record struct EvalResult) —
  eliminates positional field access errors.
• Specification based on Ph. Eur. Ciprofloxacin and Russian Pharmacopoeia FS.2.4.00186.18.
• Control of five characteristic peaks + correlation + spectrum quality.
• Differentiation of acid and salt forms via 1715 cm⁻¹ peak.
• Full LabWare LIMS compatibility.

Critical parameters:
• Correlation Coefficient: ≥0.995
• Peak 3050 cm⁻¹ (arom. C-H): 3050 ± 15 cm⁻¹
• Peak 1715 cm⁻¹ (COOH C=O): 1715 ± 10 cm⁻¹
• Peak 1620 cm⁻¹ (quinolone C=O/C=C): 1620 ± 10 cm⁻¹
• Peak 1500 cm⁻¹ (arom. C=C): 1500 ± 10 cm⁻¹
• Peak 1270 cm⁻¹ (C-F stretch): 1270 ± 10 cm⁻¹
• Baseline Noise: ≤0.005 Abs

💡 Usage tips:
1. KBr tablets must be dry — pre-dry at 120°C before use.
2. Sample concentration in KBr: 0.5–1.0% (w/w).
3. Record spectrum in 4000–400 cm⁻¹ range, 4 cm⁻¹ resolution, 32 scans.
4. Record background spectrum of pure KBr before each measurement.
5. For ATR method, ensure tight crystal-sample contact.
6. Reference spectrum should be obtained on the same instrument under identical conditions.
7. Ciprofloxacin is photosensitive — prepare sample under diffused light.

⚠️ Note: Ciprofloxacin is an amphoteric compound (carboxyl group + piperazine).
    Depending on pH and dosage form (tablets, infusion solution, eye drops),
    the substance may exist as zwitterion, cation, or anion.
    Each form has a unique IR spectrum. Always verify the substance form in the CoA
    against the reference spectrum form before analysis.
    Piperazine ring gives characteristic peaks in the 2800–2950 cm⁻¹ region (N-CH₂),
    serving as additional confirmatory markers.

input.csv

BatchNumber,CorrelationCoefficient,Peak3050_cm1,Peak1715_cm1,Peak1620_cm1,Peak1500_cm1,Peak1270_cm1,BaselineNoiseAbs,PreparationMethod
CIP-ID-2026-091,0.9992,3048.0,1716.0,1618.0,1502.0,1268.0,0.0016,KBr
CIP-ID-2026-092,0.9935,3062.0,1705.0,1632.0,1488.0,1285.0,0.006,KBr

URS & FS — User Requirements and Functional Specification

This document defines the controlled interface, validation behaviour and expected output of InfraLUM_ID_Ciprofloxacin. The document is intended to reside inside the utility folder together with input.csv and the description file. Expected executable: InfraLUM_ID_Ciprofloxacin.exe.

Purpose: the utility performs deterministic verification of QC input data against approved limits, generates machine-readable output.json, and supports QC/QA review, LIMS/ELN/MES integration and CSV/CSA preparation.

Scope

Utility class	IR spectroscopy / InfraLUM
Main object/method	Ciprofloxacin Identification by IR Spectroscopy
Input	`input.csv` with a fixed header and controlled data types.
Output	`output.json` with `PASS`, `WARNING`, `FAIL` statuses, detailed checks and critical findings.
Exclusions	The utility does not replace the approved specification, analytical procedure, OOS/OOT investigation or Qualified Person / QA release decision.

Domain limits and critical parameters

Key fragments from the source description are listed below. Before production use, limits shall be verified against the approved specification, registration dossier, current pharmacopoeial edition and local SOPs.

• Correlation coefficient with reference spectrum: ≥0.995
• Peak 3050 cm⁻¹ (aromatic C-H stretching): ±15 cm⁻¹
• Peak 1715 cm⁻¹ (COOH carbonyl): ±10 cm⁻¹ — ACID FORM MARKER
• Peak 1620 cm⁻¹ (quinolone C=O + C=C): ±10 cm⁻¹
• Peak 1500 cm⁻¹ (aromatic C=C skeletal): ±10 cm⁻¹
• Peak 1270 cm⁻¹ (C-F stretching): ±10 cm⁻¹ — FLUOROQUINOLONE MARKER
• Baseline noise: ≤0.005 Abs
⚠️ IMPORTANT: This utility is designed exclusively for CIPROFLOXACIN ACID FORM.
• Peak 1715 cm⁻¹ (COOH) is absent or significantly shifted (carboxylate ~1580 cm⁻¹).
• Broad NH₂⁺/NH⁺ bands appear in the 2400–3000 cm⁻¹ region.
InfraLUM_ID_Ciprofloxacin.exe input.csv output.json → evaluate your data
BatchNumber,CorrelationCoefficient,Peak3050_cm1,Peak1715_cm1,Peak1620_cm1,Peak1500_cm1,Peak1270_cm1,BaselineNoiseAbs,PreparationMethod
• Structure contains quinolone core, carboxyl group, fluorine, piperazine ring, and cyclopropyl substituent.
• Fluorine at C-6 is the key structural element defining fluoroquinolone class membership.
• Carboxyl group at C-3 is essential for binding to bacterial DNA gyrase.
• Reference spectrum established in Ph. Eur. Ciprofloxacin and Russian Pharmacopoeia FS.2.4.00186.18.

Pharmacopoeial and regulatory references found in the description

#	Source	Note
1	Ph. Eur	Used as a source/context reference from the description; the current edition must be verified before implementation.
2	Ph. Eur. Ciprofloxacin	Used as a source/context reference from the description; the current edition must be verified before implementation.
3	Ph. Eur. / Russian Pharmacopoeia	Used as a source/context reference from the description; the current edition must be verified before implementation.
4	Ph. Eur. Ciprofloxacin and Russian Pharmacopoeia FS.2.4.00186.18	Used as a source/context reference from the description; the current edition must be verified before implementation.
5	ГФ РФ / Ph. Eur	Used as a source/context reference from the description; the current edition must be verified before implementation.
6	ГФ РФ ФС.2.4.00186.18 и Ph. Eur. Ciprofloxacin	Used as a source/context reference from the description; the current edition must be verified before implementation.

Production data flow

Step	Responsible object	Description	Control
1	LIMS/ELN/MES or QC analyst	Creates `input.csv` with measured values and batch identifier.	Header, mandatory-field and unit checks.
2	InfraLUM_ID_Ciprofloxacin	Loads CSV, converts data types, applies domain rules and produces the result.	Deterministic rules; no ML/probabilistic conformance decision.
3	QC reviewer / QA	Reviews `output.json`, warnings, critical deviations and source values.	Review, deviation investigation and data-trail retention.
4	Archive / eQMS	Retains input, output, utility version, documentation and checksum.	Data integrity: ALCOA+, reproducibility and change control.

URS — User Requirements Specification

ID	Requirement	Criticality	Acceptance criterion
URS-001	The utility shall be supplied with `InfraLUM_ID_Ciprofloxacin.documentation.html` in the same folder as the description and sample `input.csv`.	Medium	The documentation file exists in the `InfraLUM_ID_Ciprofloxacin` folder and opens locally in a browser.
URS-002	The utility shall accept `input.csv` with the exact headers defined in the data contract.	High	A CSV file with the correct header is processed without manual editing.
URS-003	The utility shall validate mandatory fields, column count, data types and basic plausibility of values.	High	Schema and conversion errors are explicitly reported.
URS-004	The utility shall evaluate each critical and non-critical QC parameter against approved limits.	High	Each checked parameter receives a status and explanatory message.
URS-005	The utility shall produce a final record/batch status: `PASS`, `WARNING` or `FAIL`.	High	A critical deviation causes `FAIL`; a non-critical deviation causes `WARNING`.
URS-006	The utility shall generate `output.json` suitable for LIMS/ELN/MES integration and QA/QC review.	High	JSON contains source values, rules, statuses, warnings and critical findings.
URS-007	The utility shall preserve traceability between batch identifier, input values, applied rules and final status.	High	The output contains the batch/row identifier and list of checked parameters.
URS-008	The utility shall not use machine learning or probabilistic interpretation for conformance decisions.	Medium	The result is reproducible and based on explicit rules, thresholds and input values.
URS-009	The utility shall support the CLI scenario: `InfraLUM_ID_Ciprofloxacin.exe input.csv output.json`.	High	With valid arguments, `output.json` is created; on error, a diagnostic message is returned.
URS-010	The documentation shall support IQ/OQ/PQ or equivalent CSV/CSA verification.	Medium	The document contains URS, FS, CSV contract, rules, test scenarios and traceability.
URS-011	The utility shall distinguish data errors, method warnings and critical specification failures.	High	`output.json` provides separate structures/fields for errors, warnings and critical findings.
URS-012	The utility shall support archival retention of unchanged input and output data.	Medium	`input.csv` and `output.json` can be retained as a batch record or OQ/PQ evidence.

input.csv contract

#	Field	Type	Sample	Purpose
1	`BatchNumber`	string	`CIP-ID-2026-091`	Batch or lot identifier used for traceability.
2	`CorrelationCoefficient`	decimal	`0.9992`	Similarity/correlation criterion against a reference profile.
3	`Peak3050_cm1`	decimal	`3048.0`	Spectral peak position or chromatographic/analytical peak attribute.
4	`Peak1715_cm1`	decimal	`1716.0`	Spectral peak position or chromatographic/analytical peak attribute.
5	`Peak1620_cm1`	decimal	`1618.0`	Spectral peak position or chromatographic/analytical peak attribute.
6	`Peak1500_cm1`	decimal	`1502.0`	Spectral peak position or chromatographic/analytical peak attribute.
7	`Peak1270_cm1`	decimal	`1268.0`	Spectral peak position or chromatographic/analytical peak attribute.
8	`BaselineNoiseAbs`	decimal	`0.0016`	Signal quality parameter used to determine analytical suitability.
9	`PreparationMethod`	controlled string	`KBr`	Controlled analytical or sample-preparation method identifier.

BatchNumber,CorrelationCoefficient,Peak3050_cm1,Peak1715_cm1,Peak1620_cm1,Peak1500_cm1,Peak1270_cm1,BaselineNoiseAbs,PreparationMethod
CIP-ID-2026-091,0.9992,3048.0,1716.0,1618.0,1502.0,1268.0,0.0016,KBr
CIP-ID-2026-092,0.9935,3062.0,1705.0,1632.0,1488.0,1285.0,0.006,KBr

Input validation rules

ID	Field	Type	Check	Criticality
VR-001	`BatchNumber`	string	not empty; unique within file where applicable	Medium
VR-002	`CorrelationCoefficient`	decimal	parse as invariant decimal; finite value; no NaN/Infinity; evaluate against approved numerical limit	Medium
VR-003	`Peak3050_cm1`	decimal	parse as invariant decimal; finite value; no NaN/Infinity; evaluate against approved numerical limit	Medium
VR-004	`Peak1715_cm1`	decimal	parse as invariant decimal; finite value; no NaN/Infinity; evaluate against approved numerical limit	Medium
VR-005	`Peak1620_cm1`	decimal	parse as invariant decimal; finite value; no NaN/Infinity; evaluate against approved numerical limit	Medium
VR-006	`Peak1500_cm1`	decimal	parse as invariant decimal; finite value; no NaN/Infinity; evaluate against approved numerical limit	Medium
VR-007	`Peak1270_cm1`	decimal	parse as invariant decimal; finite value; no NaN/Infinity; evaluate against approved numerical limit	Medium
VR-008	`BaselineNoiseAbs`	decimal	parse as invariant decimal; finite value; no NaN/Infinity; evaluate against approved numerical limit	Medium
VR-009	`PreparationMethod`	controlled string	not empty; value belongs to controlled set or is reported as warning	Medium

FS — Functional Specification

ID	Function	Implementation	URS link
FS-001	Local HTML documentation	Provide a bilingual `InfraLUM_ID_Ciprofloxacin.documentation.html` file with RU/EN switch, source description, URS, FS, contracts and tests.	URS-001, URS-010
FS-002	CSV import	Read `input.csv` in UTF-8/CSV-compatible format and identify the header row and data records.	URS-002, URS-009
FS-003	Schema validation	Compare actual columns against the expected contract; missing key fields are recorded as schema errors.	URS-002, URS-003
FS-004	Type conversion	Convert decimal, flag/boolean and controlled string values. Invalid values are recorded at row and field level.	URS-003
FS-005	Domain rule engine	Apply rules for InfraLUM ID Ciprofloxacin, including critical limits from the description and approved specification.	URS-004, URS-008
FS-006	Status aggregation	Aggregate parameter statuses: `FAIL` for critical failure, `WARNING` for non-critical deviation, `PASS` for conformance.	URS-005, URS-011
FS-007	JSON export	Write `output.json` with utility identifier, source values, check results, warnings and critical findings.	URS-006, URS-007
FS-008	Error handling	Separate execution errors, schema errors, conversion errors and domain-limit failures.	URS-003, URS-011
FS-009	Audit support	Keep result structure suitable for review, OOS/OOT investigation, calculation reproduction and inspection discussion.	URS-007, URS-012
FS-010	Integration contract	Support the standard scenario: LIMS/ELN/MES creates `input.csv`, the utility returns `output.json`, and the portal displays description and documentation.	URS-006, URS-009
FS-011	Configuration/change control	Any change to limits, column names or rule logic requires versioning, review, regression tests and documentation update.	URS-010, URS-012
FS-012	Data integrity	Do not modify the source `input.csv`; save results separately in `output.json` for archival retention.	URS-007, URS-012

Example output.json structure

{
  "utilityId": "infralum-id-ciprofloxacin",
  "utilityName": "InfraLUM_ID_Ciprofloxacin",
  "object": "InfraLUM ID Ciprofloxacin",
  "overallStatus": "PASS|WARNING|FAIL",
  "sourceFile": "input.csv",
  "recordCount": 2,
  "checks": [
    {
      "parameter": "BatchNumber",
      "value": "CIP-ID-2026-091",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result",
      "ruleReference": "VR-001"
    },
    {
      "parameter": "CorrelationCoefficient",
      "value": "0.9992",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result",
      "ruleReference": "VR-002"
    },
    {
      "parameter": "Peak3050_cm1",
      "value": "3048.0",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result",
      "ruleReference": "VR-003"
    },
    {
      "parameter": "Peak1715_cm1",
      "value": "1716.0",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result",
      "ruleReference": "VR-004"
    },
    {
      "parameter": "Peak1620_cm1",
      "value": "1618.0",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result",
      "ruleReference": "VR-005"
    },
    {
      "parameter": "Peak1500_cm1",
      "value": "1502.0",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result",
      "ruleReference": "VR-006"
    },
    {
      "parameter": "Peak1270_cm1",
      "value": "1268.0",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result",
      "ruleReference": "VR-007"
    },
    {
      "parameter": "BaselineNoiseAbs",
      "value": "0.0016",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result",
      "ruleReference": "VR-008"
    },
    {
      "parameter": "PreparationMethod",
      "value": "KBr",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result",
      "ruleReference": "VR-009"
    }
  ],
  "criticalFindings": [],
  "warnings": [],
  "metadata": {
    "executionMode": "CLI",
    "interface": "CSV to JSON",
    "documentationFile": "InfraLUM_ID_Ciprofloxacin.documentation.html"
  }
}

Traceability matrix URS → FS → OQ/PQ

URS	FS	Verification	Expected result
URS-001	FS-001	Check that `InfraLUM_ID_Ciprofloxacin.documentation.html` exists in the utility folder.	The file exists, opens, and the RU/EN switch works.
URS-002/003	FS-002/003/004	Run the utility with a correct CSV, a CSV missing a mandatory column and a CSV with an invalid data type.	Correct CSV is processed; schema and type errors are explicit.
URS-004/005	FS-005/006	Submit values within limits, at warning level and beyond a critical limit.	`PASS`, `WARNING` and `FAIL` are produced according to rules.
URS-006/007	FS-007/009/012	Verify `output.json` structure and batch traceability.	JSON contains batch identifier, values, rules, statuses and critical findings.
URS-008	FS-005	Repeat execution with the same `input.csv`.	The result is identical; no probabilistic behaviour is present.
URS-009/010/012	FS-010/011/012	Execute the CLI scenario and archive input/output/version.	Artefacts are suitable for OQ/PQ and change-control records.

OQ/PQ test scenarios

ID	Scenario	Input data	Expected result
OQ-001	Positive path	Sample CSV with valid values.	`output.json` is created; final status is `PASS` or acceptable `WARNING` according to rules.
OQ-002	Mandatory column missing	Remove one key column from the header.	Schema error; the row shall not be treated as passed.
OQ-003	Invalid type	Put text into a numeric field.	Type-conversion error with field and row identification.
OQ-004	Critical limit	Critical parameter value outside the approved limit.	`FAIL` and an entry in `criticalFindings`.
OQ-005	Warning	Non-critical deviation or unknown controlled category.	`WARNING` without hiding the source value.
PQ-001	User real batch	Real `input.csv` from the QC process.	Reviewed result with `input.csv`, `output.json`, version and checksum retained.

QA/QC, CSV/CSA and change control

Do not rename columns without updating the validator, test set and documentation.
Retain input.csv, output.json, executable version, checksum and a copy of the documentation.
Before production use, perform IQ/OQ/PQ or equivalent risk-based CSV/CSA verification.
Critical limits shall be approved by the process owner and verified against the registration dossier, pharmacopoeia and local SOPs.
Any change to rules, thresholds or status interpretation shall go through change control and regression testing.

Included in packages

Lumex QC Suite

A single Lumex package combining the former Lumex and Lumex2 sets: instrumental and general pharmaceutical QC, AAS/ICP, CE, HPLC, NIR/PAT, stability, dissolution, content uniformity, system suitability and statistical control.

Open

Ophthalmology QC Suite

QC package for ophthalmology: eye drops, antiglaucoma agents, antibiotics, sterile solutions, osmolality, pH, particles and preservatives.

Open

Radiology QC Suite

QC package for radiology and diagnostic imaging: radiopharmaceuticals, PET/SPECT, contrast media, iodinated and gadolinium products, plus particle, sterility and endotoxin checks.

Open

Urology QC Suite

QC package for urology: BPH, urolithiasis, overactive bladder, urinary-tract infection medicines and supporting antimicrobial QC checks.

Open