Attendance Contact Hour Summary

Report Location: Student>Student Custom Reports>Attendance Reports>Attendance Summary

Summary: This report displays cumulative totals by year found in principals and superintendents contact hour reports including regular attendance, special programs attendance, ADA and FTE results. It also shows each reporting period totals for campuses selected, both as a summary and for each individual campus.

Usage: Review attendance trends longitudinally across years to check for funding issues at the district or individual campus level.

Special Notes:

“N/A” columns indicate the data was not collected by TEA for the respective year.
“-” columns indicate no data reported by the LEA for the respective element and/or year.
Summary and Reporting Period Totals for ADA and FTE calculations are static (do not use preliminary six weeks): (Sum(ADA or FTE reporting period 1 – 6)) / 6
2019-2020 COVID-19 ADA Adjustments per TEA Guidance: General Funding Question 1.
- Only reporting periods 1 – 4 are used in the 19-20 calculations, any 5-6 reporting period data is ignored.
2020-2021 & 2021-2022 COVID-19 Remote Attendance Adjustments
- Filter added for 2021 & 2022 Remote Attendance Instructional Method (see Features below).
- Total rows added for summing in person and remote attendance in order to produce longitudinal year’s comparisons (apples to apples).
  - Note: LEAs not doing remote attendance for 2020-2021 and 2021-2022 will see the same values for the in person and total rows.
- Total/Grand Total rows include RS and RA remote attendance regardless of remote attendance filter selection on all sections except the new CTE FTE Tier reporting as of 21-22.

Data Source(s): PEIMS Summer records

Interchange Student Extension
- 40100 – Student Extension Complex Type
Interchange Student Attendance
- 42400 – BasicReportingPeriodAttendanceExtension
- 42401 – SpecialProgramsReportingPeriodAttendanceExtension
  - 42405 – Special Education Attendance
  - 42410 – Career and Technical Education
  - 42500 – Flexible Attendance

Definitions and Calculations:

Regular Attendance

Percent in Attendance
- (Total Days Present / Total Days Membership) * 100
  - Note: Percent in Attendance does not include flex attendance
Days Membership
- Grand Total Eligible Days + Total Ineligible Days + Total Days Absent
Total Days Absent (E0036)
- Total Days Absent not eligible for Foundation School Program funding
Total Days Present
- Total Eligible Days + Total RS Elig Days + Total RA Elig Days + Total Ineligible Days
Total Ineligible Days (E0936)
- Total Days Present but Ineligible for Foundation School Program funding
Grand Total Eligible Days
- Total Eligible Days + Total RS Elig Days + Total RA Elig Days
Total Eligible Days (E0937)
- Total Days Present and Eligible for Foundation School Program funding
Flex Total Eligible Days
- Lesser of Flex Attend Equivalent Days Present (Flex Attend Total Eligible Minutes Present (E1046) /240) or Number Days Taught
(Grand Total + Flex Total) Eligible Days
- Grand Total Eligible Days + Flex Total Eligible Days
  - Note: Allows districts who offer flex attendance to have a better idea of their total eligible days present for FSP funding and be able to compare true eligible days present longitudinally across years

Special Programs Attendance

Total Elig Days Bilingual/ESL
- Elig Days Bilingual/ESL + RS Elig Days Bilingual/ESL + RA Elig Days Bilingual/ESL
Elig Days Bilingual/ESL (E0938)
- BE – Elig Days Bilingual/ESL + D1 – Elig Days Bil Dual Lang + D2(EL) – Elig Days Bil Dual Lang + D2(EP) – Elig Days Bil Dual Lang
- Pre 2019-2020 Total Elig Bilingual/ESL Days Present (E0938)

Total BE – Elig Days Bilingual/ESL
- BE – Elig Days Bilingual/ESL + RS BE – Elig Days Bilingual/ESL + RA BE – Elig Days Bilingual/ESL
Total D1 – Elig Days Bil Dual Lang
- D1 – Elig Days Bil Dual Lang + RS D1 – Elig Days Bil Dual Lang + RA D1 – Elig Days Bil Dual Lang
Total D2 (EL) – Elig Days Bil Dual Lang
- D2 (EL) – Elig Days Bil Dual Lang + RS D2 (EL) – Elig Days Bil Dual Lang + RA D2 (EL) – Elig Days Bil Dual Lang
Total D2 (EP) – Elig Days Bil Dual Lang
- D2 (EP) – Elig Days Bil Dual Lang + RS D2 (EP) – Elig Days Bil Dual Lang + RA D2 (EP) – Elig Days Bil Dual Lang

Following rows use Total Elig Bilingual/ESL Days Present (E0938)

