Summary of Finance (SOF) – Post 2025 Student/Staff Data Summary

Report Location: Finance > Finance Custom Reports > Summary of Finance (SOF) Reports > Summary of Finance Summary > Summary of Finance – Student/Staff Data Summary Post 2025

Summary: This report is intended to provide a single report view of the Student/Staff PEIMS Data required for completion of the Summary of Finance(SOF) templates:State Aid Temple/TASBO Version or Omar Garcia’s SOF template.

Usage: Use aide to review and complete the PEIMS student/staff inputs for the Summary of Finance (SOF) templates. The report layout follows the TASBO template format which closely aligns to Omar’s template, plus some additional details related to Flex and ADSY Attendance reporting. The report is a monitoring tool for current year projections as of latest required data sources loaded in ODS.

The baseline year available is 2025-2026when the updates by HB2 for resturcture of Bilingual/ESL Funding and impact on the Early Education K-3 Emergent Bilingual updates and the reporting of JROTC CTE FTEs resulted in significant changes that prevented prior year comparisons for these sections.
Note: For prior year data where applicable, reference the Finance SOF report – Summary of Finance Student/Staff Data Summary https://kb.ondatasuite.com/knowledge-base/summary-of-finance-sof-student-data-summary/

Current year values will be based upon the latest Summer PEIMS promoted in ODS (which could include partial six weeks data). Unless the Finance Reporting Period Override has been set.

The drilldowns on this report will link to the respective Finance : Summary of Finance (SOF) Reports – Student Funding Detail Reports for the specific data set details included in the total.

Data Source(s) Required:

Fall PEIMS – Required for Compensatory Education Tier Enrollment AND new Staff Teacher Retention Allotment (TRA) reporting.

Summer PEIMS, Extended Year PEIMS – Required for ADA, FTE, P-Tech Enrollment,Dyslexia and G/T Count

Summer SPED (SPPI-11) – Required for Full-Time Initial Evaluation (FIE)

Calculations:

Rows with dark grey boxes in the values are not available in the data submitted to TSDS PEIMS or defined and available to ODS at this time.

All ADA and FTE values are rounded to 3 decimal places.

All Enrollment and Counts are reported as whole numbers.

Regular Program Refined ADA – (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) / 6.

Flexible Attendance ADA – OFSDP or HSEP – By respective program : (Sum of all students’ total Flex Attendance Adjusted Equivalent Eligible days presen from 42400 Basic Reporting Attendance in a six-week period / number days taught (E0935) in the six week period) / 6.

