mirror of
https://github.com/hanzoskill/data-reconciliation-exceptions.git
synced 2026-10-30 21:10:50 +00:00
413 B
413 B
Matching Rules (priority order)
Primary key (best):
- Pay Number (exact match after trimming spaces)
Secondary keys (only if Pay Number missing/invalid): 2) Driver Card number 3) Driving Licence number 4) Driver Qualification Card number
Name handling (supporting check, not primary join):
- Normalize: trim, collapse spaces, uppercase
- Flag as mismatch if name differs after normalization but key matches