How to determine if the "Student has Overlapping Courses in CAR" error message on the Course Attendance Audit Listing report is caused by custom bell schedules applied to dates in the Calendar (DAY table)

1. In a TEST COPY of the database, remove the custom bell schedules from the calendar:

SQL Query

UPDATE DAY SET BS = '0' WHERE SC = XXX

CHANGE DAY BS TO " " IF SC = xxx

2. Run the Course Audit Attendance Listing

• If the "Student has Overlapping Courses in CAR" error message no longer appears, the custom bell schedules are causing the conflict