Report Location: Finance > Finance Custom Reports > Summary of Finance (SOF) Reports > Student Funding Detail Reports >Student ADA Summary (renamed from previous report name – HB3 Student ADA- Refined, Flex Attend, SPED Mainstrm, Bil, Early Ed, PEG, Res Facility)
Summary: This report provides Student ADA data for Summary of Finance (SOF) program funding related to District Summary for Refined ADA, Flex Attendance ADA, ADSY ADA, Special Education Mainstream, Career Tech Incentive (P-TECH, NTN) , Bilingual/ESL, Early Education (K-3), PEG and Residential Placement Facility on a single report.
Usage: Use aide to help complete the Summary of Finance (SOF) template data elements related to program ADA calculations as defined by HB3 and HB2. (Note: Report updated August 2025 to include ADSY ADA and reflect the new HB2 Funding details for Early Education Allotment.
Special Notes: As TEA provides updates for the HB2 (as of FY 25-26) funding changes, the reports will be updated.
Prior Year HB3 and COVID Notes:
- 2019-2020 COVID-19 ADA Adjustments per TEA Guidance: General Funding Question 1. – Steps 1 – Steps 2 applied on this report. Step 3 is outside the scope of this report at this time. (see Calculations below for details)
- 2020-2021 and 2021-2022 COVID-19 Remote Attendance Adjustments
- Totals include RS and RA remote attendance per the respective section calculation.
Data Source(s): PEIMS Summer records, PEIMS Extended Year records
- 2024-2025 and beyond (Ed-Fi)
- Student Attendance Domain –
- BasicReportingPeriodAttendance Entity (42400)
- SpecialProgramsReportingPeriodAttendance Entity(42401)
- Attendance Event Indicator (E1085) = 11 Regular – SpecialEd Mainstream
- Attendance Event Indicator (E1085) = 02 Regular – Bilingual/ESL
- SpecialProgramsReportingPeriodAttendance Entity (42500)
- Staff Domain
- StaffSchoolAssociation Entity (30310)
- Staff Entity (30040)
- Teaching and Learning Domain
- StaffSectionAssociation Entity (30305)
- StaffSectionAssociation Entity (30305)
- Student Attendance Domain –
- 2023-2024 and prior years (XML)
- Interchange Student Attendance Extension
- 42400-Basic Reporting Period Attendance Extension Complex Type
- 42401-Special Programs Reporting Period Attendance Extension Complex Type
- Attendance Event Indicator (E1085) = 11 Regular – SpecialEd Mainstream
- Attendance Event Indicator (E1085) = 02 Regular – Bilingual/ESL
- 42500-Special Programs Reporting Period Attendance Extension Complex
- Interchange Student Attendance Extension
Calculations:
- 2019-2020 COVID-19 ADA:
- REQUIRED: 2018-2019 Summer PEIMS files and 2019-2020 Summer PEIMS files uploaded into OnDataSuite for this calculation to accurately compute.
- 2018-2019 Historical Ratio =2018-2019 Refined ADA (1-6 six weeks) divided by 2018-2019 Refined ADA (1-4 six weeks).
- This ratio will display at the top of the HB3 Student ADA report on the 2019-2020 year ONLY.
- It will be used in the Covid-19 Adjusted Refined Total calculation for all ADA sections of the report.
- 2019-2020 5th and 6th six weeks data will display N/A per TEA guidance that it will be ignored for 19-20 calculations.
- 2019-2020 Covid-19 Adjusted Refined Total = 1st – 4th six weeks Refined ADA ((Sum of 1st – 4th six weeks)/4)) multiplied by the 2018-2019 Historical Ratio
- 2018-2019 Historical Ratio =2018-2019 Refined ADA (1-6 six weeks) divided by 2018-2019 Refined ADA (1-4 six weeks).
- REQUIRED: 2018-2019 Summer PEIMS files and 2019-2020 Summer PEIMS files uploaded into OnDataSuite for this calculation to accurately compute.
Basic Attendance ADA:
- Refined ADA by six weeks – Sum of all students’ total eligible days present (E0937) from 42400 Basic Reporting Attendance in a six-week period / number days taught (E0935) in the six week period
- 2020-2021 and 2021-2022 RA/RS included: (Total eligible days present (E0937) + RS Total eligible days present (E1678) + RA Total eligible days present (E1679 ) / number days taught (E0935)
- Refined ADA Total – Sum of all six-week periods, divided by six, and rounded to 3 decimals.
- (Total Eligible Days Present First Six Weeks / Number Days Taught First Six Weeks) +
- (Total Eligible Days Present Second Six Weeks / Number Days Taught Second Six Weeks) +
- (Total Eligible Days Present Third Six Weeks / Number Days Taught Third Six Weeks) +
- (Total Eligible Days Present Fourth Six Weeks / Number Days Taught Fourth Six Weeks) +
- (Total Eligible Days Present Fifth Six Weeks / Number Days Taught Fifth Six Weeks) +
- (Total Eligible Days Present Sixth Six Weeks / Number Days Taught Sixth Six Weeks) = Total Result
- Total Result / 6 = Refined ADA Total
Flexible Attendance ADA:
- Flex Attend Total Eligible Minutes Present by six weeks – Sum of all students’ flex attendance total eligible minutes present (E1046)
- Flex Attend Equivalent Eligible Days Present by six weeks
- Determined by each individual student for each reporting period:
Flexible Attendance Program Type Code | 2019-2020 forward |
If E1045 = 1, 3 or 6 (OFSDP) | than Flex Attend Total Eligible Minutes Present-E1046 / 240 |
If E1045 = 2 (HSEP) | than Flex Attend Total Eligible Minutes Present-E1046 / 360 |
- Flex Attend Adjusted Equivalent Eligible Days Present – Determined by each individual student for each reporting period
- Per TWEDS https://tealprod.tea.state.tx.us/TWEDS/98/0/0/0/DataComponents/ComplexType/List/11310 – scroll to DR 11
- Funding is limited to the lesser of Equivalent Eligible Days Present or NUMBER-DAYS-TAUGHT, which is determined during funding calculations at TEA. If the calculated Equivalent Eligible Days Present is greater than NUMBER-DAYS-TAUGHT for the reporting period, an Adjusted Equivalent Eligible Days Present is calculated to be NUMBER-DAYS-TAUGHT.
- The following is an illustration of how TEA will convert FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT to Average Daily Attendance for funding purposes.
- Data Conversion Formulas/Rules:
- OFSDP Equivalent Eligible Days Present for the six-week reporting period = FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT/240 minutes (4 hours x 60 minutes)
- HSEP Equivalent Eligible Days Present for the six-week reporting period = FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT/360 minutes (6 hours x 60 minutes)
- Adjusted Equivalent Eligible Days Present = the lesser of Equivalent Eligible Days Present or NUMBER-DAYS-TAUGHT
- Adjusted Equivalent Eligible Days Present/NUMBER-DAYS-TAUGHT= Average Daily Attendance (ADA) value for six-week reporting period
- Per TWEDS https://tealprod.tea.state.tx.us/TWEDS/98/0/0/0/DataComponents/ComplexType/List/11310 – scroll to DR 11
- Flex Attend Refined ADA *Note: based upon the Flex Attend Adjusted Equivalent Eligible Days Present per student
- Sums all students’ Flex Attend Adjusted Equivalent Eligible Days Present together
- Refined ADA by six weeks – Sum of all students’ Flex Attend Adjusted Equivalent Eligible Days Present in a six-week period / number days taught in the six week period
- Starting with 2020-2021 RA/RS included: (Total eligible days present + RS Total eligible days present + RA Total eligible days present) / number days taught
- Flex Attend Refined ADA Total – Sum of all six-week periods, divided by six, and rounded to 3 decimals.
- (Total Flex Attend Adjusted Equivalent Eligible Days Present First Six Weeks / Number Days Taught First Six Weeks) +
- (Total Flex Attend Adjusted Equivalent Eligible Days Present Second Six Weeks / Number Days Taught Second Six Weeks) +
- (Total Flex Attend Adjusted Equivalent Eligible Days Present Third Six Weeks / Number Days Taught Third Six Weeks) +
- (Total Flex Attend Adjusted Equivalent Eligible Days Present Fourth Six Weeks / Number Days Taught Fourth Six Weeks) +
- (Total Flex Attend Adjusted Equivalent Eligible Days Present Fifth Six Weeks / Number Days Taught Fifth Six Weeks) +
- (Total Flex Attend Adjusted Equivalent Eligible Days Present Sixth Six Weeks / Number Days Taught Sixth Six Weeks) = Total Result
- Total Result / Number of reporting periods with values =Flex Attend Refined ADA
Additional Days School Year (ADSY) ADA: Extended Year PEIMS reporting only – Reporting Period = 9. Will report under the Refined Total column only.
Total Refined ADA = sum of Refined ADA, Flex Attendance ADA and ADSY ADA
Special Program Attendance ADA:
- Refined ADA by six weeks – Sum of all students’ total eligible identified special program event from 42401 Special Programs Attendance in a six-week period / number days taught (E0935) in the six week period
- 2020-2021 and 2021-2022 RA/RS included per special program area: (Total eligible days present + RS Total eligible days present + RA Total eligible days present) / number days taught
- Refined ADA Total – Sum of all six-week periods, divided by six, and rounded to 3 decimals.
- (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present First Six Weeks / Number Days Taught First Six Weeks) +
- (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present Second Six Weeks / Number Days Taught Second Six Weeks) +
- (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present Third Six Weeks / Number Days Taught Third Six Weeks) +
- (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present Fourth Six Weeks / Number Days Taught Fourth Six Weeks) +
- (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present Fifth Six Weeks / Number Days Taught Fifth Six Weeks) +
- (Total Eligible Bilingual/ESl Days, Residential Facility Days, or SPED Mainstrm Days Present Sixth Six Weeks / Number Days Taught Sixth Six Weeks) = Total Result
- Total Result / 6 = Refined ADA Total
Career and Technical Incentive ADA District Summary:
The following two areas (P-TECH and NTN) were updated in ODS 1/28/2025 retroactive to 2021-2022 to utilize ADA and not Enrollment – reference The 22-23 TEA Student Attendance Accounting Handbook (pg 165) for this clarification.
- P-TECH ADA : = Refined ADA calcualtion of students reported with Summer PEIMS P-TECH Indicator (E1612) = 1.
- New Tech Network (NTN) ADA: = Refined ADA calculation of students reported with Summer PEIMS New Tech Network (NTN) Indicator (E1647) equal 1.
Bilingual/ESL Refined ADA District Summary.
- 2020-2021 and 2021-2022 RA/RS Bilingual/ESL Funding Codes included in criteria: Bilingual/ESL Funding Code (E1651), RS Bilingual/ESL Funding Code (E 1680) and RA Bilingual/ESL Funding Code (E1681)
- Bilingual/ESL ADA – Not in Dual Language Program – EB ADA calculation for students reported with Bilingual/ESL Funding Code (E1651) = “BE” AND the student is EmergentBilingualIndicator (E0790) = 1
- Special Program ADA calculation for selected students’ eligible Bilingual/ESL days present (E0938) from 42401 Special Programs Attendance.
- Bilingual – Dual Language One & Two Way Pgm – EB ADA calculation for students reported with (Bilingual /ESL Funding Code (E1651) = “D1” OR “D2”) AND student is EmergentBilingualIndicator (E0790) = 1.
- Special Program ADA calculation for selected students’ eligible Bilingual/ESL days present (E0938) from 42401 Special Programs Attendance.
- Bilingual – Dual Language Two Way Pgm – Non EB ADA calculation for students reported with Bilingual/ESL Funding Code (E1651) = “D2” AND the student is Not EmergentBilingual (E0790) = 0, F, S, 3, 4 or 5)
- Special Program ADA calculation for selected students’ eligible Bilingual/ESL days present (E0938) from 42401 Special Programs Attendance.
Early Education Refined ADA District Summary.
HB3 funding for grades K-3 only. Students may be duplicated counted in both rows.
- K-3 Eco Dis students: Students classified as Economic Disadvantaged (E0785) =01, 02 or 99 and in grade K – 3.
- Basic Attendance ADA calculation for selected students.
- K-3 Emergent Bilingual (EB) students: Students classified as Emergent Bilingual (E0790) = 1 and Bilingual/ESL Funding Code (E1651) = BE, D1 or D2 and in grade K-3.
- Basic Attendance ADA calculation for selected students.
HB2 funding for Early Ed as of 25-26.
- All K-3 Students ADA: All students reported with attendance in grades KG – 3.
- Basic Attendance ADA calculation for selected students.
- FSP-Eligible PreK (half-day ADA, 4 yr olds Only): Students Age 4 as of September 1 enrolled in PK Program Type (E1078) = 2 or 3.
- Basic Attendance ADA calculation for selected students
*Note: The Total is a sum of each row on this section and includes any student that is duplicate counted.
Public Education Grant (PEG) ADA District Summary.
- Basic Attendance ADA calculation for all students reported with Student Attribution (E1000) = 03 (PEG)
Residential Placement Facility ADA District Summary
- Special Program ADA calculation for all students’ eligible Residential Facility days present (E1652 from 42401 Special Programs Attendance.
Features:
- Filter on:
- Multi-select Years (Default latest PEIMS file processed)
- District/Campus Summary (Default District Summary)
- Multi-select Campuses
- Check District/Campus Summary in conjunction with campus(es) to display a campus summary and each individual campus
- Multi-select Instructional Tracks (Default All Tracks)
- Focus List
- Drill down on counts to see detailed student list
- Toggle Student Counts – displays six weeks cumulative count of Unique student ID on any student in the respective ADA calculation over the six weeks.
Tools:
- Export to Excel
- Bookmark
- Report Notes
- Use ‘Heatmap On’ with a minimum and maximum limit to highlight specific areas of concern.
- Finance Reporting Period Override
Resources for Calculations:
TEA HB2 Resource page: https://tea.texas.gov/about-tea/government-relations-and-legal/government-relations/house-bill-2
TEA HB3 Resource page: https://tea.texas.gov/About_TEA/Government_Relations_and_Legal/Government_Relations/House_Bill_3