Welcome to Business Intelligence Services' Content Catalog.

The catalog provides a way to find reports, dashboards, and associated business terms across the university's data domains. You must be connected to GW's VPN to access the links in this catalog.

For an explanation of the filters, see the catalog's glossary of terms.

Displaying 61 - 90 of 510

Data Domain
Community
Tags
Status
Reporting System
Asset Management Weekly Report - Job Changes
Created Apr 03, 2023 4:17 pm
Status Certified

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

Data Domain

Human Resources

Community

Human Resources

Intended Audience

Asset Management Committee

Reporting System

Power BI

Asset Management Weekly Report - New Hires & Rehires
Created Apr 03, 2023 4:08 pm
Status Certified

This is a report that is reviewed weekly by the Asset Management Committee to plan computer and other needs of hires and new hires at the university. 

Data Domain

Human Resources

Community

Human Resources

Intended Audience

Asset Management Committee

Reporting System

Power BI

Asset Management Weekly Report - Terminations
Created Apr 03, 2023 4:34 pm
Status Certified

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

Data Domain

Human Resources

Community

Human Resources

Intended Audience

Asset Management Committee

Reporting System

Power BI

Attainment & Cash
Created Mar 31, 2023 12:35 pm
Status Candidate

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.

Data Domain

Advancement

Community

Development and Alumni Relations (DAR)

Intended Audience

Development & Alumni Relations (DAR)

Reporting System

Power BI

Audit - All States - Deduction Code with Ref. field and Max Eff. date
Created Jul 05, 2023 2:18 pm
Status Certified

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

Data Domain

Human Resources

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - Faculty and Parking
Created Jul 05, 2023 2:39 pm
Status Certified

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

Data Domain

Human Resources

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - FICA with Reference (FHI-FIM-FIO)
Created Jul 18, 2023 3:53 pm
Status Certified

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.

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - FICA Year End with Reference (NR to RA)
Created Jul 18, 2023 4:02 pm
Status Certified

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.

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - FIM Deductions (MO for FICA)
Created Jul 05, 2023 3:32 pm
Status Certified

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. 

Data Domain

Human Resources

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - FIO with Deduction Code, Reference, and Max Effective Date
Created Jul 18, 2023 4:06 pm
Status Certified

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

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - FIT set up for NI (Indicator 2c)
Created Jul 18, 2023 4:15 pm
Status Certified

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

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - FIT with Reference Field - No Treaty
Created Jul 18, 2023 4:21 pm
Status Certified

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

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - GW Gift Deduction GWeb Report
Created Jul 18, 2023 4:28 pm
Status Certified

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

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - NRA Indicator
Created Jul 18, 2023 4:33 pm
Status Certified

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.

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - Parking with Deduction Code, Reference, and Max Effective Date
Created Jul 18, 2023 4:39 pm
Status Certified

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

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - Smart Trip
Created Jul 18, 2023 4:46 pm
Status Certified

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.

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - UI Codes
Created Aug 22, 2023 1:14 pm
Status Certified

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

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - Unemployment Codes Missing Secondary Codes
Created Aug 22, 2023 1:18 pm
Status Certified

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.

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - UWY with Reference
Created Jun 26, 2023 4:48 pm
Status Certified

Listing of employees under Benefit or Deduction Code equal to UWY

Data Domain

Human Resources

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit - Work Locations
Created Jan 23, 2024 3:00 pm
Status Certified

This is an HR Payroll report that shows an audit of work locations for selected base employee class codes where benefit or deduction code does not contain 'UPL', employment status is active, benefit deduction type code is 06, and benefit status is E or A.

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

Audit Report for Mismatches between NTRPCLS, NBBPOSN and NBRJOBS
Created Jan 21, 2021 11:19 am
Status Certified

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

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Power BI

Tags

HR

Award CFDA and Purpose code
Created Oct 09, 2019 3:59 pm
Status Certified

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. 

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS team

Reporting System

Tableau

Tags

FINANCE

Award Installments - Build Your Own Report
Created Jul 06, 2023 4:01 pm
Status Certified

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

Data Domain

Human Resources

Community

Office of the Vice President for Research (OVPR)

Intended Audience

OVPR, Finance

Reporting System

Power BI

Award Personnel - Build Your Own Report
Created Aug 01, 2023 2:40 pm
Status Certified

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

Community

Office of the Vice President for Research (OVPR)

Intended Audience

OVPR, Finance

Reporting System

Power BI

Tags

FINANCE, OVPR

Award Proposal - Build Your Own Report
Created Jan 12, 2024 9:35 am
Status Certified

This build your own report contains all of the necessary data relevant to award proposals. 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. 

Community

Office of the Vice President for Research (OVPR)

Intended Audience

OVPR

Reporting System

Power BI

Award Proposal Detail - Build Your Own Report
Created Jan 29, 2024 12:18 pm
Status Under Review

This build your own report contains all of the necessary data relevant to award proposals. 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 OVPR Portfolio.

Community

Data Governance Council

Intended Audience

OVPR

Reporting System

Power BI

Award Set Up Timing
Created Jun 06, 2023 5:43 pm
Status Certified

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.

Data Domain

Research

Community

Office of the Vice President for Research (OVPR)

Intended Audience

Award Management

Reporting System

Power BI

Tags

Award_Management

Banner Audit Reports
Created Nov 06, 2019 4:54 pm
Status Certified

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.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

Banner Detail Codes List
Created Jul 17, 2018 2:37 pm
Status Certified

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.

Data Domain

Academics

Community

Student Accounts

Intended Audience

Student Accounts, University Accounting Services, SAIG, Comptroller Group

Reporting System

Tableau

Tags

FINANCE

BE Secondary no BE Primary
Created Apr 12, 2023 3:00 pm
Status Certified

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

Community

Human Resources

Intended Audience

HR Operations, Faculty Personnel, Student Employment

Reporting System

Tableau

Displaying 61 - 90 of 510