Management Report Library - Description of Reports

A brief description of each report is listed below.  The printable versions (PDF) contain detailed descriptions of the fields, or data contained on the report as well as step-by-step instructions on how to run the report.

Compensation Reports

• M001 - Employee Salary Information - PDF

Basic employee data (i.e. original hire date, current hire date, years of service) and basic job data (i.e. job title, grade, salary).
By Department/Program, Employee Name.

• M002 - Employee Salary Information -  PDF

Basic employee data (i.e. original hire date, current hire date, years of service) and basic job data (i.e. job title, grade, salary).  The only difference between this report and report M001 is the sort order.
By Employee Name.

• M007 - Position Control - PDF

Budgeted position information for the fiscal year and organization code selected.  Lists positions with budgeted amounts, along with the incumbent's name and annual salary (or Vacant).  A "difference" column displays the calculated difference between the budgeted amount and the annual salary.
By Organization, Position Number.

Demographic Reports

• M003 - Workforce Diversity - PDF

Employee job title, campus mail location, race and gender.
By Department/Program, Employee Class Type (i.e. staff, student, faculty), Gender and Race.

• M004 - Employee Demographics - PDF

Headcount and FTE.
By Department/Program, Employee Class Type (i.e. staff, student, faculty), Pay Type (i.e. exempt, nonexempt), Race, and Gender. 
Note:  From this summary level report you can view detailed information in any category by clicking on the bold/underlined headcount number.  If you change the format of the report to Excel, you will not be able to click on the headcount number to access the detailed report.

• M005 - Employee Demographics Detail - PDF

Employee name, demographic information, and position information.
By Department/Program, Employee Class Type (i.e. staff, student, faculty), Pay Type (i.e. exempt, nonexempt), Race, and Gender.  
Note:  This report is accessed via the headcount numbers shown on report M004.  It can also be run directly from the list of reports.

Employment Reports

• M006 - Employee Turnover - PDF

Headcount at the beginning and end of the date range selected and the turnover percentage for that time period. 
By Organization, Department/Program

• M008 - Employee Activity - PDF

Headcount within a position group (i.e. 112-Managers & Supervisors) at the beginning and end of the date range selected and the headcount by activity type (i.e. hires, promotions, demotions, reclassifications, and terminations) during that time period. 
By Department/Program.
Note:  From this summary level report you can view detailed information on any activity type by clicking on the bold/underlined headcount number.  If you change the format of the report to Excel, you will not be able to click on the headcount number to access the detailed report.

• M009 - Employee Activity Detail -  PDF

Employee name, race, and gender.
By Department/Program.
Note:  This report is ONLY accessed via the headcount numbers shown on report M008.

Supervisor Reports

• M010 - Employee Supervisor Information - PDF

• M011 - Employee Vacation Information - PDF

Vacation data (i.e. beginning balance+accrued, time taken, current balance).
By Department/Program, Supervisor, Employee.

• M012 - Position Budget - PDF

Position budget data.  Lists positions with budgeted amounts – by org code, fund and account.  This report does not contain the name of the person in the position.
By Organization Code, Fund, Account, Position.