Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

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.

  • It is best practice to schedule the Salary Data Reportif you are running a report that is:

    • spanning a year,

    • includes multiple departments over several months, or

    • includes numerous individuals without costing information.

Note

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:

  • run the Salary Ledger to pull historical data (FY24 and before) from the Salary Ledger, pull data beginning FY25 and going forward from prior to September 2021,

  • run the Salary Data Report to pull data after September 2021,

  • add combine the two report outputs into one file to obtain a total for the lifespan of the grant.

Step 1: Locate and Launch the Salary Data Report

  1. Access Boise State Reporting HR/Payroll and locate the Salary Data report by entering Salary in the field to search by keyword.

...

Note

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 2: Enter Parameters for the Account Analysis Summary

Warning

After launching the report, a Warning message will display indicating mandatory parameters have not been entered. Select OK to continue.

...

  1. Enter any applicable costing segments.

  2. 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.

  3. After entering the necessary fields, select Apply.

Step 3: Export the Data to Excel

  1. 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.

  2. Open the Excel output to review results as needed.

...

Warning

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.

End of Process

...

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.

Note

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.

  • Schedule the report to run.

    • 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

...

    • .

...

Schedule the Salary Data Report to Generate via Email

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 by following the steps below:

...

  1. Open the email notification and select the link in the body of the message.

  2. Select the Output file name to load results via output.

End of Process

...

Need help with the steps above?