Welcome to Business Intelligence Services' Content Catalog.

This build your own report contains all of the necessary data to identify employees and relevant human resources data points related to HR position salary. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report.

CLICK HERE TO VIEW CONTENT

This report identifies each employee by his/her Organization unit and job location by city and state. Filters for this report are Base Employee Class Code and HR Reporting Unit Description.

CLICK HERE TO VIEW CONTENT

This report identifies each employee by his/her Organization unit and job location by city and state. Filters for this report are Base Employee Class Code and HR Reporting Unit Description.

CLICK HERE TO VIEW CONTENT

Provides insights into average and median salaries, along with their percentage differences, across different benefit eligible employee types and benefit-eligible positions, aiding strategic decision-making.

CLICK HERE TO VIEW CONTENT

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.   

CLICK HERE TO VIEW CONTENT

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.   

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

IDC Check for CCAS

CLICK HERE TO VIEW CONTENT

IDC Check for CCAS

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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

CLICK HERE TO VIEW CONTENT

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

CLICK HERE TO VIEW CONTENT

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.

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.

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.

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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

CLICK HERE TO VIEW CONTENT

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

CLICK HERE TO VIEW CONTENT

This report is for GCAS to review the Grants related Labor Cost Transfers. The report includes earn amount measure with transaction and posting dates.

CLICK HERE TO VIEW CONTENT

This report is for GCAS to review the Grants related Labor Cost Transfers. The report includes earn amount measure with transaction and posting dates.

CLICK HERE TO VIEW CONTENT

Shows the percent of effort spent by an employee on a given award based on Banner HR Labor Distributions. The report includes distributions across all positions and banner indexes, including non-sponsored research activity. 

CLICK HERE TO VIEW CONTENT

Shows the percent of effort spent by an employee on a given award based on Banner HR Labor Distributions. The report includes distributions across all positions and banner indexes, including non-sponsored research activity. 

CLICK HERE TO VIEW CONTENT

This report tracks employees' FMLA (Family and Medical Leave Act) leave information and also tracks all other types of leave (personal, USERRA, administrative, etc.).

CLICK HERE TO VIEW CONTENT