Welcome to Business Intelligence Services' Content Catalog.

This is a weekly report generated for the Asset Management Committee to track university assets impacted by terminations.

CLICK HERE TO VIEW CONTENT

The Attainment & Cash report provides a summary view of fundraising performance by fiscal year. This dashboard allows members of Development and Alumni Relations (DAR) to quickly and easily view transactional data by a number of different metrics. Furthermore, this dashboard displays data either in the context of Total Attainment or Cash Received by the university on an annual basis. By presenting historical data in a graphical format, department leadership can use previous strategies and events to make better-informed future business decisions.

Attainment & Cash - Power BI Attainment and Cash - Power BI

This report identifies the current Max Effective date per Benefit or Deduction Code of all  active employees.

CLICK HERE TO VIEW CONTENT

List all GW Employees included under the Base Employee Class code F1, F2, F3, F4, F5 or F6, chosen by effective date.

CLICK HERE TO VIEW CONTENT

List all employees under Benefit or Deduction code FHI, FIM, or FIO considering the last effective date as of today (All future effective dates are not considered). Shows the Benefit Status and Effective dates.

CLICK HERE TO VIEW CONTENT

This yearly audit report lists all employees under Benefit or Deduction code FHI, FIM, or FIO. The Max Effective Date for this report is defined by Employee, Benefit or Deduction, and Reference Number. The result can be filtered by the value of Max Effective Date, including Nulls.

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code FIM considering the last effective date as of the date the reports runs (All future effective dates are not considered). Shows the total Earned and the Pay calendar sequence. 

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code FIT. Filters for this report Are Base Employee Class Code and Benefit Status. 

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code FIO. Filters for this report Are Base Employee Class Code, Benefit Status, and Citizen Type.

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code FIT. Filters for this report Are Base Employee Class Code and Benefit Status. 

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code GFT and no filters.

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code FIT. Filters for this report Are Base Employee Class Code, Reference Number, Benefit Status, and I9 Status. While very similar to the FIT with Reference Field - No Teraty Report, the detail changes for the purpose.

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code PK1, PRK. Filters for this report Are Base Employee Class Code and Benefit Status. 

CLICK HERE TO VIEW CONTENT

List all employees under every Benefit or Deduction code where the effective date is greater than the one the user chooses. These benefit or deduction codes are SNP, SMP, SMS, SMT, FMP, FSP, FST, SNS, and SNT. The user could see each one independently or in groups.

CLICK HERE TO VIEW CONTENT

List of all employees includeded only in Benefit or Deduction Code UCA, UCO, UCT, UDC, UDE, UFL, UGA, UIL, ULA, UMA, UMD, UMI, UMN, UNC, or UNJ

CLICK HERE TO VIEW CONTENT

List Employees under the Benefit or deduction codes PCT and UCT, includes only Active Employees where the Latest Effective Date = Max Effective Date as of Today.

Listing of employees under Benefit or Deduction Code equal to UWY

CLICK HERE TO VIEW CONTENT

This report provides a listing of mismatches on the fields Position Group Codes, Table and Grade between NTRPCLS, NBBPOSN and NBRJOBS tables in Banner

CLICK HERE TO VIEW CONTENT

This report will list the valid awards along with their CFDA number and purpose code. Filters for the award status and close date are available on the report for the user. 

CLICK HERE TO VIEW CONTENT

This report allows users to create custom reports using "Award Management - Award Installments" data set

CLICK HERE TO VIEW CONTENT

This report allows users to create custom reports using "Award Management - Award Personnel" data set

CLICK HERE TO VIEW CONTENT

The report is a  listing by creation date of awards that include relevant information like Banner index and important dates. The report contains 4 basic filter for Organization Code and Award Creation, Start and end Dates.

CLICK HERE TO VIEW CONTENT

This dashboard contains three reports: NBAJOBS, PHAREDS and PHICHECK for employees who are compensated on sponsored projects. NBAJOBS will allow GCAS users to view employee job detail information, such as position number, salary information, status, job title, change reason, and activity date. PHAREDS will allow GCAS users to view employee labor distribution information, such as earn code, transaction date, amount, hours, percent. PHICHECK will allow GCAS users to view what was paid to employees, such as gross income, hours worked, rate, net income, amd deductions.

CLICK HERE TO VIEW CONTENT

This report provides a medium for generating lists of detail codes. Filters allow for narrowing result-set by any combination of Detail Code, Detail Category code, Account A, Account Index A, Account B, Account Index B or Active Indicator.

CLICK HERE TO VIEW CONTENT

BE Secondary no BE Primary is a dashboard that displays an employee who holds a secondary Benefit eligible position but has no benefit eligible primary position

CLICK HERE TO VIEW CONTENT

This report provides employee benefit category deduction frequency along with the payroll frequency. This will allow Benefits team to identify any employees who have deduction frequency different from pay frequency.

CLICK HERE TO VIEW CONTENT

This report displays employees who's benefit eligible job is on leave but there is a benefit eligible secondary job that is active. 

CLICK HERE TO VIEW CONTENT

This report displays a list of benefit eligible employees including benefit category and W4 addresses. There is filtering for Benefit Category Code and W4 State code.

CLICK HERE TO VIEW CONTENT

Benefit Eligible Employee Count by Building is a report which list all benefit eligible employees, full time or part time by their position location and address by headcount. 

CLICK HERE TO VIEW CONTENT

Benefit Eligible Employees Earning < is a dashboard that lists employees who annual salary is less than the amount specified. 

CLICK HERE TO VIEW CONTENT