The State Periodic Wage Listing (Enhanced) (SPWL) process generates State Quarterly and Monthly Wage listing reports. This process uses the Oracle XML Publisher technology to generate the reports and there is only one concurrent program to run both the quarterly and monthly processes.

To be able to run the State Periodic Wage Listing (Enhanced) process for a GRE, the following criteria must be met:

• The SUI Account Number in Work Structures > GRE > Others > State Tax Rules contains a value.

• The GRE is not defined as a 1099-R GRE.

• The SUI ER Taxable balance for dimension 'GRE in JD Quarter to Date' is greater than zero.

If you are running the SPWL report for Louisiana, then ensure that you enter the job definition data. See: Entering Job Definition for the SPWL Report for Louisiana

Run this process from this Submit Request window.

   To run the State Periodic Wage Listing (Enhanced) process:

1. In the Name field, select State Periodic Wage Listing (Enhanced).

2. Click in the Parameters field if the Parameters window does not open automatically.

3. Specify the following parameters:

   • State: This parameter captures the state code for which the process needs to be submitted. Select the applicable state (or Puerto Rico) for which you need to run the process.

   • Period: This parameter captures the period for which the report needs to be processed and reported. This parameter is dependent on the state selected. If the state requires only quarterly reports, then only quarter periods can be selected. If the state requires both monthly and quarterly reports (such as Illinois), then the list of values contains the applicable monthly and quarterly periods. If a state were to require only monthly reports, then only month periods can be selected.

   • Report Output: This parameter captures how the output files need to be generated and contains the following three values:

     • All GREs - single output file

     • Single GRE

     • All GREs - output file per GRE

     This parameter determines the number of times the concurrent program 'State Periodic Wage Listing (Internal)' is spawned. For each GRE processed, the concurrent program is spawned once. Note: Option (a) is the default for all states except California (CA). For CA, the state option (a) will not appear in the LOV and instead the default option is (c) - All GREs - output file per GRE.

   • Government Reporting Entity: This parameter captures the name of the GRE for which the process needs to be generated. This parameter is dependent on the Report Output parameter, so is enabled only if the Report Output parameter value 'Single GRE' is selected. Any GRE for which the report is already processed for the selected state and period will not be displayed in the list of values.

   • Format: This parameter captures the format of the report and is dependent on the state and period values selected. The list of values will display the format supported by the state. It displays no values if the report has already been processed for the selected state and period.

     For TN, if you are selecting the ICESA(Bulk) option to generate a report for multiple GREs, then you must ensure that fields related to the T (Total) record are entered in the SQWL Employer Rules 4 window. See: To enter T Record Data for Tennessee for the SPWL or SQWL ICESA (Bulk) File Format section in the Entering State Data for E and T Records topic.

   • Transmitter GRE: This parameter captures the Transmitter GRE and lists all the GREs that have been marked as SQWL Transmitter = Yes in 'SQWL Gen. Transmitter Rules' at the GRE level.

   • Create Audit Report: This parameter determines whether the exception and employee detail audit reports (A02 or A03) are to be generated. If 'Yes' is selected, then these audit reports will be generated; if set to 'No', they will not be generated.

   • Establishment Hierarchy: This parameter captures the Establishment Hierarchy Name and lists the names of all active establishment hierarchies. Note that this parameter is applicable only to Iowa and Minnesota. (The Establishment Hierarchy determines the applicable Reporting Unit Number needing to be reported for these states).

   • Hierarchy Version: This parameter lists the version numbers of the Establishment Hierarchy based on the selected Establishment Hierarchy.

   • Out of State Wages (OH) indicator set at GRE(s): This parameter is applicable only to the state of Ohio and requires additional setup at the GRE level. This parameter was added to confirm that the required setup at GRE level is complete.

     To set the Out of State Wage Indicator for Ohio and Louisiana, see: Entering Out of State Wage Indicator for SPWL or SQWL Reports

   • Fold Output: This parameter determines if the different records in the magnetic file (MF) output require a new line or carriage return character. If 'Yes', then a new line character is added after every record in the MF file. If 'No', then all the records in magnetic file are generated in the one continuous line.

4. Click OK and then Submit.

   Program Output:

This concurrent program internally spawns two concurrent programs:

• State Periodic Wage Listing (Internal)

• Generate SPWL XML(Generate Mag XML)

Depending upon the 'Print Files' parameter setting in Pay Action Parameters, an additional concurrent program "Magnetic XML Report Merger" may be displayed. If Print Files is set to "Y", then this concurrent program is displayed for each of the files generated by the process. If Print Files is set to 'N', then this concurrent program is not displayed.

The following files are generated for each concurrent program State Periodic Wage Listing (Enhanced) submission:

• MF File: File that needs to be submitted to state authorities. The file extension is '.mf'.

• A01 File: Summary Audit report that provides wage amounts and totals at the GRE level as well as Employee counts. The file extension is '.a01'.

• A02 File: Exception report which lists all exception employee details, that is, those that are excluded from reporting in the MF file due to reasons such as negative wage amounts. Th file extension is '.a02'.

• A03 File: Provides details of those employees reported in the MF file. File extension is '.a03'. This is provided in CSV output.

• TAB File: This file will be generated only if the program is run for the state of Pennsylvania.

When the State Periodic Wage Listing (Enhanced) process is run, the process generates .a02 and .a03 files for all states to help identify employees who are reported and not reported. There is no need to run the 'State Quarterly/Monthly Error Report' separately to identify employee information, which is not reported.

The A01 (Audit Summary) output file generated by the concurrent program is in PDF format. Data reported in the A02 and A03 output files are dependent on the state reported and therefore will not be the same for all states. The file names generated by this process are the same as the SQWL process. Currently both processes can be run in parallel which means that if both processes are run for the same state and period, then the files generated by running the first process will be overwritten by running the second process. For example: If the State Quarterly Wage Listing (SQWL) report is run first for the state of California for Q3 2014 and then later the State Periodic Wage Listing (SPWL) report is run for the same state for Q3 2014, then the files generated by running the SQWL process will be overwritten by the output files generated when running the SPWL process.

The report types of the SPWL payroll actions are "SPWL_PARENT" and "SPWL_ARCH". One "SPWL_PARENT" action is created for each concurrent request submitted. For each GRE's data that is processed, one payroll action is generated with a report type of "SPWL_ARCH". In View Payroll actions these payroll actions are visible.

   Viewing Archived Data:

To view data archived with the State Periodic Wage Listing (Enhanced) process:

1. Select Assignment Process Result from the View menu.

2. Select State Periodic Wage Listing (Enhanced), and click Run Result.

3. The View Archived Values window opens to show data archived for an employee, including:

   Database item name

   Value archived against an assignment action

   Any associated context (such as Jurisdiction Code for State Income Tax)

   This information is read-only.

   State related archived data can be viewed in the .xml report output, which is in the XML format.

   Rolling Back SPWL Data:

For rolling back the payroll actions generated by this process, run the "Rollback US SPWL Process" concurrent program. See: Running the Rollback US SPWL Process