Report Descriptions

Click here to go directly to Cognos to run a report

A brief description of each report is listed below.  The printable versions of the report descriptions contain more detailed information. 

Note: The database (ODS) used for Cognos reporting is refreshed nightly. The information contained in the HR Management reports reflects prior day's activity; current day activity is not included.  

M001 - Employee Salary Information - Sorted by Department/Program - MS Word or PDF
This report contains basic employment data (i.e. original hire date, current hire date, years of service) and basic job data (i.e. job title, grade, salary) sorted by department/program.

M002 - Employee Salary Information - Sorted by Name - MS Word or PDF
This report contains the same information as report M001 sorted alphabetically.

M003 - Workforce Diversity - MS Word or PDF
This report contains the job title and campus mail number for employees within a department/program grouped by employee class type (i.e. staff, student, faculty), by race, and by gender.

M004 - Employee Demographics - MS Word or PDF
This report contains the headcount and FTE within a department/program grouped by employee class type (i.e. staff, student, faculty), by pay type (i.e. exempt, nonexempt), by race, and by gender.  From this report you can "drill-down" to report M005 Employee Demographics Detail to see detailed information for the employees that are included in the headcounts shown on report M004.  Note: If you change the format of this report to Excel, you will not be able to "drill-down" to report M005.

M005 - Employee Demographics Detail - MS Word or PDF
This report contains the name and position number for the employees included in the headcounts shown on report M004.  This report is accessed via the headcounts shown on report M004 or it can be run directly from the list of reports.

M006 - Employee Turnover - MS Word or PDF
This report contains the headcount at the beginning and end of the date range selected and the turnover percentage for that time period.

M007 - Position Control - MS Word or PDF
This report shows budgeted position information (i.e. organization, fund, position number, title, grade) for the fiscal year and organization code selected.  For positions which are filled, detailed  employee information (i.e. name, UST ID, original hire date, grade) is listed.  

M008 - Employee Activity - MS Word or PDF
This report contains the 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.  From this report you can "drill-down" to report M009 Employee Activity Detail to see detailed information for the employees that are included in the headcounts shown on report M008.  Note: If you change the format of this report to Excel, you will not be able to "drill-down" to report M009.

M009 - Employee Activity Detail - MS Word or PDF
This report contains the name, UST ID, race and gender for the employees included in the headcounts shown on report M008 for a particular activity selected.  This report is accessed via the headcounts shown on report M008; it cannot be run directly from the list of reports.