/
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.
Additional Information