/
TSDS - FTE - Calculated Full-Time Equivalents

TSDS - FTE - Calculated Full-Time Equivalents

Description of Issue

How does EERP data impact TEA's calcualted Full-Time Equivalents?

Context
  • Payroll
  • Financials
  • Texas
  • TX TSDS Reporting
Cause

When data is promoted, TEA calculates Full-Time Equivalents (FTEs) 

Resolution

The calculation uses the NumberDaysEmployed and PercentDayEmployed values reported from the EERP Staff Employment Period Record.

TEA calculation: 

Staff Payroll Calculated Values

Full-Time Equivalents (FTEs) are calculated in the following manner:

  • If NumberDaysEmployed is greater than or equal to 187, then FTE = PercentDayEmployed divided by 100.
  • If NumberDaysEmployed is less than 187, then FTE =

(PercentDayEmployed divided by 100) X (NumberDaysEmployed)

187

Base Salary is the total of all PayrollAmount where PayrollActivity is 80 (Base Salary).

FTE Salary is Base Salary divided by FTE.