Issue

Course Attendance Audit (CAR) contains the following error

• Stop Date does not match DAY date of 

Environment

• Schools using a Master Schedule

Cause

• Course Attendance Stop Dates were updated via CHANGE Query but the Day Numbers were not updated (which must also be done by a separate CHANGE Query)

Resolution

• Query change the Day Number to match the Course Attendance Stop Date

Example

• CAR End Date (CAR.DE) = 06/04/2025
• CAR End Day Number (CAR.D2) = 195  
  • found by querying the Calendar in Step 1

1. Run the query below to determine what Calendar Day Number correlates to the Course Attendance (CAR) End Date

• LIST DAY   

2.    Run the Query set below to change the CAR End Day Number for ALL students in Section 368 whose Course Attendance End Date is 06/04/2024

• LIST CAR SE D2 IF SE = 368 AND DE = 06/04/2024
  • The number of results in this query should match the number of proposed results in the next query
• CHANGE CAR D2 TO 195 IF SE = 368 AND DE = 06/04/2024 
  • The number of proposed changes in this query should match the number of results in the former query