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 1021 - 1050 of 1726

Data Domain
Community
Tags
Status
Reporting System
I50 Analysis
Created Jun 05, 2018 10:58 am
Status Certified

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.   

Data Domain

Human Resources

Community

Benefits

Intended Audience

Benefits

Reporting System

Tableau

Tags

Benefits, Accounting, Human_Resources

I9 Purge PIDMs
Created Jul 19, 2024 10:14 am
Status Certified

I9 Purge PIDMs is a listing of all PIDMS for terminated employees who were hired within the last 50 months so that GW DOCs can be purged.

Community

Human Resources

Intended Audience

HR Operations

Reporting System

Tableau

Tags

HR_Operations

I9 Purge PIDMs
Created Jul 19, 2024 10:14 am
Status Certified

I9 Purge PIDMs is a listing of all PIDMS for terminated employees who were hired within the last 50 months so that GW DOCs can be purged.

Community

Human Resources

Intended Audience

HR Operations

Reporting System

Tableau

Tags

HR_Operations

IDC Analysis
Created Aug 14, 2019 12:02 pm
Status Certified

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.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

IDC Analysis
Created Aug 14, 2019 12:02 pm
Status Certified

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.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

IDC Analysis
Created Aug 14, 2019 12:02 pm
Status Certified

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.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

IDC Check for CCAS
Created Dec 14, 2023 2:36 pm
Status Certified

IDC Check for CCAS

Community

Office of the Vice President for Research (OVPR)

Intended Audience

Research OVPR

Reporting System

Power BI

IDC Check for CCAS
Created Dec 14, 2023 2:36 pm
Status Certified

IDC Check for CCAS

Community

Office of the Vice President for Research (OVPR)

Intended Audience

Research OVPR

Reporting System

Power BI

IDC Check for CCAS
Created Dec 14, 2023 2:36 pm
Status Certified

IDC Check for CCAS

Community

Office of the Vice President for Research (OVPR)

Intended Audience

Research OVPR

Reporting System

Power BI

IGEN Award Review
Created Jun 26, 2020 10:28 am
Status Certified

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.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

IGEN Award Review
Created Jun 26, 2020 10:28 am
Status Certified

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.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

IGEN Award Review
Created Jun 26, 2020 10:28 am
Status Certified

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.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

Integrating Quality Dashboards
Created Nov 07, 2019 3:05 pm
Status Certified

These dashboards provide insight to how application measures correlate with academic performance for enrolled students in health sciences.

Data Domain

Academics

Community

School of Medicine and Health Sciences (SMHS)

Intended Audience

Program directors, department chairs, select administrative staff

Reporting System

Tableau

Integrating Quality Dashboards
Created Nov 07, 2019 3:05 pm
Status Certified

These dashboards provide insight to how application measures correlate with academic performance for enrolled students in health sciences.

Data Domain

Academics

Community

School of Medicine and Health Sciences (SMHS)

Intended Audience

Program directors, department chairs, select administrative staff

Reporting System

Tableau

Integrating Quality Dashboards
Created Nov 07, 2019 3:05 pm
Status Certified

These dashboards provide insight to how application measures correlate with academic performance for enrolled students in health sciences.

Data Domain

Academics

Community

School of Medicine and Health Sciences (SMHS)

Intended Audience

Program directors, department chairs, select administrative staff

Reporting System

Tableau

Interactive Grade Report
Created Mar 12, 2019 2:15 pm
Status Certified

This dashboard contains two tabs: Interactive Grade Report and Customize Comparisons Data includes course grades, which includes letter grade distribution, mean/median GPA grades, and course enrollment for each course. It is created to automate the process of sending out grade summary reports to each school in excel format every semester. The table data source for this report is based on: TBL_STUDENT_COURSE_REGIST_PDS.

Data Domain

Academics

Community

Office of Institutional Research and Planning

Intended Audience

School deans and chairs

Reporting System

Tableau

Tags

Academics, IR

Interactive Grade Report
Created Mar 12, 2019 2:15 pm
Status Certified

This dashboard contains two tabs: Interactive Grade Report and Customize Comparisons Data includes course grades, which includes letter grade distribution, mean/median GPA grades, and course enrollment for each course. It is created to automate the process of sending out grade summary reports to each school in excel format every semester. The table data source for this report is based on: TBL_STUDENT_COURSE_REGIST_PDS.

Data Domain

Academics

Community

Office of Institutional Research and Planning

Intended Audience

School deans and chairs

Reporting System

Tableau

Tags

Academics, IR

Interactive Grade Report
Created Mar 12, 2019 2:15 pm
Status Certified

This dashboard contains two tabs: Interactive Grade Report and Customize Comparisons Data includes course grades, which includes letter grade distribution, mean/median GPA grades, and course enrollment for each course. It is created to automate the process of sending out grade summary reports to each school in excel format every semester. The table data source for this report is based on: TBL_STUDENT_COURSE_REGIST_PDS.

Data Domain

Academics

Community

Office of Institutional Research and Planning

Intended Audience

School deans and chairs

Reporting System

Tableau

Tags

