Estimated Lost Revenue due to Absenteeism (Texas)

📍Report Location

Support > Pre-Release Reports until all BETA testing is completed and report is ready to move to Student and Finance.

👤Summary

The Estimated Lost Revenue Due to Absenteeism report estimates the potential district funding impact of student absences. It combines PEIMS attendance and select program participation data (CTE, SPED Mainstream, Bilingual) with district-configured funding rates to estimate lost funding based upon the students Days Absent.

Reporting as 2025-2026 School Year.

• Base ADA – (default $6,215)

• CTE Tier 1 (1.1 weight)
• CTE Tier 2 (1.28 weight)
• CTE Tier 3 (1.47 weight)
• Special Education Mainstream (1.15 weight)
• EB – Bil – Not Dual Lang (.1 weight)
• EB-Bil – Dual Lang (.15 weight)
• Non EB – Bil – Dual Lan (.05 weight)

The report provides both campus-level summaries and student-level detail, allowing districts to identify where absenteeism may be having the greatest estimated financial impact.

💡Usage

This report is designed to help district and campus leadership understand the estimated financial impact of student absences.

Common uses include:

• Identifying campuses with the highest estimated funding loss
• Identifying students contributing the greatest estimated funding impact
• Prioritizing attendance intervention efforts
• Monitoring trends across reporting periods
• Sharing attendance impact information with campus administrators

Before relying on the estimated dollar amounts, district finance staff should confirm the district’s funding rates if the state defaults are adjusted in any fashion. Reference kb: https://kb.ondatasuite.com/knowledge-base/attendance-funding-rates-override/

Campus summary student counts provide drilldowns into the corresponding student list, and the report can be exported to Excel for additional analysis or sharing.

🧭Special Notes

• All dollar amounts are estimates only and are not official TEA or Summary of Finance calculations.
• Texas FSP funding loss estimates are based upon the respecitve year defaults/overrides as indicated utilizing the District Funding Rates on the report. If these rates are incorrect for the LEA, please have a Finance Administrator update the rates utlizing the Attendance Funding Rates Override.
• Students are reported based on their summer enrollment campus, even if attendance occurred at multiple campuses.
• District funding rates should be reviewed and updated each year before sharing estimated funding information with campus staff.
  
  
  • Funding rates are maintained under: Administrator → Overrides → Attendance Funding Rates
  • Users with Admin, Finance Admin, or Finance security permissions may update these rates. Other users have read-only access.

🎛Data Source(s)

The report combines data from multiple PEIMS Summer entities, including:

• Student Enrollment
  • 40110 Student School Association Extension
    • Summer campus assignment
  • 101 Demographic Extension
    • Grade level
  • 100 Student Identification Extension
    • Student name
    • Local student ID

• Student Attendance
  • 42400 Basic Reporting Period Attendance Extension
    • Days Absent
    • Number Days Taught
  • rec_CTEMultiplier

📑Definitions

Student Inclusion Criteria

Students appear on the report only when all of the following are true:

• Meet the selected Minimum Days Absent threshold (default = 1)
• Have Membership Days greater than zero
• Are assigned to a campus through Summer Enrollment (rec_110_summer)

Days Absent

The total Days Absent (PEIMS E0036) across the selected reporting periods.

Number Days Taught

The total number days taught (PEIMS E0935) across the selected reporting periods.

🧮Calculations

Absence Ratio

Days Absent ÷ Number Days Taught

Estimated Lost Base ADA

• Absence Ratio × Base ADA Rate

Estimated Lost CTE

For each funding tier:

• Absence Ratio × Tier 1 Rate
• Absence Ratio × Tier 2 Rate
• Absence Ratio × Tier 3 Rate

Estimated Lost Special Education Mainstream

• Absence Ratio × Special Education Mainstream Rate

Estimated Lost Bilingual

• Absence Ratio × Bilingual Rate

Estimated Lost Total

The sum of all estimated funding losses across eligible funding programs.

✨Features

Year – (Reporting as of 2025-2026 forward)

Select a single PEIMS year.

Defaults to the most recent year containing BasicReportingPeriod attendance data.

Campuses

Select one or more campuses.

Includes quick selections for:

• All Elementary Schools
• All Middle Schools
• All High Schools

Reporting Period

Choose:

• All Reporting Periods
• Multi-Select
• Default – All Reporting Periods

Minimum Days Absent

Specify the minimum number of days absent required for a student to appear.

Default: 1 day

Focus List

Optionally limit results to students contained in a selected Focus List.

🔗Resources for qualifications and calculations