Information Technology Services
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