Statistical Anomaly Detection Approach for Field Mapping Validation in Enterprise Payroll Data Migration
Journal of Computing Innovations and Applications · 2026
DOI: 10.63575//cia.2026.40112 ↗Kurz gefasst
Fachartikel in der Zeitschrift Journal of Computing Innovations and Applications, 2026. Verfasst von Hao Cao und 1 weiteren Autor:innen. Die Arbeit wurde bisher 1-mal zitiert (Crossref). Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
Enterprise payroll system migrations from legacy platforms to modern cloud-based solutions present significant data quality challenges, particularly in field mapping validation. This research proposes a statistical anomaly detection framework specifically designed for automated validation of field mappings during Oracle Cloud Payroll to SAP SuccessFactors migrations. The framework employs distribution-based analysis techniques including Kolmogorov-Smirnov tests, Chi-square tests, and multi-threshold outlier detection mechanisms to identify systematic mapping errors, data type inconsistencies, and business rule violations. Experimental validation using a dataset of 50,000 employee records across 120 fields demonstrates that the proposed approach achieves 95.3% detection accuracy while reducing manual validation time by 42%. The framework successfully identified critical anomalies including decimal precision loss in salary calculations, date format inconsistencies in employment records, and null value propagation in benefit deductions. These results establish statistical anomaly detection as a viable automated quality assurance mechanism for enterprise payroll data migrations, offering substantial improvements over traditional rule-based validation methods.
Zitieren
APA
Cao, H., & Shi, W. (2026). Statistical Anomaly Detection Approach for Field Mapping Validation in Enterprise Payroll Data Migration. Journal of Computing Innovations and Applications. https://doi.org/10.63575//cia.2026.40112
Vancouver
Cao H, Shi W. Statistical Anomaly Detection Approach for Field Mapping Validation in Enterprise Payroll Data Migration. Journal of Computing Innovations and Applications. 2026. doi:10.63575//cia.2026.40112
BibTeX
@article{Cao2026,
author = {Cao, Hao and Shi, Wangwang},
title = {Statistical Anomaly Detection Approach for Field Mapping Validation in Enterprise Payroll Data Migration},
journal = {Journal of Computing Innovations and Applications},
year = {2026},
doi = {10.63575//cia.2026.40112}
}
EUVIMED