PancreatinQualityChecker

1. Scope

The Pancreatin Quality Checker utility is used for Pancreatin. 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

Tags: API, assay, biologics, biosimilars, fixed-dose combinations, generics, heavy metals, market map, microbiology, water quality

2. Execution modes

PancreatinQualityChecker.exe                            → demo mode
PancreatinQualityChecker.exe input.csv output.json      → evaluate data

3. Key controlled areas

• assay / content
• microbiology and pathogens
• heavy metals / elemental impurities
• pH and physicochemical parameters
• activity, decay and radiochemical purity

5. URS — user requirements

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.

CSV example

BatchNumber,Lipase_Activity_USP_Units_per_g,Amylase_Activity_USP_Units_per_g,Protease_Activity_USP_Units_per_g,Lipase_to_Protease_Ratio,Loss_On_Drying_Percent,pH_Value,Heavy_Metals_ppm,Lead_ppm,Arsenic_ppm,Total_Aerobic_Microbial_Count,Total_Yeast_Mold_Count,EColi_Detected,Salmonella_Detected,Enterobacteria_Count
PAN-ENZ-2026-001,100.0,98.0,95.0,20.0,4.5,6.5,8,2,1,5000,500,0,0,1000

7. FS — functional specification

8. output.json contract

The output file must be suitable for automated processing, audit review and correlation with the source input.csv row.

{
  "utility": "PancreatinQualityChecker",
  "api": "Pancreatin",
  "batchNumber": "PAN-ENZ-2026-001",
  "overallStatus": "PASS|WARNING|FAIL",
  "checkedAtUtc": "2026-05-18T00:00:00Z",
  "checks": [
    {
      "parameter": "BatchNumber",
      "value": "PAN-ENZ-2026-001",
      "unit": "as specified",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result"
    },
    {
      "parameter": "Lipase_Activity_USP_Units_per_g",
      "value": "100.0",
      "unit": "as specified",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result"
    },
    {
      "parameter": "Amylase_Activity_USP_Units_per_g",
      "value": "98.0",
      "unit": "as specified",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result"
    },
    {
      "parameter": "Protease_Activity_USP_Units_per_g",
      "value": "95.0",
      "unit": "as specified",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result"
    },
    {
      "parameter": "Lipase_to_Protease_Ratio",
      "value": "20.0",
      "unit": "as specified",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result"
    },
    {
      "parameter": "Loss_On_Drying_Percent",
      "value": "4.5",
      "unit": "%",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result"
    },
    {
      "parameter": "pH_Value",
      "value": "6.5",
      "unit": "pH",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result"
    },
    {
      "parameter": "Heavy_Metals_ppm",
      "value": "8",
      "unit": "ppm",
      "status": "PASS|WARNING|FAIL",
      "message": "Rule-based check result"
    }
  ],
  "criticalFindings": [],
  "sourceFile": "input.csv"
}

9. OQ/PQ test scenarios

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.