Potential TRA Teacher PFTE Roster

Report Location: Staff > Staff Custom Reports > Teacher Retention Allotment (TRA) Reports > Potential TRA Teacher PFTE Roster

Summary: HB 2 established the Teacher Retention Allotment (TRA) for school systems to compensate and retain teachers beginning with 24-25. This report is to provide an audit review of all 087-Teachers (Role IDs/Staff Classifications) with their respective Years Professional Experience and Total Teacher PFTE.

Usage: Review report for staff reporting Role ID/Staff Classification 087-Teacher. The Role ID/Staff Classification PFTE is reported for each teacher as is the Years of Professional Experiece. Utilize to review any teachers not meeting the required (PFTE => .5) and verify all teachers are being reported.

Reporting as of 24-25 school year for review and projected estimates for 25-26 TRA implementation.

Data Sources: Fall PEIMS records (as of 24-25 school year)

• Staff Category
  • 30040 –Staff Domain > Staff Entity
  • 30050 – Staff Domain > StaffEducationOrganizatonEmploymentAssociation Entity
  • 30090 – Teaching and Learning Domain > StaffEducationOrganizationAssignmentAssociation Entity

Definitions:

• Years Prof Experience – The TotalYearsProfExperience (E0130) as reported on the 30040 (Staff Entity)
• Role Id/Staff Classification – (E0721) reported on 30090 (StaffEducationOrganizationAssignmentAssociation Entity)

Calculations:

• All Staff included where Role ID/Staff Classification (E0721) reporting is 087-Teacher.
  • The row is highlighted red if the Teacher PFTE< .5 Does not meet the funding eligibility PFTE.
• Total PFTE: (Partial FTE) is the per 30090-StaffEducationOrganizationAssignmentAssociation Entity FTE calculated as the portion of the Total Employee FTE that is spent in the specific role. Reference TEA TIPS for Calculating Staff FTEs for details on the Instructional Partial FTE calculation. 
  • Employee FTE determines if full-time or part-time staff and based upon 30050 – StaffEducationOrganizationEmploymentAssociation Entity
    • If the NumberDaysEmployed (E0160) is greater than or equal to 187, the FTE is a the PercentDayEmployed (E0760) divided by 100 (rounded to two decimal places).
    • If the NumberDaysEmployed (E0160) is less than 187, the FTE is (PercentDayEmployed (E0760) / 100) x ( NumberDaysEmployed (E0160)) all divided by 187 (rounded to two decimal places)

Features:

• Filters: Years -Default is the latest Fall Staff PEIMS year data loaded.
• Filters: District or Campus – can be run at the district level or for a single campus. Default is district level report.
• Filters: Years Prof Experience – Default report is all Years of Professional Experience and can be filtered to a subset.
• Drill down on Tx Unique Staff ID to review Staff Profile of all staff detailed reporting.

Tools Menu:

• Export to Excel
• Bookmark – https://kb.ondatasuite.com/knowledge-base/bookmarking-a-report/
• Report Notes