Teacher Roster – TRA Years Experience & Base Salary Verification

Report Location: Staff > Staff Custom Reports > Teacher Retention Allotment (TRA) Reports > Teacher Roster – TRA Years Experience & Base Salary Verification

Summary: HB 2 established the Teacher Retention Allotment (TRA) for school systems to compensate and retain teachers as of 25-26 TRA eligibility. This report is to provide an audit review of all 087-Teachers (Role IDs/Staff Classifications) roster details related to their Years TRA Teaching Experience, LEA Determined TRA Eligibility, Base Salary and other related criteria.

Usage: Review report for staff reporting details related to TRA qualifications on all Role ID/Staff Classification 087-Teacher. Report includes existing Years of Professional Experience and Years in District for comparision to the new Years TRA Teaching Experience reporting. Additional the current Year Base Salary on the Teacher is reflected AND the Prior Year Base Salary is reported with a difference for verification of staff TRA required increases if their LEA Determined TRA Eligibility is Yes(true). The teacher responsibility partial FTE and total Monthly Minutes is included for data integrity checks on the LEA Determined TRA Eligibility.

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

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

Definitions:

• Years Prof Expr – The TotalYearsProfExperience (E0130) as reported on the 30040 (Staff Entity)
• Yr Expr in District – The YearsExperienceInDistrict (E0161) as reported on the 30040 (Staff Entity)
• Years TRA Teaching Experience – New reporting as of 25-26: (E3129) as reported on the 30040 (Staff Entity)
• LEA Determined TRA Eligibility – New reporting as of 25-26: (E3130) as reported on the 30040 (Staff 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 OR the Teacher Total Monthly Minutes < 4, 800. Does not meet the funding eligibility definition.
    
• Prior Year Base Salary – Previous school year to the year selected in the filter: Sum Payroll Amount (E0425) where Payroll Activity (E0424) = 80 (Base Salary).
• Base Salary as of the school year selected in the filter: Sum Payroll Amount (E0425) where Payroll Activity (E0424) = 80 (Base Salary).
  
• Base Salary Difference = Base Salary minus Prior Year Base Salary
• 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)
• Total Monthly Minutes is the sum of Teacher Responsibility Records (E0721 = 087) Monthly Minutes (E1057)
• Totals – A summary total row at the end of the list for each of the columns as appropriate.
  

Features:

• Filters: Years -Default is the latest Fall Staff PEIMS year data loaded. (Earliest year report available is 2025-2026)
• Filters: District or Campus – can be run at the district level or for campus level. Default is district level report. This is a multi-select filter when selelcting campuses.
• Filters: Years TRA Teaching Experience – Default report is all Years TRA Teaching Experience and can be filtered to a subset.
• Filters: Focus List (Optional) – reference KB for details on creating and using Focus List
• 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/
• Print Staff Profile – CAUTION: Maximum 1,000 records may be printed at one time. https://kb.ondatasuite.com/knowledge-base/printing-staff-profiles/
• Report Notes