The Attendance Audit Listing report checks attendance data in your database against a series of logical validations. The report returns a list of students whose attendance data may be invalid. The Attendance Audit should be run on a regular basis and the errors should be cleared. If any mistakes were made, they are easier to correct when the data entry or attendance situation are fresh in the minds of school personnel. 


Filter Reports by "audit" or navigate to Reports > Attendance > Attendance Audit Listing.



At the School level, the report prints for the current school. At the District level, the form allows you to select the school(s) to print:


At the school and district levels, select the checkboxes Include Inactive Students Without Attendance and Include Missing Exit Reason Errors at your own discretion, depending on your attendance procedures and on how you are using the report's results. 


If the Run Old Attendance Audit checkbox is selected, the previous version of the Attendance Audit Listing will run. The previous version of the Attendance Audit Listing displayed only one error per student; the current version of the Attendance Audit Listing displays all errors for each student. 


Validating a TK Student's Attendance Program

The Attendance Program for TK as non-ADA dropdown is provided to assist in maintaining TK students' Attendance Programs. This dropdown is optional; if left blank, the Attendance Audit Listing will not perform the TK validations. 



To add the TK validations to the Attendance Audit Listing, add the Attendance Program code for your TK students who should not be reported for ADA to the dropdown:



Once the TK non-ADA code has been added, when the Attendance Audit Listing is run, it will check the following:


  • TK students who turned five years old before December 2nd should not be in the TK non-ADA program
  • TK students who turn five after December 2nd should be in the TK non-ADA program until they turn five years old


Messages will be provided on the report and on the student's Demographics and Attendance Enrollment pages. Students will also be tagged with report tags. 


To clear an Attendance Audit Listing message about a TK student and their ADA status:


  1. Note the student's ID number and their birthdate.
  2. Compare their birthdate to their Attendance Program on the Attendance Enrollment page.


For example, the student below enrolled on the first day of school in Regular Program (Prg is blank), which will be reported for ADA. The student is in grade TK and turns five years old on 1/16/2019. His record displays a message of "TK Student under 5 Years Old after Dec. 2nd flagged for ADA with code (blank)." 



To fix this student's enrollment record, he should be coded as entering the TK No ADA program of K on 7/2/2018. On his fifth birthday, he may be reported for ADA, so his enrollment record should reflect that he leaves the TK No ADA program on the last school date before his birthdate and enters the Regular Program on his fifth birthday or the next school date after:



Note:  Please refer to CDE documentation on ADA procedures for TK and all students. According to the CDE's Transitional Kindergarten FAQ, TK students who turn 5 years old before December 2nd can be reported for ADA starting on the first day of the school year. TK students who turn 5 years old after December 2nd should not be reported for ADA until they turn 5.



Using Attendance Audit Results and Report Tags

Below the report options, the Attendance Audit Listing includes Report Tags information for students in the report. Please refer to the Report Tags documentation for guidance on using Report Tags. After running the Attendance Audit Listing, if students appear on the report, they can be included in a query using the appropriate Report Tag and Query Tag Value, as listed on the Attendance Audit form:



For example, the Attendance Audit may include students with validation messages regarding TK and ADA:



After the Attendance Audit is run, those students will be tagged in RTG.QT with AA, AB, or AC. Then those students could be included in a query:


LIST STU STU.SN STU.LN STU.FN STU.BD STU.BD? STU.GR IF RNV = "PrintAttendanceAuditListing" AND QT = AA


More Information

For more information, please refer to the other documents included in Attendance and to the documents provided in Enrollment Data Management.


Error Listing

Below is a complete listing of the errors:


Report Name Value: PrintAttendanceAuditListing

Query Tag Value: 

  • 0 : Active student not currently enrolled in attendance
  • 1 : Inactive student still enrolled in attendance
  • 2 : Student has no enrollment data and/or no summer withdrawal
  • 3 : Student has two Enter records with no Leave in between
  • 4 : Student has two Leave records with no Enter in between
  • 5 : Student has an invalid Enter/leave code
  • 6 : Grade does not match current enrollment record of __
  • 7 : Program does not match current enrollment record of __
  • 8 : Teacher does not match current enrollment record of __
  • 9 : Track does not match current enrollment record of __
  • A : Att Pgm 1 does not match current enrollment record of __
  • B : Att Pgm 2 does not match current enrollment record of __
  • C : Student has L or B leave code with no exit reason code
  • D : Student is inactive and has no Leave date in STU
  • E : Student is active and has a Leave date in STU
  • F : Teacher does not match current Attendance Period teacher of __
  • G : Mismatch between enter and leave data in attendance (GR/TR/PR/TN/AP1/AP2)
  • H : Reporting home school does not match current enrollment record of __
  • I : Interdistrict Transfer does not match current enrollment record of __
  • J : District of Residence does not match current enrollment record of __
  • K : NPS School (CSE.SS) does not match current enrollment record of __
  • L : Student Enrolled in Attendance but has no Classes on __
  • M : Student Enrolled in Attendance but has no Course Attendance on __
  • N : Student Enrolled in Course Attendance but has no Classes on __
  • O : Student has invalid Day# in Attendance - __
  • P : Student has invalid Day# in Course Attendance - __
  • Q : Student Enrolled on First Day with Summer Withdrawal Reason
  • R : Student Enrolled in Course Attendance but has no Attendance on __
  • S : Student missing Summer Leave Date with Summer Withdrawal Reason
  • T : Student has invalid or missing Track Code in ATT of __
  • U : Student has invalid or missing Track Code in STU of __
  • V : Student has Attendance without Enrollment on __
  • W : Student has Period Attendance without Enrollment on __
  • X : Student has a Dropout Summer Withdrawal Reason but is active at school __
  • Y : Student has a Dropout code but has attendance data at school __
  • Z : Student has Teacher (ATT.TN) populated in a Period Attendance School
  • AA : TK Student under 5 Years Old after December 2nd flagged for ADA with code __
  • AB : TK Student 5 Years or older as of December 2nd flagged to bypass ADA with code __
  • AC : TK Student 5 Years or older by Today flagged to bypass ADA with code __
  • AD : Student Leave Date does not match Attendance Leave Date of __
  • AE : Student does not have an Attendance Enter after a 440 Leave on __
  • AF : Student has Course Attendance without Enrollment on __
  • AG : Student has mismatch between All Day Attendance Code and ADA Period Code on __
  • ? : Status Uncertain