Articles

Creating the Multiple Worksite Report (BLS 3020)

The Multiple Worksite Report is designed to collect information showing the distribution of the employment and wages of business establishments by industry and geographic area. The information collected is used by the Employment Development Department to determine the economic conditions within the State of California.

This report requires a multi-step process.

  • Install the new Report Writer reports and stored filters.
  • Run reports.
  • Create spreadsheet.

Run Reports

Your first step is to gather all of the information you are going to need in the spreadsheet. We suggest you run the Multi-Site report, the Quarterly report and the Site Location report.

NOTE: If this is the first time you are running these reports, please see the installation instructions at the bottom of this FYI.

  1. Run the Multi-Site Position report. This is simply an extract file of site and salaries.
    • In the PSL module, choose the Positions menu option.
    • Select Reports and then Multi-Site Rpt from the Position Reports menu.
    • Print to a file named POSMS.RPT.
  2. Run the Site Location report. This should give you enough information to make a pretty accurate head count determination for each site.
    • In the PSL module, choose the Personnel menu option.
    • Create a list of persons sorted by primary work location.
    • Select Rpts/Ltrs and then PSL Reports.
    • Select the Site Location report.
    • Print it to a file named SITE.RPT.
  3. Run the Quarterly Report. This will give you the figures that you are required to balance.
    • From the main menu of Pay, select Reports and then Quarterly Report from the Reports menu.
    • Select SUI ONLY.
    • Print to a file named QRT.RPT

Create the Spreadsheet

  1. Open the report file (\escape\spl\posms.rpt) in Excel, using the import wizard.
  2. Format the column widths and add column headings.
  3. Review the data. You will want to massage the spreadsheet so that there is only one line per site. (There may be multiple lines per site due to tracking records with site codes different than the current Position site.)
  4. Add a column for percent. Use a formula that divides each row’s salary by the total salary.
  5. Add a column for SUI wages. Use the Quarterly report to get the SUI wages total.
  6. Add a column for number of persons at each site. Use the Site Location report. Make sure that you take note of any "sites" that are actually departments (e.g., maintenance).
  7. Add a column for percent. Use a formula that divides the total number of persons by the number of persons at that site. This will give you the allocation of SUI wages for each site.

Installation Instructions

Below are links to the Multi-site Report and the Site Location report. The Multi-Site report has a stored filter.

Please see your system manager or contact Escape Customer Care for more information about setting up these reports.