Financial Integrity Rating System Of Texas (FIRST) Aide

Summary: This report uses PEIMS information to provide financial data for indicators 5, 11, and 12 on the School FIRST template. It requires PEIMS Mid-Year and Fall submission files (multiple years) to be loaded to the File Center.

Usage: This aide can be used to input PEIMS data into the TASBO School FIRST Template (FY 2017 – FY 2019). Use data in blue.

Data Sources:

• PEIMS Fall for Student and Staff Data
  • Interchange Student
    • 40110-Student School Association Extension
  • Interchange Staff
    • 30040-Staff Extension
    • 30050-Staff Education Org Employment Association Extension
• PEIMS Mid-Year for Financial Data
  • Interchange Finance Extension
    • 20032-Actual Extension

Definitions:

• Indicator #5 – Uses fall snapshot enrolled students for the specific years
• Indicator #11 – Uses mid-year reporting matching to the year drop-down selected. Please note this pulls the actual data for the year selected in the drop-down.
  • Example: 2017-2018 drop-down year selected uses PEIMS mid-year reporting for 2018-2019 that contains 2017-2018 actual financial data.
    • First column of input data:
      • E0317 – Functions 11, 12, 13, 21, 31, and 41
      • E0316 – Fund 199
      • E0318 – Object 61XX-64XX (includes 6144)
    • Second column of input data:
      • E0317 – Functions 11, 12, 13, 21, 31, and 41
      • E0316 – Fund 199
      • E0318 – Object 6144
• Indicator #12 – Uses fall snapshot enrolled students and staff
  • Staff is calculated according to FTEs

Features:

• Filter on a specific year
• Drill down on student or staff counts to see detailed lists

Resources for qualifications and calculations:

TEA Reporting:

• Financial Integrity Rating System of Texas

TASBO FIRST template:

• https://www.tasbo.org/resource/tools-templates/schools-first