Issue

Course Attendance Audit (CAR) contains the following error

• Start Date does not match DAY date of 

Environment

• Schools using a Master Schedule

Cause

• Course Attendance Start 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 Start Date

Example

• CAR Section (CAR.SE) = 368
• CAR Start Date (CAR.DS) = 08/07/2024
• CAR Start Day Number (CAR.D1) = 3     
  • 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) Start Date

• LIST DAY   

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

• LIST CAR SE D1 IF SE = 368 AND DS = 08/07/2024
  • The number of results in this query should match the number of proposed results in the next query
• CHANGE CAR D1 TO 3 IF SE = 368 AND DS = 08/07/2024 
  • The number of proposed changes in this query should match the number of results in the former query