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 1 - 30 of 497
Data Domain
Community
Tags
Status
Reporting System
Active Organization Codes and HR Reporting Units
Created Jun 08, 2023 11:13 am
Status Certified

This is a listing of all active organization codes and the HR Reporting unit assigned to that org

Data Domain

Human Resources

Community

Benefits

Intended Audience

HR Benefits

Reporting System

Power BI

Active Taxes and Deductions
Created Jun 08, 2023 11:55 am
Status Certified

This is an audit report for a listing of employees and deductions for those living in New York, New Jersey, Rhode Island, Hawaii, California and Puerto Rico 

Data Domain

Human Resources

Community

Benefits

Intended Audience

HR Benefits

Reporting System

Power BI

GL - Account Detail for COVID-19 Orgs
Created Jul 11, 2023 04:50 pm
Status Certified

This report displays  transactional details filtered by designated covid-19 orgs where GL Line description contains, "GW Health Emergency COVID-19 Response" with filters for Fiscal Date, Balance  Type Code, Entity Code, GL Line  Status and Acct Reporting Roll-up.

Community

General Ledger

Intended Audience

Finance GL Users

Reporting System

Power BI

HR Compensation: Employees Earning Less than Minimum Wage
Created Jun 08, 2023 02:35 pm
Status Certified

This is a report of Employees earning less than minimum wage based on two parameters. User inputs the 'minimum wage effective date' and the applicable 'minimum wage amount'.

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Tableau

Tags

HR_Compensation

51232 Endowment
Created Jul 05, 2023 02:02 pm
Status Certified

List all GW Employeees under the Banner Account Code 51232 (Endowment)

Data Domain

Human Resources

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

90 Day Review Dashboard
Created Mar 30, 2017 10:23 am
Status Certified

This quarterly report contains PTA Number with filtered by Award End Date from and to as well as Award Status, School, SPFA, Project Number, and Award Number. Measures include stipend, tuition, budget amount, actual amount, capital equipment, encumbrance amount, balance, suspense amount, amount in failed funds, and spending level(%).

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

90 Day Review Report - Stipend and Tuition Details
Created Apr 03, 2017 02:50 pm
Status Certified

This quarterly report is primarily used to view individual PTAs and it works in conjunction with the 90 Day Review Report Dashboard. This report contains Student Names, SPFA, Expenditure Comments and Actual Amount  to give details of who received stipends and tuition on a particular award.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

990 Deductions
Created Jul 05, 2023 01:50 pm
Status Certified

List 990 Deductions. Filters that apply are History Date, Benefit or Deduction Code and Rule Class Code. This report also filters GWIDs by adding one or more values in the filter field.

Data Domain

Human Resources

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

990 Earnings
Created Jun 23, 2023 04:06 pm
Status Certified

List 990 Earnings. Filters that apply are History Date, Benefit or Deduction Code and Rule Class Code. This report also filters GWIDs by adding one or more values in the filter field.

Data Domain

Human Resources

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

A Fund Reconciliation and Federal Expense and Receipts Dashboard
Created Jun 05, 2019 11:04 am
Status Certified

This dashboard contains two sub dashboards. One is the A Fund Reconciliation report, where comparison will be made between the Actual Expenditures charged to Award Organization and the Task Organization. The other one is the Federal Grants Expense and Receipts Dashboard.  This dashboard provides expenses and cash receipts on federal funded grants.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

A133 Special Transfer -Details
Created Jul 16, 2020 12:07 pm
Status Certified

This report has a from and to date parameter and looks at expenditures that have been transferred more than one time. New information and old information is displayed including expense amount.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS STAFF

Reporting System

Tableau

Tags

FINANCE

Academic Advising Student Surveys
Created Nov 06, 2020 08:26 am
Status Certified

This dashboard contains the project Survey Research and Analysis (SRA). It includes five tabs: About the Survey, Professional Advising, Faculty Advising, Special Population Advising, and Self-Assessment. 

Data Domain

Academics

Community

Office of Survey Research and Analysis

Intended Audience

Academic Advisors, Deans, department chairs, faculty

Reporting System

Tableau

Tags

Academics

Account Code Information
Created Jul 31, 2023 02:57 pm
Status Certified

Retrieving data by GL account codes supports account reconciliations.

Community

Benefits

Intended Audience

HR Benefits

Reporting System

Power BI

Account Detail by 9 Segments (GL-329)
Created May 20, 2016 10:56 am
Status Certified

Shows account detail by 9 Segments and EAS Org Financial Director Code with a drill down capability to Accounts Payable information. Prompts by Account and Accounting Period as required with additional optional fields for Entity and Organization. Data Tables Used: 1. General Ledger Line ​ -​ retrieves GL Line information including Fiscal year, Entered DR Amount, Entered CR Amount, Entered Amount Balance, GL Source Description, GL Category Description, Effective Date, Posted Date, GL Batch Name, GL Header Name, GL Header Description, GL Line Description and GL Line Number. 2. ​General Ledger AP Invoice table ​ - ​retrieves Vendor Name, Invoice Number and Invoice Line description. Note: Data includes 'Actual' Balance Type Desc and 'P' (Posted) ​GL Line Status only

Data Domain

Finance

Community

University Controller

Intended Audience

Financial Reporting and UAS groups with in Comptroller's Office

Reporting System

Cognos

Tags