BE – Elig Days Bilingual/ESL
- Bilingual/ESL Funding Code (E1651) = BE and LEP (E0790) = 1 *new HB3 19-20
D1 – Elig Days Bil Dual Lang
- Bilingual/ESL Funding Code (E1651) = D1 and LEP (E0790) = 1 *new HB3 19-20
D2(EL) – Elig Days Bil Dual Lang
- Bilingual/ESL Funding Code (E1651) = D2 and LEP (E0790) = 1 *EL = English Learner *new HB3 19-20
D2(EP) – Elig Days Bil Dual Lang
- Bilingual/ESL Funding Code (E1651) = D2 and LEP (E0790) = 0, F, S, 3, 4 , 5 * EP = English Proficient *new HB3 19-20

Total Early Ed Eco Dis Elig Days
- Early Ed Eco Dis Elig Days + RS Early Ed Eco Dis Elig Days + RA Early Ed Eco Dis Elig Days
Total Early Ed Lang Elig Days
- Early Ed Lang Elig Days + RS Early Ed Lang Elig Days + RA Early Ed Lang Elig Days

Following rows use Total Eligible Days Present (E0937)

Early Ed Eco Dis Elig Days (E0017 = KG, 01, 02, 03) and Eco Dis (E0785 = 01, 02, 99) *new HB3 19-20
Early Ed Lang Elig Days (E0017 = KG, 01, 02, 03) and LEP (E0790 = 1) *new HB3 19-20

Total Elig Days Residential Facility
- Elig Days Residential Facility + RS Elig Days Res Fac + RA Elig Days Res Fac
Elig Days Residential Facility (E1652) *new HB3 19-20
Total Eligible Days Pregnancy Rel Serv
- Eligible Days Pregnancy Rel Serv + RS Elig Days Preg Rel Serv + RA Elig Days Preg Rel Serv
Eligible Days Pregnancy Rel Serv (E0939)
Total Eligible Days SpecEd Mainstream
- Eligible Days SpecEd Mainstream + RS Elig Days SpecEd Main + RA Elig Days SpecEd Main
Eligible Days SpecEd Mainstream (E0940)

ADA

Total ADA rows combine in-person, RS + RA eligible days
Bilingual/ESL Refined ADA
- BE – Elig Days Bilingual/ESL + D1 – Elig Days Bil Dual Lang + D2(EL) – Elig Days Bil Dual Lang + D2(EP) – Elig Days Bil Dual Lang / Number Days Taught (E0935)
  - Pre 2019-2020 Total Elig Bilingual/ESL Days Present (E0938) / Number Days Taught (E0935)
BE – Bilingual/ESL Refined ADA *new HB3 19-20
- BE-Elig Days Bilingual/ESL / Number Days Taught (E0935)
D1 – Bil Dual Lang Refined ADA *new HB3 19-20
- D1-Elig Days Bil Dual Lang / Number Days Taught (E0935)
D2(EL) – Bil Dual Lang Refined ADA *new HB3 19-20
- D2(EL)-Elig Days Bil Dual Lang / Number Days Taught (E0935)
D2(EP) – Bil Dual Lang Refined ADA *new HB3 19-20
- D2(EP)-Elig Days Bil Dual Lang / Number Days Taught (E0935)
Residential Facility Refined ADA *new HB3 19-20
- Elig Days Residential Facility / Number Days Taught (E0935)
Spec Ed Mainstream Refined ADA
- Eligible Days SpecEd Mainstream / Number Days Taught (E0935)
Early Ed Eco Dis Refined ADA *new HB3 19-20
- Early Ed Eco Dis Elig Days / Number Days Taught (E0935)
Early Ed Lang Refined ADA *new HB3 19-20
- Early Ed Lang Elig Days / Number Days Taught (E0935)

FTE

Total FTE rows combine in-person, RS + RA eligible days except for the new CTE FTE Tier reporting as of 21-22.
Pregnancy Rel Serv FTE (E0939)
- (Eligible Days Pregnancy Rel Serv * 0.2936) / Number Days Taught (E0935)
Career & Technical Ed FTE (E0950, E0951, E0952, E0953, E0954, E0955) – Sunset with HB1525 as of 20-21.
- Contact Hours = Eligible Days Present V1, V2, V3, V4, V5, V6 * Weighted value (V1 – V6)
- Career & Technical Ed FTE = Total Contact Hours / (Number Days Taught * 6)
Career & Technical Ed Tier FTE (E0950, E0951, E0952) – effective 21-22 per HB1525 by new CTEMultiplier complex reporting
- Tier 1 – Not an Approved Program of Study – student is enrolled in a CTE Service ID NOT assigned to a Program of Study (POS)Reference TEA Program of Study resources for service ids and weighted funding by POS.
- Tier 2 – Levels 1 & 2 in an Approved Program of Study ; student is enrolled in a CTE Service ID designated as a Level 1 or Level 2 course per TEA Program of Study references noted above.
- Tier 3 – Levels 3 & 4 in an Approved Program of Study ; student is enrolled in a CTE Service ID designated as a Level 3 or Level 4 course per TEA Program of Study references noted above.
  - Career & Technical Ed FTE = Total Contact Hours / (Number Days Taught * 6)
  - Career & Technical Education FTE = Total Instructional Track Contact Hours / (DAYS_TAUGHT * 6)
    - Contact Hours = (Total eligible days present + RS Total eligible days present + RA Total eligible days present * WEIGHT)Multiply the sum of Career and Technical Education eligible days present by the corresponding weight factor to calculate contact hours:
      - (V1 – weight 1)
      - (V2 – weight 2)
      - (V3 – weight 3).

