Welcome to Business Intelligence Services' Content Catalog.

The Headcount Summary tab of the Headcount for Benefit Eligible Employees and Open Positions Dashboard provides a high-level view of employee headcounts and annual salaries by employee type for all Benefit Eligible primary jobs. The data is displayed for the past 3 fiscal years including the current fiscal year as of July 1 of each fiscal year. There is also data as of COB of the previous day.  Postdocs are excluded beginning FY2022 (Postdocs are captured within the Research category prior to FY 2022).

CLICK HERE TO VIEW CONTENT

HERD Employees Paid

CLICK HERE TO VIEW CONTENT

HERD Loading - Award Expenditure Base

CLICK HERE TO VIEW CONTENT

HERD Loading - New Expenditure Type

CLICK HERE TO VIEW CONTENT

Report used for HERD data loading that contains award details by PTA

CLICK HERE TO VIEW CONTENT

HERD Loading - URIDC by PTA

CLICK HERE TO VIEW CONTENT

HERD Passthrough Sub Data

CLICK HERE TO VIEW CONTENT

HERD Project Details for Classification with Expenditures

CLICK HERE TO VIEW CONTENT

HERD Sponsors for Classification

CLICK HERE TO VIEW CONTENT

List of all employees that are part of the Online Learning (eCLASS)  programs, including regular rates and annual salaries therefore, this report is highly confidential. 

CLICK HERE TO VIEW CONTENT

List of employees that are part of the Online Learning (eCLASS)  programs considering only Base Employee Class Code  U1 and U5, including regular rates and annual salaries; therefore, this report is highly confidential. 

CLICK HERE TO VIEW CONTENT

This build your own report contains all of the necessary data to identify employees and relevant human resources data points related to the hr benefits published model. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. This is part of the HR: Build Your Own Reports porfolio.

CLICK HERE TO VIEW CONTENT

Provides a listing of certifications by HR Reporting unit  for an employee based on activity dates selected. 

CLICK HERE TO VIEW CONTENT

This is a report of employees active as of date entered into the dashboard parameter. The columns are in a specific order to be used by HR Compensation reporting.

CLICK HERE TO VIEW CONTENT

This report shows GW active budgeted positions by job family and classification with salary metrics and count of filled/unfilled jobs associated with each classification.

CLICK HERE TO VIEW CONTENT

This report reflects all positions where 'position fy active ind' = Y and 'budget status code' = A and 'position status code' = A. Filtering by classification code, job family and position type are avaialble.

CLICK HERE TO VIEW CONTENT

This report lists all Earnings from Earn Type Codes RPF, RPB and BON with a filter for transaction begin and end date. In addtion to the Detail report, there is a pivot formatted, Matrix report available.

CLICK HERE TO VIEW CONTENT

Subset of Payroll Labor Distribution dataset that filters on employee class code 'W1', 'W4', 'W5'

CLICK HERE TO VIEW CONTENT

This build your own report contains all of the necessary data to identify employees and relevant human resources data points related to non-payroll labor distribution. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

CLICK HERE TO VIEW CONTENT

This build your own report contains all of the necessary data to identify faculty employees and relevant human resources data points specifically relatedto payroll labor distribution. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

CLICK HERE TO VIEW CONTENT

This build your own report contains all of the necessary data to identify employees and relevant human resources data points related to payroll labor distribution. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

CLICK HERE TO VIEW CONTENT

HR Payroll Reconciliation - Build Your Own Report contains all the necessary fields to identify employees and data points related to payroll.  This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

CLICK HERE TO VIEW CONTENT

This report populates performance review details based on a review date range. Filters for Home Reporting Unit, Banner Home Org, GWID and review rating description are available.

CLICK HERE TO VIEW CONTENT

This build your own report contains all of the necessary data to identify faculty employees and relevant human resources data points. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

CLICK HERE TO VIEW CONTENT

This build your own report contains all of the necessary data to identify employees and relevant human resources data points related to HR position salary. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report.

CLICK HERE TO VIEW CONTENT

This report identifies each employee by his/her Organization unit and job location by city and state. Filters for this report are Base Employee Class Code and HR Reporting Unit Description.

CLICK HERE TO VIEW CONTENT

This dashboard includes both the I50 Imputed Income Analysis Dashboard and the Salary Change Dashboard.  User can review the salary change for a specific employee by selecting the record on I50 Imputed Income Analysis Dashboard and follow the link to Salary Change report. The I50 Imputed Income Analysis dashboard provides the monthly I50 deduction along with several indicators that will help determine the need for I50 adjustment for the employee.   The Salary Change dashboard provides information on the salary changes for employees.   

CLICK HERE TO VIEW CONTENT

The IDC Analysis Dashboard includes four tabs: TDC-MTDC-IDC by Schools, Indirect Cost Recovery, TDC MTDC IDC Details, and Sub MTDC Details. TDC-MTDC-IDC by Schools dashboard provides an overview of costs incurred within the selected GL Date range in different categories for each school. GW Funds and 3rd Party Gifts includes all the costs related to IXXS awards, while Direct/Indirect Cost from Sponsor includes all the costs from non IXXS awards. Total Cost is all the cost incurred during the GL Date ranges. The GW Funds & 3rd Party Gifts % is the percentage of total GW Funds & 3rd Party Gifts over the Total Cost. MTDC is MTDC (generic) that includes all non costshare expenses but removed 2 CFR 200 exclusions such as patient care, subcontracts in excess of $25,000, capital expenditures, tuition/stipends, and facility rental from direct cost etc. IDC is all the indirect cost incurred during the GL Date range. Residual Funds is cost charged to account 58952. Weighted Avg Recovery is the percentage of Total IDC Cost divided by the MTDC Cost. Indirect Cost Recovery Dashboard has three reports. One is Indirect Cost Recovery, which provides the Indirect Cost, MTDC, and the Percentage of Indirect Cost Recovery by Entity. The second one is Indirect Cost Recovery by IDC Category, which provides the IDC, MTDC, Percentage of Recovery by IDC Category and Entity. The last one is Indirect Cost Recovery - MTDC Analysis report. This report breaks down the expenditures in GCAS defined categories for each entity. TDC MTDC IDC Details and Sub MTDC Details have detail transactions for the summary report.

CLICK HERE TO VIEW CONTENT

IDC Check for CCAS

CLICK HERE TO VIEW CONTENT

This dashboard is to assist the GCAS team in the monthly billing. It includes two sub dashboards. One for CCNS awards and one for Event awards. This report is to allow GCAS billing specialist to review the unbilled awards before the automated invoice generation program runs.

CLICK HERE TO VIEW CONTENT