FINANCE

Acting Interim End Date
Created Mar 29, 2023 04:27 pm
Status Certified

This report is used by HR Compensation to filter for employees in an interim role.

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Power BI

Tags

HR_Compensation

Active Benefit Eligible Employees
Created Apr 18, 2023 01:30 pm
Status Certified

Active Benefit Eligible Employees is a listing of employees who are benefit eligible by employee type  

Community

Human Resources

Intended Audience

HR Talent & Organizational Development

Reporting System

Tableau

Tags

HR_Talent

Active Benefit Eligible Employees Email Only
Created Apr 18, 2023 01:33 pm
Status Certified

Active Benefit Eligible Employees Email Only is a dahsboard that is part of a collection of dashboards called Email Lists which displays benefit eligible active employees email addresses

Community

Human Resources

Intended Audience

HR Talent & Organizational Development

Reporting System

Tableau

Tags

HR_Talent

Active Benefit Eligible Staff
Created Apr 18, 2023 01:45 pm
Status Certified

Active Benefit Eligible Staff is a dashboard that is part of a collection of dashboards in Employee Lists which displays Benefit eligible staff by HR Reporting Unit

Community

Human Resources

Intended Audience

HR Talent & Organizational Developlment

Reporting System

Tableau

Active Emeritus Faculty
Created Nov 01, 2021 10:18 am
Status Certified

This report provides a listing of Faculty who have the Emeritus Status Box checked in Banner. This is a listing of all Emeritus faculty by Status.

Data Domain

Academics

Community

Faculty Affairs

Intended Audience

Faculty Personnel

Reporting System

Tableau

Tags

Faculty_AffairsFaculty

Active Employee Class Codes
Created Oct 20, 2020 12:02 pm
Status Certified

Report of all Active Employee Class codes and their descriptions

Data Domain

Human Resources

Community

Human Resources

Intended Audience

Compensation, HRIS Operations

Reporting System

Power BI

Tags

HR

Active Employee Class Codes for Benefits
Created Jun 07, 2023 03:25 pm
Status Certified

This is a listing of all active Employee Class codes and descriptions 

Data Domain

Human Resources

Community

Benefits

Intended Audience

HR Benefits

Reporting System

Power BI

Active Employee Dashboard
Created Apr 05, 2022 03:36 pm
Status Certified

Active Employee Dashboard is a reporting tool designated to show demographic and position data for an active employee.  It is employees organized by Home Reporting Unit. Some key indicators have been summarized to facilitate: a) the visualization of bulk data and b) to filter more efficiently by one specific group of people when it comes to see the detail information. These indicators are Banner Home Organization, Employee Type, Benefit Category, Job Contract Type and Exempt/Non-Exempt employees. Additional information for the detail data includes GWID, name, Home Reporting Unit, Banner Home Org, Position Class information among others.

Data Domain

Human Resources

Community

Human Resources

Intended Audience

Finance Directors, Finance, Financial Management and HR

Reporting System

Tableau

Tags

FINANCEHR

Active Employee List Reporting
Created Jul 31, 2023 03:41 pm
Status Certified

Active Employee List Reporting is a listing of all active and employees.

Community

Benefits

Intended Audience

HR Benefits

Reporting System

Power BI

Active Employee Pidm and GWid Lookup
Created Mar 29, 2023 04:17 pm
Status Certified

This report is used by HR Compensation for lookup of employees Pidm and GWids.

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Power BI

Tags

HR_Compensation

Active Employee Short Download
Created Oct 31, 2022 02:07 pm
Status Certified

Active Employee Short Download is a shortened list of fields based on the filters chosen in the Active Employee Dashboard and is available for download in a smaller, more condensed downloadable file. 

Community

Human Resources

Intended Audience

HR

Reporting System

Tableau

Active Employee/New Hire Report
Created Jul 05, 2023 02:33 pm
Status Certified

Active Employee/New Hire Report is a listing of all active and new hires employees.

Data Domain

Human Resources

Community

Benefits

Intended Audience

HR Benefit

Reporting System

Power BI

Active Employees - Work Location
Created Oct 23, 2020 09:44 am
Status Certified

This dashboard provides a list of work locations (based on WL address in Banner) for the active employees.

Data Domain

Human Resources

Community

Benefits

Intended Audience

Benefits

Reporting System

Tableau

Tags

BenefitsHR

Active Employees by Job
Created Apr 17, 2023 12:31 pm
Status Certified

Active Employee bys Job is a dashboard that displays Active employees by their Timesheet orgnaizaiton along with some position and job information but no salary or Bio demo informaiton

Community

Human Resources

Intended Audience

HR Talent & Organizational Development

Reporting System

Tableau

Tags

HR_Talent

Active Employees Detail Listing
Created Dec 15, 2020 10:01 am
Status Certified

This report lists all active Employees including any secondary job information, bio demo information and Career path information. 

Data Domain

Human Resources

Community

Human Resources

Intended Audience

Compensation

Reporting System

Power BI

Tags

HR

Active Employees in ECLS SE, E1,E2, and E3
Created Jun 08, 2023 10:57 am
Status Certified

This report provides a listing of all active employees who are in Employee Class codes SE, E1, E2 and E3 along with some career classification information

Data Domain

Human Resources

Community

Benefits

Intended Audience

HR Benefits

Reporting System

Power BI

Pages