Migration & Data Quality Reconciliation
Syntamatic HR Sample AuditedLegacy 122-column employee dump mapping matrix, field transformation logic, deterministic date normalizations, and anomaly reconciliation.
Legacy 122-Column Sample Mapping Matrix
Classification of legacy employee dump columns into canonical HRCS data entities
The legacy client employee dump contained 122 columns across 26 populated sample records. The matrix below exhibits the canonical target mapping status, deterministic transformation logic, anomaly handling, and unmapped residue.
Legacy Data Quality Anomaly Handling Rules
Automated cleanup filters applied during legacy dataset ingestion
Treated as null / unassigned instead of valid birth, confirmation, or probation dates.
Consolidated multiple designation and title variations into single canonical Person Master and Job Architecture Assignment fields.
Auto-routed to default entity cost center (e.g. CC-SAMI-PHARMA) with an audit warning flag for finance signoff.
Normalized via deterministic date parser to ISO standard YYYY-MM-DD format, preventing timezone drift.
Resolved through canonical Grade hierarchy M1–M9, E1–E6, W1–W4 mapping rules defined in Job Architecture.