Special Education FTE (E0944)
- Contact Hours = (Eligible Days Present In Instr Setting * Weighted value) – Excess Hours in Instructional Setting (E0945)
- Special Education FTE = Total Contact Hours / (Number Days Taught * 6)

ADA

Total Regular Program Refined ADA
- Grand Total Refined ADA – Total Career & Technical Ed FTE – Total Special Education FTE
Regular Program Refined ADA
- Total Refined ADA – Career & Technical Ed FTE – Special Education FTE
Grand Total Refined ADA
- Grand Total Eligible Days / Number Days Taught (E0935)
Total Refined ADA
- Total Eligible Days / Number Days Taught (E0935)
Preg Related Serv ADA
- Eligible Days Pregnancy Rel Serv / Number Days Taught (E0935)

2020-2021 & 2021-2022 COVID-19 Remote Attendance Rows

Total RS Elig Days – E1678
Total RA Elig Days – E1679
RS Elig Days Bilingual/ESL – E1682
RA Elig Days Bilingual/ESL – E1683
RS BE – Elig Days Bilingual/ESL – Bilingual/ESL Funding Code (E1680) = BE and LEP (E0790) = 1
RA BE – Elig Days Bilingual/ESL – Bilingual/ESL Funding Code (E1681) = BE and LEP (E0790) = 1
RS D1 – Elig Days Bil Dual Lang – Bilingual/ESL Funding Code (E1680) = D1 and LEP (E0790) = 1
RA D1 – Elig Days Bil Dual Lang – Bilingual/ESL Funding Code (E1681) = D1 and LEP (E0790) = 1
RS D2 (EL) – Elig Days Bil Dual Lang – Bilingual/ESL Funding Code (E1680) = D2 and LEP (E0790) = 1
RA D2 (EL) – Elig Days Bil Dual Lang – Bilingual/ESL Funding Code (E1681) = D2 and LEP (E0790) = 1
RS D2 (EP) – Elig Days Bil Dual Lang – Bilingual/ESL Funding Code (E1680) = D2 and LEP (E0790) = 0, F, S, 3, 4 , 5
RA D2 (EP) – Elig Days Bil Dual Lang – Bilingual/ESL Funding Code (E1681) = D2 and LEP (E0790) = 0, F, S, 3, 4 , 5
RS Early Ed Eco Dis Elig Days – E1678
RA Early Ed Eco Dis Elig Days – E1679
RS Early Ed Lang Elig Days – E1678
RA Early Ed Lang Elig Days – E1679
RS Elig Days Res Fac – E1684
RA Elig Days Res Fac – E1685
RS Elig Days Preg Rel Serv – E1686
RA Elig Days Preg Rel Serv – E1687
RS Elig Days SpecEd Main – E1688
RA Elig Days SpecEd Main – E1689
RS Career & Technical Ed FTE – E1696, E1697, E1698, E1699, E1700, E1701
RA Career & Technical Ed FTE – E1702, E1703, E1704, E1705, E1706, E1707
RS Special Education FTE – E1690
RA Special Education FTE – E1691
Refined ADA and FTE follow same calculations as in-person but utilize the appropriate RS or RA values

Features:

Filter on:
- Attendance Categories
  - Regular Attendance
  - Special Programs Attendance
  - ADA
  - FTE
- Multi-select Instructional Track
- Multi-select Campus
- Multi-select Grade Level
  - Elementary
  - Middle
  - High School
- Multi-select Year (default most recent 3 years)
- 2021 & 2022 Remote Attendance Instructional Method (Default in person-RA/RS not selected)
  - Remote Asynchronous – Additionally displays RA attendance rows
  - Remote Synchronous – Additionally displays RS attendance rows
Export to Excel contains the campus at the beginning of each campus row to enable sorting elements by campus (sort column B, then column A)
Graph Control under ‘Tools’
- Trend Line or Bar Graph
- Apply selection to all tables
  - Leave checked to apply selections on top chart to all charts below
  - Click to remove check and individually select elements in every chart
- Graph Zooming

Updated on 05/16/2024

Tagged: Report Notes

Was this article helpful?

Yes No

Need Support?

Can't find the answer you're looking for?

Contact Support