Validation & Errors

EMIS Data Quality Center

Identify, understand, and resolve data quality problems before import

Business Rules

Logical checks that catch data which is filled in but doesn't add up correctly

Invalid Month

month_num must be between 1 and 12

Negative Value

Numeric fields (enrollment, counts, leaves) cannot be below zero

Gender Mismatch

male + female must equal total

๐ŸŸก Import with Warnings

No critical errors, but warnings were detected. You may proceed, but review the warnings before importing.

Remove 3 duplicate record(s).

Correct 9 business rule violation(s).

0%

Poor

Total Records

3,651

Passed

789

Warnings

5131

Critical

0

Duplicates

3

Quality Score

0%

Issues by Severity
medium: 5131
  • medium
Issues by Category
FileStructureHeaderRequiredDataDuplicateSchoolClusterBusinessCross0750150022503000
  • Errors
  • Warnings
Detailed Issues (62 groups)
ExpectedSuggested FixStatusActions
medium
C โ€“ Teacher LeavesUnknown SchoolGovt.PS BeisilschoolKnown schoolVerify spelling against the canonical school list.unresolved
medium
C โ€“ Teacher LeavesUnknown SchoolGovt MS SeiskoschoolKnown schoolVerify spelling against the canonical school list.unresolved
medium
F โ€“ Events & ActivitiesUnknown SchoolGovt.Girls High School TissarschoolKnown schoolVerify spelling against the canonical school list.unresolved
medium
F โ€“ Events & ActivitiesUnknown ClusterGovt.Girls High School TissarclusterKnown clusterCheck the cluster name or update the mapping.unresolved
medium
C โ€“ Teacher LeavesUnknown SchoolGovt MS SultababadschoolKnown schoolVerify spelling against the canonical school list.unresolved
medium
G โ€“ VisitorsUnknown SchoolGovt.Boys Middle School Arindo BashaschoolKnown schoolVerify spelling against the canonical school list.unresolved
medium
C โ€“ Teacher LeavesUnknown SchoolKhari MachuloschoolKnown schoolVerify spelling against the canonical school list.unresolved
medium
C โ€“ Teacher LeavesUnknown SchoolGovt PS KarabathangschoolKnown schoolVerify spelling against the canonical school list.unresolved
medium
C โ€“ Teacher LeavesUnknown SchoolSAP School HusheschoolKnown schoolVerify spelling against the canonical school list.unresolved
medium
C โ€“ Teacher LeavesUnknown SchoolGovt. PS ArindoschoolKnown schoolVerify spelling against the canonical school list.unresolved

Page 1 of 7

Duplicate Detection (3)
Smart Suggestions
Validation Timeline
Resolution History (0)

No issues resolved yet.

Export Reports