Important Notes:
The Salary Data Report is designed to provide business managers and administrative staff information about payroll allocations.
Beginning FY25, please use the Salary Data Report in place of the Salary Ledger. The data will automatically update after each payroll and Salary Ledger email notices will cease after the 6/21/24 pay date.
To outline steps for accessing and running the new Salary Data Report in Oracle Transactional Business Intelligence (OTBI). The Salary Data Report has the same data as the Salary Ledger. Any new fields will appear as extra columns at the end. This is to mitigate interference when used with other systems such as power pivots.
Information about report time out:
When running this report for a large data set, extended periods of time, or data that crosses fiscal years, the report will take several minutes to generate results. Best practice is to schedule the report to run. If you are looking for data from several past years consider using the Salary Ledger for historical data.
Information about Salary Data Report and grant management / sponsored programs:
If you are pulling payroll data for the lifespan of a grant, and you need historical data beyond September 2021, you must run both the Salary Data Report the Salary Ledger.
Best practice to obtain the correct payroll total for the lifespan of a grant:
Locate and Launch the Salary Data Report
Access Boise State Reporting HR/Payroll and locate the Salary Data report by entering Salary in the field to search by keyword.
Boise State Reporting will display the reports in either a List or Card view.
Change your view by selecting either List View or Card View in the upper navigation.
By default, this report launches with the category filter set to “All Reports”. If needed, update the Filter by Category drop-down to view reports specific to one area of reporting
Favorite commonly used reports by selecting Favorite in card view and the star icon in list view.
After locating the Salary Data Report, select Launch on the report card or Launch located on the right side of the report name if you’re in list view.
If you need to request report access, submit an Access Request Form. When submitting the access request, include the name of the report and any other details that might be needed.
Step 1: Enter Parameters for the Account Analysis Summary
After launching the report, a Warning message will display indicating mandatory parameters have not been entered. Select OK to continue.
Enter the Accounting Dates in the *Accounting Date Between and the *and fields to identify the dates you want to include in the search.
If you manually enter the Accounting date, use the format MM-DD-YYYY (e.g. 03-01-2024).
Enter any applicable costing segments.
If searching for a particular employee, enter the employee ID number. Otherwise, leave this field blank and results will populate for all employees with payroll allocated to the costing segments you’re searching for.
After entering the necessary fields, select Apply.
Step 2: Export the Data to Excel
The Salary Data Report generates an Excel output with search results.
If the Excel sheet does not pop-up, select the download icon in the top right corner of the screen to find recently downloaded documents. Select the Excel sheet with the requested salary data.
Depending on the range and amount of data you requested, you may receive an error message about exceeding any of these limits while running the report. If you receive an export limit error, follow the troubleshooting steps below.
Troubleshooting Error Messages in the Salary Data Report
The most common error messages include:
Timing-out while running (the report interface has a 10-minute limit).
Exceeding the row limit.
Memory errors.
If you receive an error through the report interface, you can:
Reduce the data being requested by editing the account data range, or other parameters, and running it again.
Scheduling the report allows more time for the report to run, reducing the chance of time-out or other errors.
You can schedule the report to run immediately or at a specified time.
When scheduling, if you encounter an error, reduce the data by editing the accounting date range or other parameter.
It is best practice to schedule the report, initially, if you are running a report that is:
spanning a year,
includes multiple departments over several months, or
includes numerous individuals without costing information.
End of Process
Need help with the steps above?
For support with running this report (e.g. you received an error message) submit a Help Desk Self-Service ticket. Visit Reporting at Boise State for more information about university reporting.
If you have suggestions to improve this job aid, submit an OCI Service Request ticket.