Tableau is the reporting tool for payroll at Rutgers University.
Tableau can be found at https://bireporting.rutgers.edu or at https://my.rutgers.edu
Tableau tile in Cornerstone:
Tableau contains multiple report options
How to navigate to the Tableau Reports- How to Navigate in Tableau
The Payroll Distribution Report will tell you the payroll data You will have 4 options to choose from for the payroll distribution report.
-
- By EE (Employee) Pay Period End Date Range
-
This report will show you the employee payroll based on the Pay Period End Date. SAS Guide on how to Run the FMS Payroll Distribution By EE & Pay Period Date Range
-
- By Employee & Date Range (Detail)
- This report will show you the employee payroll based on the dates you request. This report will also allow you to enter in the GL Posting Date, the Date of Paycheck, and the Redistribution Date (in addition to the Pay Period End Date). SAS Guide on how to Run the FMS Payroll Distribution Report By Employee & Date Range (Detail)
-
- By COA String- FY by GL Posting Date
- This report will show you the payroll distribution by fiscal year for either your General Ledger (GL) string, project strings, or both (depending on what you enter in your search criteria. SAS Guide on how to run the FMS Payroll Distribution Report by COA String
-
- By COA String- Pay Period
- This report will show you the payroll distribution based on the dates you request. This report will allow you to enter the Pay Period End Date, GL Posting Date, the Date of Paycheck and the Redistribution date. SAS Guide on how to run the FMS Payroll Distribution Report-Pay Period
The FMS Employee Status Report will show you where people are being paid and what percentage is on the GL string or project(s). You will have 3 options to choose from for the Employee Status Report.
- Export List
- This report will show you the salary information based on the GL String and/or the project(s) number you enter. SAS Guide on how to run the FMS Employee Status Report Export List
- By COA Segment
- This report will show you the salary information based on the GL string and/or the project(s) number you enter. This report will not include the GL string and/or the project(s) number in it. SAS Guide on how to run the FMS Employee Status Report by COA Segment
- By Employee
- This report will show you where individual employees are paid. This report is not limited to your organization. It will show organizations outside of your organization if applicable. It will show you the percentage of the employees split (if applicable- example: faculty is in Department A at 40% an in Department B at 60%) SAS Guide on how to run the FMS Employee Status Report by Employee
The FMS Appointment Level Charging Instruction Report will show you the combination code in People Soft for each person in your department or center. SAS Guide on how to run the FMS Appointment Level Charging Instructions
{slider=Department Default ECI}
The FMS Department Default ECI (Employee Charging Instructions) will show you what your department has selected as your default charging instructions when you add a new employee to People Soft.
Every department as a string designated as the default to charge payroll against. This can be a GL (General Ledger) string or sometimes it is a project string. SAS Guide on how to run the FMS Department Default ECI Report
- The system will not accept your search criteria (the "Apply" is not available to click-
)- To fix, remove the check next to "All"
and type in your search criteria, this will allow you to enter your search criteria and click "Apply"
- To fix, remove the check next to "All"
- When you click download to your report, "Cross tab" is not an option
Payroll should be reviewed periodically through out the fiscal year to make sure people are being paid off of the correct string, or to make sure that leaves are properly recorded.
If you do not have access to Tableau for payroll purposes, please fill out the attached: Tableau Access Form
Common Payroll Account Codes-