Academics, IR

Internal Funding Analysis
Created Sep 10, 2020 11:54 am
Status Certified

This dashboard is designed to assist FDs in analyzing the internal funding. The dashboard includes three tabs. Internal Funding Analysis is the main dashboard where FDs can search for all PTAs related to the non closed or recently closed (closed within last 18 months) IXXS awards. And then user can click on each PTA to get to more detailed actual expenditures based on the period end GL dates entered. Actual Expenditures by GL Date sub dashboard could be accessed through a link from the PTA counts per organization chart. This report provides summary information per PTA by the period end GL date. This is to provide a high level picture on where the PTA stands in terms of expenditures.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS and FDs

Reporting System

Tableau

Tags

FINANCE

Internal Funding Analysis
Created Sep 10, 2020 11:54 am
Status Certified

This dashboard is designed to assist FDs in analyzing the internal funding. The dashboard includes three tabs. Internal Funding Analysis is the main dashboard where FDs can search for all PTAs related to the non closed or recently closed (closed within last 18 months) IXXS awards. And then user can click on each PTA to get to more detailed actual expenditures based on the period end GL dates entered. Actual Expenditures by GL Date sub dashboard could be accessed through a link from the PTA counts per organization chart. This report provides summary information per PTA by the period end GL date. This is to provide a high level picture on where the PTA stands in terms of expenditures.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS and FDs

Reporting System

Tableau

Tags

FINANCE

Internal Funding Analysis
Created Sep 10, 2020 11:54 am
Status Certified

This dashboard is designed to assist FDs in analyzing the internal funding. The dashboard includes three tabs. Internal Funding Analysis is the main dashboard where FDs can search for all PTAs related to the non closed or recently closed (closed within last 18 months) IXXS awards. And then user can click on each PTA to get to more detailed actual expenditures based on the period end GL dates entered. Actual Expenditures by GL Date sub dashboard could be accessed through a link from the PTA counts per organization chart. This report provides summary information per PTA by the period end GL date. This is to provide a high level picture on where the PTA stands in terms of expenditures.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS and FDs

Reporting System

Tableau

Tags

FINANCE

IPED Survey Report
Created Mar 06, 2018 3:52 pm
Status Certified

The Integrated Postsecondary Education Data System (IPEDS) is a system of interrelated surveys conducted annually by the National Center for Education Statistics (NCES), a part US Department of Education. Survey collect various Higher Education Institutions' data. This report summaries annual sponsored research activities according to IPEDS categories.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

IPED Survey Report
Created Mar 06, 2018 3:52 pm
Status Certified

The Integrated Postsecondary Education Data System (IPEDS) is a system of interrelated surveys conducted annually by the National Center for Education Statistics (NCES), a part US Department of Education. Survey collect various Higher Education Institutions' data. This report summaries annual sponsored research activities according to IPEDS categories.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

IPED Survey Report
Created Mar 06, 2018 3:52 pm
Status Certified

The Integrated Postsecondary Education Data System (IPEDS) is a system of interrelated surveys conducted annually by the National Center for Education Statistics (NCES), a part US Department of Education. Survey collect various Higher Education Institutions' data. This report summaries annual sponsored research activities according to IPEDS categories.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

Job Families
Created Jan 21, 2021 3:28 pm
Status Certified

This is dashboard of all the Job Family and Job Subfamily Codes and descriptions along with the User who entered the codes and descriptions in the Banner tables and the date it was entered.

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Tableau

Tags

HR

Job Families
Created Jan 21, 2021 3:28 pm
Status Certified

This is dashboard of all the Job Family and Job Subfamily Codes and descriptions along with the User who entered the codes and descriptions in the Banner tables and the date it was entered.

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Tableau

Tags

HR

Job Families
Created Jan 21, 2021 3:28 pm
Status Certified

This is dashboard of all the Job Family and Job Subfamily Codes and descriptions along with the User who entered the codes and descriptions in the Banner tables and the date it was entered.

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Tableau

Tags

HR

Job Labor Distribution
Created Mar 25, 2022 12:23 pm
Status Rejected

This report provides a listing of Active Employees by org code and includes the job labor distribution amount.

Data Domain

Finance

Community

Financial Reporting - Job and Position

Intended Audience

Finance and Finance Directors

Reporting System

Tableau

Tags

Finance_Director, FINANCE, HR

Job Labor Distribution
Created Mar 25, 2022 12:23 pm
Status Rejected

This report provides a listing of Active Employees by org code and includes the job labor distribution amount.

Data Domain

Finance

Community

Financial Reporting - Job and Position

Intended Audience

Finance and Finance Directors

Reporting System

Tableau

Tags

Finance_Director, FINANCE, HR

Job Labor Distribution
Created Mar 25, 2022 12:23 pm
Status Rejected

This report provides a listing of Active Employees by org code and includes the job labor distribution amount.

Data Domain

Finance

Community

Financial Reporting - Job and Position

Intended Audience

Finance and Finance Directors

Reporting System

Tableau

Tags

Finance_Director, FINANCE, HR

Displaying 1021 - 1050 of 1726