Timetable Pre-Publication Audit

Source file: timetable_seed.csv. This report only reflects provided data and enabled deterministic rules.

Blocker: 9
High: 0
Medium: 3
Needs Review: 0

Scope

This audit checks de-identified timetable rows for deterministic conflicts and data-quality issues. Enabled rule groups cover teacher overlaps, class/student-group overlaps, room overlaps, duplicate lessons, invalid dates or times, missing required fields, and unusual lesson duration.

Management Summary

Do not publish yet under the enabled rules. The audit found 9 blocker issue(s) that should be reviewed before release.

Findings

Issue Severity Rule Resource Date Time Rows Evidence Suggested action Status
T-001BlockerCLASS_OVERLAPclass: C-7A2026-08-3109:00-09:452;10Class C-7A has overlapping lessons for 45 minutes.Move one lesson, change the resource, or mark one row out of publication scope.Open
T-002BlockerCLASS_OVERLAPclass: C-7A2026-08-3109:30-09:454;10Class C-7A has overlapping lessons for 15 minutes.Move one lesson, change the resource, or mark one row out of publication scope.Open
T-003BlockerINVALID_DATEfield: date2026/08/3111Date '2026/08/31' is not parseable as YYYY-MM-DD.Use ISO date format, for example 2026-08-31.Open
T-004BlockerINVALID_TIME_RANGElesson: L-0052026-08-3111:00-10:306End time is not after start time.Correct the start/end times or remove the row from the publishable timetable.Open
T-005BlockerMISSING_REQUIRED_FIELDfield: teacher_id2026-08-3111:00-11:457Required field 'teacher_id' is empty.Provide a de-identified value for 'teacher_id' or mark the row out of scope.Open
T-006BlockerROOM_OVERLAProom: R-1012026-08-3109:00-09:452;10Room R-101 has overlapping lessons for 45 minutes.Move one lesson, change the resource, or mark one row out of publication scope.Open
T-007BlockerROOM_OVERLAProom: R-1022026-08-3110:00-10:153;5Room R-102 has overlapping lessons for 15 minutes.Move one lesson, change the resource, or mark one row out of publication scope.Open
T-008BlockerTEACHER_OVERLAPteacher: T-0142026-08-3109:00-09:452;10Teacher T-014 has overlapping lessons for 45 minutes.Move one lesson, change the resource, or mark one row out of publication scope.Open
T-009BlockerTEACHER_OVERLAPteacher: T-0142026-08-3109:30-09:453;10Teacher T-014 has overlapping lessons for 15 minutes.Move one lesson, change the resource, or mark one row out of publication scope.Open
T-010MediumDUPLICATE_LESSONlesson: L-0012026-08-3109:00-09:452;10Multiple rows have the same date, time, teacher, class, room, subject, and week pattern.Confirm whether this is an intentional duplicate; otherwise remove one row.Open
T-011MediumUNUSUAL_DURATIONlesson: L-0072026-08-3112:00-12:108Lesson duration is 10 minutes; configured normal range is 20-180 minutes.Confirm the duration threshold with the school or correct the time range.Open
T-012MediumUNUSUAL_DURATIONlesson: L-0082026-08-3113:00-16:309Lesson duration is 210 minutes; configured normal range is 20-180 minutes.Confirm the duration threshold with the school or correct the time range.Open

Limits

This is not a guarantee that the timetable is conflict-free. School-specific rules not represented in the input or configured rule set are outside this run. Final publication decisions remain with the school.

Re-Check Note

After fixes are made, submit a revised de-identified file for one difference re-check. The re-check should compare whether listed issues are resolved, still open, newly introduced, or not verifiable from the revised data.