Welcome to Business Intelligence Services' Content Catalog.
The catalog provides a way to find reports, dashboards, pinboards, worksheets, 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.
The Dashboard is used to review and analyses student application, trends and status by application terms, as well as to compare cumulative application counts over the same term as the previous year for only the students with attributes
Data Domain
Academics
Community
Enrollment Management
Intended Audience
Enrollment Management Office, Admission Officers
Reporting System
Tableau
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
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
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
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
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
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
Report of employees who have Interim Assignments and the expirations dates for those assignments
Data Domain
Human Resources
Community
Human Resources
Intended Audience
Compensation
Reporting System
ThoughtSpot
This answer 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
ThoughtSpot
Report of all Active Employee Class codes and their descriptions
Data Domain
Human Resources
Community
Human Resources
Intended Audience
Compensation, HRIS Operations
Reporting System
ThoughtSpot
This is a listing of all active Employee Class codes and descriptions
Data Domain
Human Resources
Community
Benefits
Intended Audience
Human Resources
Reporting System
ThoughtSpot
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
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
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
Provides a listing of Active Employees by Home reporting Unit only and does not include their Labor Distributions.
Data Domain
Human Resources
Community
Human Resources
Intended Audience
HR Employees and anyone needing information on Active Employees in their areas
Reporting System
ThoughtSpot
Provides a listing of Active Employees by Org Code or by Employee Type and does not include their Labor Distributions.
Data Domain
Human Resources
Community
Human Resources
Intended Audience
HR Personnel
Reporting System
ThoughtSpot
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
ThoughtSpot
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
Human Resources
Reporting System
Tableau
Provides a listing of all active employees in U3 Employee class code positions along with some position information
Data Domain
Human Resources
Community
Benefits
Intended Audience
Human Resources
Reporting System
ThoughtSpot
This report will provide a list of active employees who have active retirement deductions.
Data Domain
Human Resources
Community
Benefits
Intended Audience
Benefits
Reporting System
Tableau
This reports provides a listing of active employees and includes the HR Service Delivery person assigned to that employee
Data Domain
Human Resources
Community
Benefits
Intended Audience
Human Resources
Reporting System
Tableau
This report will provide a list of active employees who have terminated benefits within a given time period.
Data Domain
Human Resources
Community
Benefits
Intended Audience
Benefits
Reporting System
Tableau
This is an audit reports used to determine employees with Active status who do not hold an active job
Data Domain
Human Resources
Community
Benefits
Intended Audience
Human Resources
Reporting System
ThoughtSpot
Provides a listing of Active Faculty by Org Code and does not include their Labor Distributions with a date prompt to allow for point in time reporting.
Data Domain
Academics
Community
Faculty Affairs
Intended Audience
Faculty Personnel
Reporting System
ThoughtSpot
This report contains active faculty summary by headcount with initial filtering by Banner School/Division. Summary displays total count of tenure (non tenure - accruing), tenure (none), tensure (research) and tenure (tenured). Additional filters for banner home org, peaempl class code, nbajobs employee class, benefit category code, rank code and job contract type. Resulting report contains faculty details by gwid.
Data Domain
Academics
Community
Faculty Affairs
Intended Audience
Faculty Personnel
Reporting System
Tableau
Report lists all Active Finance Directors along with some position information
Data Domain
Human Resources
Community
Human Resources
Intended Audience
HRIS Operations
Reporting System
ThoughtSpot
This is a listing of all active jobs and career classifications
Data Domain
Human Resources
Community
Human Resources
Intended Audience
Compensation
Reporting System
ThoughtSpot
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
Human Resources
Reporting System
ThoughtSpot
This answer provides a listing of Faculty who have an active employee record but no active job
Data Domain
Academics
Community
Faculty Affairs
Intended Audience
Faculty Personnel
Reporting System
ThoughtSpot
This report displays basic information such as employee class, title, and incumbent indicator for all active positions along with the position labor attached to the position.
Community
Human Resources
Intended Audience
HR Client Partners, Finance Directors
Reporting System
Tableau