EUVIMEDEUVIMED felfedezése
Open access · CC BY 4.0

Statistical Anomaly Detection Approach for Field Mapping Validation in Enterprise Payroll Data Migration

Hao Cao, Wangwang Shi

Journal of Computing Innovations and Applications · 2026

DOI: 10.63575//cia.2026.40112 ↗

At a glance

Journal article in Journal of Computing Innovations and Applications, 2026. Written by Hao Cao and 1 co-authors. Cited 1 times so far (Crossref). The full text is freely available (open access, CC BY 4.0).

AbsztraktBibliográfiai adatokCiteRelated studies

Abstract (original language)

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.

Cite

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}
}
Start for free →