Attendance Audit Listing - Audit Listing P: Student has invalid Day# in Course Attendance - __
Cause: Student has a Course Attendance > Start/End Date that is not a valid date according to the Calendar (DAY) table. This can occur when:
- a CHANGE Query is used to change Course Attendance Start/End Dates (CAR.DS/CAR.DE) but the Course Attendance Start/End Day Numbers (CAR.D1/CAR.D2) are not also updated.
- when an unsupported Calendar change takes place
- when data is mass populated incorrectly
Solution: Click the Edit Icon on the affected Course Attendance record(s), select the correct date if applicable, then click the Save Icon. This will automatically fix the Date/Day Number to match.
NOTE: If a CHANGE Query was the cause of the issue, the Day Number Values (D1/D2) can be updated via another CHANGE query. Please enter a support ticket if assistance is needed to write the queries.