Effort Reporting at UTHealth

Salary Cap Calculations

The salary cap amount for each half year is calculated as follows:

CAP = $199,700

NOTE:  There will be a second federal cap applicable to the effort report due to federal legislation lowering the cap maximum to $179,700, and it will affect effort reporting beginning on the 7/12 report.  We will have more information on that in the near future.  Thank you.

January – June = 181 days (182 if leap year)
July – December = 184 days

$199,700/365 days = $547.12/day

$547.12/day x 184 = $100,670.08 (salary cap amt. for 6 month period July – Dec.)
$547.12/day x 181 = $  99,028.72  (salary cap amt. for 6 month period January – June)

  • These calculation amounts could vary slightly due to rounding each period.  If you hover over the CAP?  mark for a project on the effort report, you can see exactly what amount is being used each period.
  • This is the amount that the percentage of actual pay, which is based on the cap, is being calculated against.  It will, with small variance, again due to rounding, match the Effort Report Worksheet final figure.
  • The system now also calculates the minimal cost share by using the actual salary amount before the cap to calculate, in essence, what the pay would have been without the imposed cap.
  • To get total salary for an individual in ECRT, go to the Certification Payroll Report.  Double the total at the bottom of the report, for example:  $142,695.48 = ~ ½ of total base of $285,391.

Effort Calculation

Individuals with 1 FTE, which is the majority, will have the difference between the cap paid amount, and what should have paid calculated as follows:

$142,695.48 = ~ ½ of total base of $285,391 (4 cent difference due to HCM systemic rounding).  This is the amount used to calculate the cost share portion in the system.

$142,695.48 x 3.49% adjusted pay = $498,007.23/$100,670.08 (salary cap maximum amount of pay)
                                                                    = 4.946%
(4.95% rounded).

4.95% - 3.49% = 1.46%

1.46% is, then, the minimum effort adjustment needed.  Obviously, this can be more depending on amount of effort actually committed.  (E.g., 5% was actual vs. 4.95%)

Should there be an occurrence of an individual less than 1.0 FTE, the system calculates what their salary would be at 1.0 in order to be able to ascertain this adjustment.  For example:

Annual Base Salary = $200,000
FTE = 0.75
Salary Cap = $199,700
Amount of actual pay against salary cap in system = 10%
$200,000/.75 = $266,667 (Adjusted amount salary would be if 1.0 FTE)

$266,667*.10 (% paid in system) = 26,667/$199,700 (salary cap) = .1335 or 13.35%

13.35%-10% = 3.35%

3.35% is, then, the minimum effort adjustment needed.  Again, this can obviously be more depending on amount of effort actually committed.