Audit-traceable harmonization of legacy calibration certificates for ISO/IEC 17025 laboratory quality assurance
Аннотация
Legacy calibration certificates can support longitudinal equipment surveillance only after unit, structure, identity and provenance differences have been controlled. This study developed an audit-traceable row-level harmonization framework using records from the accredited BUSKI Drinking Water Laboratory branch and assessed retrospective applicability of the core framework in the accredited Wastewater Laboratory branch; both branches are listed under the same TÜRKAK accreditation file AB-0739-T. The longitudinal development cohort comprised 108 certificates for 11 devices and 517 result rows covering the years from 2016 to 2025. Source-certificate, initially extracted and harmonized values were retained separately; unit state, an archived row-level evidence-processing class and a separate indicator-use status were assigned before device-class-specific indicators were calculated. Harmonization changed the interpreted surveillance signal in the representative cases reported here. In one worked case, an unconverted relative-percentage calculation yielded 12.667, whereas the valid converted random-error tolerance occupancy ratio was 0.0633, a 200-fold difference based on unrounded values; these rows are retained as a restricted-use data-quality demonstration and not as stand-alone surveillance evidence. Mixed mL/µL records masked consecutive near-limit burette observations, and retrospective setpoint-row misalignment generated an apparent +32.515 °C chamber bias that became +0.015 °C after source-record realignment. The separate 2026 wastewater cohort contained 55 certificates. The established unit-state, evidence-processing and device-class indicator structures were applicable without a new core category, although certificate-specific extraction corrections and operational flags remained necessary. The results support within-organization cross-branch applicability, not independent external validation or universal transferability.