Emory Business Intelligence introduces a new report named “Effort Salary Cap Report”.   The DHHS salary cap is a legal requirement limiting the direct salary that an individual can receive from a DHHS grant.  When an Individual’s institutional base salary exceeds the cap, the difference between that individual’s actual salary and the maximum amount allowed under the cap is cost shared from non-sponsored accounts.  The annual salary cap amount is adjusted by DHHS every year.

There are two tabs on this report.  The Charged Salary Cap Report returns data charged to your own department SK.  The Managed Salary Cap Report includes data charged to another department’s SK.

To run the report, following mandatory fields will need to be populated:

• The Report Begin Date and Report End Dates:The dates can be the same dates as the effort periods or annual dates.
•  The Charged Department:  Charged Department can be the primary department or any other department depending on your labor access.
•  Employee:  You can choose a single employee id or (All Column Values).

The Effort Salary Cap Report provides us the following information:

• Primary Sponsor ID/Name: Name of the primary sponsor
• Agency Name Agency Name associated with the sponsor
• Salary cap Indicator: ‘YES’ if salary cap applies, ‘NO’ if salary cap does not apply
• Award Salary Cap Amount Maximum annual amount associated with that award
• Committed Effort % of time agreed upon
• Certified Effort % of estimated time spent on project
• Capped Max Pay Amount Max pay on that project for that period
• Variance (Above Cap)/ This is the amount that needs to be Cost Shared if “Above Cap”
• Below Cap ($)

This report shows all the employees in your department by Award and project level.  The maximum annual amount paid will be listed depending on the year the award was issued.  The salary cap calculates the maximum amount an employee can charge per effort reporting period.  The administrator should review amounts under the variance column to ensure that sufficient cost sharing or cost transfer has been processed.  This report also compares committed effort and certified effort percentages by effort reporting periods.   You can run this report by Project, Award, Employee ID, Charged Operating Unit or Charged Department.

For questions or help using this report, please contact James Goff at jbgoff@emory.edu, or Rubena Bedi at rmayer2@emory.edu.

James Goff
Interim Director for Cost Studies