Roster cleanup and import validation

Go-live fails on dirty roster

Parent portal invites bounce when email typos litter imports. Fee invoices duplicate when two student IDs refer to same child. Data quality tools surface fixes while migration team still on site - not month three when defaulter calls wrong number.

Import validation pipeline

CSV upload runs schema checks - required fields, date formats, class codes that exist. Row-level errors downloadable for fix-and-reupload. Preview mode shows first fifty transformed records before commit.

• Guardian mobile format normalization
• Unknown class or section rejection
• Duplicate admission number block
• Optional dry-run counter statistics

Duplicate detection heuristics

Fuzzy match on name + DOB + guardian phone suggests merge candidates. Registrar reviews side-by-side - keep richer record, retire duplicate - with merge audit for accreditation.

Guardian hygiene

Same parent spelled three ways breaks sibling discount. Household report groups unlinked siblings sharing phone. Bulk link wizard after admissions peak.

Ongoing quality not one-time

Scheduled reports flag students without class assignment, fees without plan, active staff without role. Weekly email to registrar inbox during first term.

Integration cutover

Parallel run week compares headcount and fee totals legacy vs Schoolyi. Discrepancy threshold must hit zero before legacy switch-off sign-off.

Roles and permissions check

Quality dashboard includes users with excessive admin rights or dormant accounts - security hygiene paired with data hygiene before audit season.