Teacher FTE Total Years Professional Experience

Report Location: Staff > Staff Custom Reports > Teacher Summary Reports > Teacher FTE by Total Years Professional Experience in Core Subjects

Summary: This report displays teacher toal years of professional experience ranges by core subjects with FTE counts and percentages for multiple years along with graphical representations of the data.

Usage: Use this report to analyze teacher year’s experience rates by core subjects at the district or campus level. Classifications align to the TAPR reporting of this data. *Note calculations may vary to TAPR due to variances in data sets, rounding, etc.

Data Source(s): PEIMS Fall records

As of 2024-25 Ed-Fi data submission:

Staff Category:

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

As of 2023-2024 XML/CSV data submission:

• Interchange Staff
  • 30040 – Staff Extension Complex Type
  • 30050 – Staff Education Org Employment Association Extension Complex Type
  • 30090 – Staff Responsibilities Extension Complex Type

Definitions:

• Teachers Only – Role ID E0721 = 087 or 047
• Years of Professional Experience – E0130
  • Beginning Teachers – E0130 = 00
  • 1-5 Years Professional Experience – E0130 Between 01 and 05
  • 6-10 Years Professional Experience – E0130 Between 06 and 10
  • 11-20 Years Professional Experience – E0130 Between 11 and 20
  • 21 – 30 Years Professional Experience – E0130 Between 21 and 30
  • Over 30 Years Professional Experience – E0130 > 30
  • Total Teacher FTEs – All teachers for all Years of Professional Experience
• Subjects – Uses predefined table with core subjects attached to teacher responsibilities service IDs (E0724) ,

Calculations:

• FTE Count – Uses 30090-Responsibilities records to calculate PFTE based on core subject type
  • Partial FTE (PFTE) 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
• Percentages
  • By Years of Experience = (Teacher FTE Count / Total Teacher FTEs) * 100
  • By Core Subjects
    • All Core Subjects = (Teacher FTE Count for All Core Subjects / Total Teacher FTE Count for that experience range) * 100
    • Each Subject = (Teacher FTE Count / Total Teacher FTE Count for that experience range) * 100

Features:

• Filter on:
  • Multiple Years (Default most recent 3 years)
  • Multi-select Campus (Default All campuses)
• Graphs
  • Pie Graph
    • Year Selector
    • Print/Download
    • Drill down on Years of Professional Experience ranges to see Subject percentages
  • Line Graph to compare multiple years of experience range percentages
    • Print/Download
• Drill down on FTE counts to see detailed list of teachers with their service IDs and Years of Experience

Special Notes:

• Drill down staff detailed list totals will typically be higher than the FTE counts since the FTE count is calculated using the 30090 records. Teachers who are not teaching that subject 100% will have a lower FTE count calculation, but will still count as 1 in the detailed staff list.
  • For example, elementaries where teachers have all 4 core subjects in their responsibility records will be split on their FTE calculation between the 4 core subject types which lowers the FTE count considerably.