Welcome to Business Intelligence Services' Content Catalog.

LOA Payroll Audit Dashboard is primarily used by Benefits team to audit various GW benefits and payrolls related to leave of absence. The Salary Increment report will pull salary increases by month and year, which will be used to audit life, AD&D and disability increase during a leave of absence. Payroll Report is used to review employee hours paid for multiple uses including FMLA eligibility and DC Sick and Safe Leave accruals.  Earn Code Report will pull payroll transactions for Earn Code SD2 (GW Paid STD) and PPL (Staff paid parental leave) to ensure they are being charged to account 51824.

CLICK HERE TO VIEW CONTENT

This is a dashboard that provides a listing of employees who are no longer Benefit Eligible

CLICK HERE TO VIEW CONTENT

This report provides a list of active managers; selecting a Manager will populate an additional table with a list of employees who report to the Manager.

CLICK HERE TO VIEW CONTENT

This is a listing of Managers who have employees in the Job Classification of Executive Stream under their supervision

CLICK HERE TO VIEW CONTENT

This Dashboard is a listing of all Managers who only supervise/manage employees who are exempt.

CLICK HERE TO VIEW CONTENT

Provides timely insight into manual registrations and report inefficiencies and implications.

CLICK HERE TO VIEW CONTENT

The dashboard displays information relating to the processing of manual registrations requested via Registration Transaction Forms. It contains 8 tabs. 1. Registration activity that shows percentage of students registered by college. 2. Registration count that shows count of student registered by a) College, b) Level and c) Degree. 3. Registration by semester that includes visualizations by term as well as semester. 4. Registration by activity date plus a comparison by month. 5. Registration by statu date (RSTS Date) plus a comparison by month. 6. Registration added by , that identifies the person who added the information based on Banner IDs, also a visualization by group. 7. Registration added by known user that shows information included but not identified by a Banned ID. Plus a visualization by group. 8. Days(RSTS-Activity) that shows an area chart by day of registration status date. 

CLICK HERE TO VIEW CONTENT

This dashboard provides details on placement scores for MATH and CHEM.  Placement Test Year includes 2024 and later.

CLICK HERE TO VIEW CONTENT

Provides insights into the number of Medical Residents, presenting demographic insights including age, gender, race/ethnicity, and years of service.

CLICK HERE TO VIEW CONTENT

This report displays all benefit eligible staff with supervisor and class codes.

CLICK HERE TO VIEW CONTENT

Merit File is a listing of Benefit Eligible Employees who have receivied Merit and some job/position information

CLICK HERE TO VIEW CONTENT

Merit Report is a file of Active Benefit Eligible employees who are eligible for merit and some job/position information

CLICK HERE TO VIEW CONTENT

This Tableau dashboard provides course information by student, including the option to filter to courses based on whether they are a core or prerequisite for an undergraduate in one of GWSPH's three majors. Also includes options to filter to students with low course grades, and view registration counts of majors, concentrations, and minors by term.  

CLICK HERE TO VIEW CONTENT

This dashboard displays the total number of unreported grades by Term, College, Department, Subject, Course Number, and Course Reference Number (CRN). It excludes: Course College = 'School of Med Sc' AND Section = '50' and Sections 'GMU', 'GM1' and CRN must have gradable Indicator = 'Y'

CLICK HERE TO VIEW CONTENT

This report is for GCAS to make sure all the non-LOC cost reimbursable awards (CCNS) have been reviewed and invoiced as expected.  The report will show all the CCNS awards that have funding amount greater than the billed amount and haven't been billed over 90 days.  The report will also include awards started more than 90 days but have not been invoiced.  It only includes awards with ACTIVE and ON_HOLD status .

CLICK HERE TO VIEW CONTENT

Missing Reporting Units is a dashboard that displays missing HR Reporting Units by Organization Code for Timesheet and Position Home Organizations

CLICK HERE TO VIEW CONTENT

Missing SSN Dashboard provides a listing of employees who have missing social security numbers on file.

CLICK HERE TO VIEW CONTENT

This dashboard is designed to assist GCAS team in monitoring the awards that have been modified.  The dashboard shows the number awards that have been modified belong to the various checkpoints in a selected modification date range.   Users can click on the number for each checkpoint and get to the details of the awards.

CLICK HERE TO VIEW CONTENT

Monthly Active Employees with no Active Earnings is a listing of Exempt employees who are paid monthly and there is no current earnings for the month.

CLICK HERE TO VIEW CONTENT

Monthly TE  by School and FY

CLICK HERE TO VIEW CONTENT

New Hires- Active Employees AAP Prep displays all employees who were hired during the date specified by the user.

CLICK HERE TO VIEW CONTENT

New Hires and Terminations Dashboard is a reporting tool designated to show demographic and position data for employees new to GW or employees leaving GW.  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.

CLICK HERE TO VIEW CONTENT

New Hires Compliance report is a listing of all Benefit Eligible employees hired during the period specified

CLICK HERE TO VIEW CONTENT

New Hires Dashboard is a reporting tool designated to show demographic and position data for employees new to GW and employees whose jobs have ended.  It is employees organized by HR 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 to see the detail information. These filters are HR Reporting Unit, Department , Job Employee Type, and Job Benefit Category. Additional information for the detail data includes GWID, name, HR Reporting Unit, Timesheet Organization, Position Class information among others.

This report lists the newly hired Post Doc positions in the last 30 days

CLICK HERE TO VIEW CONTENT

New Hires/Terminations Dashboard is dashboard that depending on what option is chosen will display New hires or Terminated employees during a specified period. This dashboard does not contain any salary or bio demographic information.

CLICK HERE TO VIEW CONTENT

No Primary - Active Secondary is a dashboard that displays an employee if they have an active secondary job but no active primary job

CLICK HERE TO VIEW CONTENT

Reports used to audit Non-Exe,pt / Non-Discretional Bonus of employees records. Filters are GWID and Pay Calendar Begin Date.

CLICK HERE TO VIEW CONTENT

This report is an audit of Position Class Codes that shows activity date and change date based on UserID. The following UserIDs are excluded: PERMFD,VPTAEH, PERJML, PERJAK.

CLICK HERE TO VIEW CONTENT

Provides enrollment trends in GWSPH online masters programs, including program concentrations, a list of students in the programs, and indicates whether required concentration courses have been completed.

CLICK HERE TO VIEW CONTENT