Skip to main content Skip to main content

EDW Human Resources Report Catalog

This section of the Enterprise Data Warehouse Report Catalog contains reports specifically related to Human Resources.


Active Employee by Demographics

Displays active employees and identifying demographic information. The report groups employees by department and, subsequently, page breaks are applied for each college.

Link to Report   |   Report Details 


Active Employee by Department

Displays active employees and position information. The report groups employees by department and, subsequently, page breaks are applied for each college. This report specifically does not include demographic information so that the list can be shared across departments that are not privy to demographic data.

Link to Report   |   Report Details 


Active Employees with an Inactive Job

Displays inactive jobs of employees that are active with position information. The report groups jobs by department on the Summary Page and by Employee Sub Class on the Detail Page.

Link to Report   |   Report Details 


Active Employees - Admin

Displays active administrator classification employees and job information.

Link to Report   |   Report Details 


Active Employees – Faculty Tenure

Displays active Tenure and Tenure Track Faculty with information regarding demographics and tenure status.

Link to Report   |   Report Details 


Address by Employee Class

Displays addresses of active employees. Current campus box addresses are in one list and current PR addresses are in the second list. Addresses are grouped by department.

Link to Report   |   Report Details 


Citizenship Report

Displays all active employees and citizenship/visa information grouped by College and Department.

Link to Report   |   Report Details 


College/Dept and Class/Sub-Class

Lists Departments and Colleges in one tab and employee classes and sub-classes in another tab.

Link to Report   |   Report Details 


Comings and Goings

Lists employees that have either started a job or ended a job at the university during a user specified fiscal month and fiscal year. The reports are filtered to show specific employee classes, as well.

Link to Report   |   Report Details 


Employee Counts

Lists employees grouped by department, class and sub-class. Each group is counted individually.

Link to Report   |   Report Details 


Employee Detail

Lists employees grouped by college, department, and class. Each group is counted individually.

Link to Report   |   Report Details 


Employee Faculty Survey

Lists faculty grouped by college and department. Tenure Description and employee email are included. Each group is counted individually.

Link to Report   |   Report Details 


Employee List – Dashboard Link

Lists faculty grouped by college and department (page break for every department). Position and supervisor columns are included. Each group is counted individually.

Link to Report   |   Report Details 


Employee Profile - Demographics

Cross-tabulation of employees counted in each department by race/ethnicity.

Link to Report   |   Report Details 


Employee Salary

Lists positions and salaries grouped by sub class. Also aggregates salary information by sub class and graphs portion of total allocated to each college.

Link to Report   |   Report Details 


New Hire Demographics

Lists newly hired employees and demographic information grouped by college and department.

Link to Report   |   Report Details 


Student Worker Report

Lists student workers with pay rate information grouped by college and department on one tab and grouped by job on another. The last page of the report shows a summary of the students by Job Type and by number of Job types (if a student has the same job type in multiple departments, a job type is only counted once). The list of students is filtered on a Pay Period entered via prompt at runtime.

Link to Report   |   Report Details 


Termination Report

Lists employees that have been terminated in the prompted Fiscal Year period.

Link to Report   |   Report Details 


Hourly Rate by Pay Period and Earnings Type Report

Lists hourly rate in each pay period with Earning Code to differentiate different rates.

Link to Report   |   Report Details 


Years of Service and Age Report

Lists employees, their age and a system calculated Years of Service. Employees are grouped by College and Department.

Link to Report   |   Report Details 


Not Formatted Excel versions

The following reports have the same characteristics and fields as those in the “Public Folders ? Human Resources ? Human Resources – Formatted Webi Reports” location with the assumption that there is no formatting made to the reports. All reports in the Public Folders ? Human Resources ? Human Resources – Not Formatted Excel version” location are readily exportable to Excel.

  • Active Employee by Demographics-EXCEL
  • Active Employee by Department-EXCEL
  • Active Employee with Inactive Job-EXCEL
  • Active Employees – Admin-EXCEL
  • Active Employees – Faculty Tenure – EXCEL
  • Address by Employee Class-EXCEL
  • Citizenship Report-EXCEL
  • College/Dept and Class/Sub-Class-EXCEL
  • Comings and Goings-EXCEL
  • Employee Counts-EXCEL
  • Employee Detail-EXCEL
  • Employee Faculty Survey-EXCEL
  • Employee List – Dashboard Link – EXCEL
  • Employee Salary-EXCEL
  • New Hire Demographics-EXCEL
  • Student Worker Report-EXCEL
  • Termination Report-EXCEL
  • Hourly Rate by Pay Period and Earning Type-EXCEL
  • Years of Service and Age Report-EXCEL

Link to Report   |   Report Details 


Edit this page