ADSY Attendance ADA – Reporting Period 9 (in Extended Year PEIMS submission): ADA calculations divide eligible days by 30 rather than by Days Taught and then multiply by 30/180 to generate ADSY additional funding for one-sixth of the school year (additional 30 days of half-day instruction divided by 180 days of instruction

Total Refined ADA – sum of the Regular Program Refined ADA, Flexible Attendance ADA (OFSDP and HSEP) and ADSY Attendance ADA. This is the PEIMS Reported ADA on the TEA Summary of FInance report before any adjustments by TEA.

Special Education FTEs by instructional setting EXCEPT for Mainstream (40).

By six weeks:
- Contact Hours = (DAYS_ELIG * WEIGHT) – HRS_EXCESS
- Special Education FTE = Total Contact Hours / (DAYS_TAUGHT * 6)
Total: Average of the six weeks FTE calculations.

Total Weighted Special Ed FTEs

The individual year and SPED Instructional Arrangement FTE rows are multiplied by the respective weight noted below then summed to reflect the Total.

Use the Show Weighted Rows toggle option (located on filter row) to display the individual row weighted FTEs which comprise the Total reported.

Special Education Mainstream ADA:

ADA by six weeks – (Sum of all students’ total eligible days present (E0940) identified from 42401 Special Programs Attendance in a six-week period / number days taught (E0935) in the six week period) / 6 (or number of reporting periods reported in Summer file promotion)

Full Initial Evaluation Count:

Count of Students reported on the Summer SPED (SPPI 11 A/B) with Eligibility Evaluation Date (E1715) in the current school year range July 1 – through June 30.

Career & Technical Education FTE:

· Funding Tiers :

Tier 1 – Not an Approved Program of Study – student is enrolled in a CTE Service ID NOT associated with 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
JROTC Tier 2 – Level 1 and 2 Courses ** As of 25-26 Courses added to CTE Funding. Service IDs 03160100, 03160200 and PES00004
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.
JROTC Tier 3 – Level 3 and 4 Courses** As of 25-26 Courses added to CTE Funding. Service IDs 03060300 and 03060400.

FTE per Tier

Career & Technical Education FTE = Total Contact Hours / (DAYS_TAUGHT * 6)
- Contact Hours = (Eligible days present V1…V3 (E0950…E0952) * respective Vcode 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).
- Sum the contact hours for all Career and Technical Education codes within the track.
- Divide the total contact hours for each track by 6 times the number of days taught to yield the Career and Technical Education FTE for the track.
Total: Average of the tier six weeks FTE calculations.

P-TECH ADA

ADA = Refined ADA calcualtion of students reported with Summer PEIMS Student Characteristic (E3063) = 07.

Bilingual/ESL ADA:

2025-2026 and beyond updates per HB2:

RefinedADA calculations for students reporting Bilingual/ESL Days Present (E00938) AND the respective Funding Indicators as noted by each row:
Emergent Bilingual (EB) ADA not in Dual Lanuguage, including Non-Dual Alternative Methods (.10 weight) ADA included if:
- Emergent Bilingual Indicator (E0790) = 1 AND Bilingual/ESL Funding Code (E1651) = “B1” AND (either the LanguageInstruProgramServices code (E3034) = Bilingual Program Type =042 or 043 OR Alternative Methods = 047 or 048)
- OR Emergent Bilingual Indicator (E0790) = 1 AND Bilingual/ESL Funding Code (E1651) = “E1” AND (either the LanguageInstruProgramServices code (E3034) ESL Program Type = 002 or 003 OR Alternative Methods = 005 or 006)
Emergent Bilingual (EB) ADA in Dual Lanuguage, one-way or two-way setting (.15 weight) ADA included if:
- Emergent Bilingual Indicator (E0790) = 1 AND Bilingual/ESL Funding Code (E1651) = “D3” AND the LanguageInstruProgramServices code (E3034) = Bilingual Program Type =044 or 045
Non-EB ADA in Dual Language, not including Alternative Methods (.05 weight) ADA included if:
- Emergent Bilingual Indicator (E0790) = (F, S, 3, 4, 5 or 0) AND Bilingual/ESL Funding Code (E1651) = “D4” AND the LanguageInstruProgramServices code (E3034) = Bilingual Program Type =044
Alternative Methods Dual Language Emergent Bilingual (EB) ADA (.15 weight) ADA included if:
- Emergent Bilingual Indicator (E0790) = 1 AND Bilingual/ESL Funding Code (E1651) = “D5” AND LanguageInstruProgramServices code (e3034) Alternative Methods = 049 or 050
Alternative Methods Dual Language Non-Emergent Bilingual (non-EB) ADA (.05 weight) ADA included if:
- Emergent Bilingual Indicator (E0790) = (F, S, 3, 4, 5 or 0) AND Bilingual/ESL Funding Code (E1651) = “D6” AND LanguageInstruProgramServices code (e3034) Alternative Methods = 049 or 050

Compensatory Education Enrollment:

The Census Tiers are updated and stored during TSDS Fall PEIMS file loads in OnDataSuite(ODS). If a new TEA Census Block Mapping file is loaded in ODS, the changes are reflected in the report once the Fall PEIMS file is reloaded in ODS.

Tier counts: Count of students based upon residence census block SES Tier associated with the students’ Fall PEIMS Census Block Group (E1648) information reported in PEIMS. Using the respective school year Census Block Tier Mapping for 20xx under State Funding reference.
For updates related to timing of these updates annually, please reference https://kb.ondatasuite.com/knowledge-base/compensatory-education-census-tier-mapping-status/

All Homeless Students (E1082) (C189) = 2, 3, 4 or 5 are assigned to Tier 5 funding.

SCE Residential Facility Placement Enrollment:

Residential Placement Facility – parent does not reside in district, Eco Dis students w/o Disability:

# Economic Disadvantaged: students with Student Attribution (E1000) = 21 or 23 AND Eco Dis (E0785) = 01, 02, 99 AND ADA Eligibility (E0787) = 1, 2, 3, 6 or 7 AND Homeless (E1082) = 0 AND Primary Disability (E0042) = 00. Per TEA guidance HB3 Update – Residential Facility Data Reporting and Funding Update these students do not report Census Block data and the SCE allotment is calculated separate from Tier 1 – Tier 5 funding.

Pregnant Student FTE (Pregnancy Related Services (PRS) FTE):

PRS FTE is calculated as the sum of total pregnancy-related services days eligible (E0939) multiplied by 0.2936. The product is divided by the number of days taught for each grade within the reporting period/instructional track.

Pregnancy Related Services FTE = ([DAYS_PREG * 0.2936] / DAYS_TAUGHT

Total: Average of the six weeks FTE calculations.

Early Education Refined ADA District Summary:

As of 25-26 (HB2 Updates):
- Early Education Refined ADA District Summary. HB3 funding for grades K-3 only. Students may be duplicate counted in both rows.
  - K-3 Educationally Disadvantaged 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 Limited English Proficient Language Learner students: Students classified as LEP (E0790) = 1 and (as of 25-26) new Bilingual/ESL Funding Codes (E1651) = B1, E1, D3 or D5 and in grade K-3.
    - Basic Attendance ADA calculation for selected students.
  - New as of 25-26 : All K-3 Students ADA – students in grades K-3 basic attendance ADA calcualtion.
  - New as of 25-26: FSP-Eligible PreK (half-day ADA, 4 yr olds Only) – basic attendance ADA for all students 4 years old as of Sept 1 AND students is enrolled in PK ProgramType (E1078) = 2 or 3 (receiving services at least 4 hours per day.

Dyslexia Allotment Student Count:

Unduplicated count of students receiving at least one Dyslexia Service as reported on Dyslexia Services Code (E1650) in Summer PEIMS.

Public Education Grant (PEG) ADA District Summary:

Basic Attendance ADA calculation for all students reported with Student Attribution (E1000) = 03 (PEG)

New Instructional Facility Allotment (NIFA) ADA:

All data not available currently to ODS. Reference KB for assistance in projecting this information https://kb.ondatasuite.com/knowledge-base/how-to-generate-a-new-instructional-facility-allotment-nifa-student-count-report-in-ods/

Gifted and Talented Count:

The student count eligible for G/T Allotment Funding.

Student Count: Participating in Gifted/Talented Program – count of students reporting Student Characteristic = 15 (Gifted and Talented) for Summer PEIMS

If the Student Count: Participating in Gifted / Talented Program is greater than G/T Funding Limit: 5% of Current Year Refined ADA
- the funding count is G/T Funding Limit:5% of Current Year Refined ADA;
If the Student Count: Participating in Gifted / Talented Program is less than or equal to G/T Funding Limit: 5% of Current Year Refined ADA
- the funding count to Student Count: Participating in Gifterd/Talented Program.

Full-Time/Hybrid Virtual ADA:

New as of 25-26 and pending full details and reporting qualifications from TEA.

Dropout Recovery School ADA:

Reference KB – data source not currently available in ODS: https://kb.ondatasuite.com/knowledge-base/where-can-i-find-dropout-recovery-ada/

Residential Treatment Facility ADA:

ADA by six weeks – (Sum of all students’ total eligible days present (E1652) identified from 42401 Special Programs Attendance in a six-week period / number days taught (E0935) in the six week period) / 6 (or number of reporting periods reported in Summer file promotion)

School Safety Allotment:
Campuses eligible are Instructional Campuses under the direct control of the LEA.
JJAEPS are excluded explicitly in the law.
Campuses with 0 Refined ADA are excluded.

Refined ADA of Campuses eligible for School Safety Allotment
Campus Count :
- Campuses eligible are Instructional Campuses under the direct control of the LEA.
  JJAEPS are excluded explicitly in the law.
  Virtual campuses are excluded.
  Campuses with 0 Refined ADA are excluded.

Non-Enrolled Student UIL Activity Count:

Unduplicated count of students reporting in Summer PEIMS the E1739 – https://tealprod.tea.state.tx.us/TWEDSAPI/31/0/0/DataComponents/DataElements/List/11390

College Career and Military Readiness (CCMR) Outcome Bonus Counts:
There is a two year lag on this reporting for funding. Current SOF Year – 2, is the year of the Graduates that generate this funding.

Estimate header
- Counts are derived from the HB3 Outcome Bonus (CCMR) Funding Estimates report.
TEA header
- Counts are derived the TEA OUtcome Bonus (CCMR) Funding Report

Staff: Teacher Retention Allotment (TRA)

As of 25-26, new allotment based upon Fall PEIMS reporting of Staff data.
Most recent calculations are defined and details in https://kb.ondatasuite.com/knowledge-base/hb2-teacher-retention-allotment-estimates/

Features:

Filters:
- Year (multi-year select) (default is latest two years of Fall and Summer PEIMS data loaded beginning with the 25-26 school year)
- Campus (multi-campus selection option) *Not all District level calculations are feasible for funding at a Campus level per SOF definitions – these will be rows labeled N/A or greyed out.

Hide/Show Difference Columns (default is to display/show the Difference and % of Change columns between the years reported)
Show/Hide Weighted Rows (default is the Special Education Weighted FTE rows are hidden, select Show to display them on the report and Hide to toggle the details off). This toggle does not affect the Total Weighted Special Education FTEs row. It simply provides the details of the value reported.
Drilldowns will link to the source Finance – Summary of Finance (SOF) Reports – Student Funding Details Reports or Staff Funding Detail Reports where details such as by reporting period values, etc. are provided for the respective total.

Tools: