1. Home
  2. Summary of Finance (SOF) – Student Data Summary

Summary of Finance (SOF) – Student Data Summary

Summary: This report is intended to provide a single report view of the Student PEIMS Data required for completion of the Summary of Finance(SOF) templates: TEA State Aid Template 2022-2025 or Omar Garcia’s SOF template

Usage: Use aide to review and complete the student inputs for the Summary of Finance (SOF) templates.  The report layout follows the TEA State Aid Template which closely aligns to Omar’s template.   The report is a monitoring tool for current year projections as of latest required data sources loaded in ODS.  A 2 year view is provided for tracking last year to current year changes.  

No drilldowns are provided on this report layout.  For additional analysis with filters and drilldowns, utilize the Finance : Summary of Finance (SOF) Reports – Student Funding Detail Reports for the respective data set.

Data Source(s):

Fall PEIMS

  • Interchange Student Extension
    • 40100 – Student Basic Information
      • TX-Student Characteristics Type Sub-Category
  • Interchange Student Enrollment Extension

Summer PEIMS

  • Interchange Student Program Extension
    • 40110 Student Program Extension Complex Type
      • Dyslexia Services Code (E1650)
      • Gifted Talented Indicator Code (E0034)
  • 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
      • CTE Attendance Multiplier subcomplex
  • Interchange Student Enrollment Extension
    • 40110 – Student School Association Extension Complex Type
  • Interchange Student Transcript Extension
    • 43415 Course Transcript Extension Complex Type

Calculations:

Rows with grey boxes in the values are not calculated at this time.

All values are rounded to 3 decimal places.


Refined ADA – (Sum of all students’ total eligible days present (E0937) (includes RA total eligible days (E1679) and RS total eligible days(E1678) from 42400 Basic Reporting 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 upload).


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

  • RA/RS included:
    • Days Eligible by instructional Setting code = Total Days Eligible)E0937) + RS Total Days Eligible (E1678) + RA Total Days Eligible (E1679)
    • Excess Hours in Instructional Setting code = Excess Hours in Instructional Setting(E0945) + RS Excess Hours in Instructional Setting (E1694) + RA Excess Hours in Instructional Setting (E1695)
  • 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.

Special Education Mainstream ADA:

  • ADA by six weeks – (Sum of all students’ total eligible days present (E0940) (includes RA (E1689) and RS (E1688) eligible days present ) 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 upload)

Dyslexia Student Count:

  • Unduplicated count of students receiving at least one Dyslexia Service as reported on Dyslexia Services Code (E1650)

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)
  • 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.

 FTE per Tier

  • Career & Technical Education FTE = Total Contact Hours / (DAYS_TAUGHT * 6)
    • Contact Hours = (Eligible days present V1…V3 (E0950…E0952) + RS Eligible days present V1…V3 (E1696…E1698) + RA Eligible days present V1…V2 (E1702…E1704) * 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 Enrollment

  • Total = Count of P-Tech Indicator (E1612) students reported in Fall PEIMS by campus

New Tech Network (NTN) Enrollment

  • Total = Count of New Tech Indicator (E1647) students reported in Fall PEIMS by campus  

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 Group Mapping for 20xx State Funding reference in the District and Planning Tools subsection on the State Funding website provided by TEA to link the Census Block Group (E1648) to the reported SES Tier.

All Homeless Students (E1082) (C189) = 2, 3, 4 or 5 student’s assigned to Tier 5 funding effective 2020-2021

Compensatory Education Pregnant FTE   (Pregnancy Related Services (PRS) FTE):

PRS FTE is calculated as the sum of total pregnancy-related services days eligible (E0939) (includes RA PRS days eligible (E1687) and RS PRS days eligible (E1686)) 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: Averageof the six weeks FTE calculations.

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.

Gifted and Talented count:

The student count eligible for G/T Allotment Funding.

Student Count: Participating in Gifted/Talented Program – count of students reporting participating (1) in Gifted-Talented-Indicator-Code 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.

Bilingual/ESL ADA:

  • Bilingual/ESL ADA – Not in Dual Language Program ADA calculation for students identified as (Bilingual (E1042) = 2 or 3) OR as ESL (E1043) = 2 0r 3) OR as Alt Language (E1642) = 01 or 02) AND the student is LEP (E0790) = 1
    • Special Program ADA calculation for selected students’ eligible Bilingual/ESL days present (E0938) from 42401 Special Programs Attendance.
  • Bilingual – Dual Immersion – LEP ADA calculation for students identified as Bilingual (E1042) = 4 or 5 AND student is LEP (E0790) = 1.
    • Special Program ADA calculation for selected students’ eligible Bilingual/ESL days present (E0938) from 42401 Special Programs Attendance.
  • Bilingual – 2 way Dual Immersion – Non LEP ADA calculation for students identified as Bilingual – 2 way Dual Immersion (E1042) = 4 AND the student is non-LEP (E0790) = 0, F, S, 3, 4 or 5) *Note: these students classified as Non-LEP report 42400 Basic Attendance and not 42401 Special Program Attendance.
    • Basic Attendance ADA calculation for selected students.

Early Education Refined ADA District Summary:

 HB3 funding for grades K-3 only. Students may be duplicated counted.

  • 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 students: Students classified as LEP (E0790) = 1 and in grade K-3.
    • Basic Attendance ADA calculation for selected students.
  • Total: Sum of K-3 Educationally Disadvantaged students ADA and K-3 Limited English Proficient students ADA.

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) including RA and RS eligible days (E1685 and E1684) from 42401 Special Programs Attendance.

Resources for Calculations: TEA HB3 Resource page: https://tea.texas.gov/About_TEA/Government_Relations_and_Legal/Government_Relations/House_Bill_3

Updated on 04/12/2022

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support