Below are possible reasons some of the ADA/FTE/Attendance calculations may not match reports from your student information system (SIS) (ASCENDER, Frontline, Skyward etc.)
OnDataSuite is reporting these calculations based upon the data extracted from your SIS as reported to TSDS Summer PEIMS . Additionally, attendance data is reported to the state (and OnDataSuite) based upon 6 week reporting periods as opposed to daily counts that may be used by your SIS.
- Verify your OnDataSuite Summer PEIMS file loaded successfully in the File Center using the Infolink. Must have the EducationOrganization, EducationOrgCalendar, Student, StudentEnrollment, StudentProgram and StudentAttendance (Basic Attendance and Special Programs Attendance) interchanges loaded at a minimum.
- Check the date you extracted your PEIMS data and loaded it in ODS and make sure it matches the date of the reporting you are reviewing in your SIS.
- Make sure you are comparing data from same start and end dates (reporting period).
- Verify all instructional tracks, grades, campuses are extracting into the TSDS Summer PEIMS XML interchange files from the SIS. Often the extract process does not include a specific population of students in the file created due to errors noted in the SIS extract process. One of the easiest ways to do this is to check the Dashboards>Summer Dashboard>Cumulative Information for district and campus.
- If the above steps don’t help, break it up into smaller chunks. For example, run the Student Custom Reports>Attendance Reports>Attendance Summary>ADA FTE Summary report and focus on a single campus and grade level for comparisons to SIS report. Compare Total Days Membershp, Total Days Absent, etc. between the two systems. Then use adhoc reporting on the Attendance category to pull list of appropriate students for comparison to SIS detailed lists if they exist.
When reports differ slightly it does not mean they are incorrect.
- Often minor differences in what data is included in the calculation makes a difference, as well as rounding issues may occur.
- Be sure you review the Report Info (under Tools menu on the report) for the OnDataSuite report you are questioning for additional calculation details.