Unemployment Report

The Unemployment Report file is in the federal MMREF format, which can be imported into the Oregon OTTER software. The file data is retrieved from:

• W2 Setup page

• Employee table

• Checkhis/checkhi2 tables

• Attend tables

Menu Path

Select Human Resources from the main navigation menu, then State. Select Unemployment Report.

Submission Period

At the end of every quarter:

• 1st quarter: Due April 30

• 2nd quarter: Due July 31

• 3rd quarter: Due October 31

• 4th quarter: Due January 31

Selection Rule

Includes all the employees who got paid during the quarter and have eligible state tax withholding.

Setup

Exempt Pay Codes

Use the OR Unemployment Report - Setup - Exempt Pay Codes page to create exempt pay codes.

1. On the OR Unemployment Report page, select Setup, then Exempt Pay Codes.

2. Filter records using the filter criteria.

3. Add or manage records as needed:

   • To add a record, select Add Record. Enter valid information, and select Save, then Yes.

   • To edit or delete a record, select the ellipsis in the Actions column, then select the appropriate option.

Deductions

Use the OR Unemployment Report - Setup - Deductions page to create deductions.

1. On the OR Unemployment Report page, select Setup, then Deductions.

2. Filter records using the filter criteria.

3. Add or manage records as needed:

   • To add a record, select Add Record. Enter valid information, and select Save, then Yes.

   • To edit or delete a record, select the ellipsis in the Actions column, then select the appropriate option.

Load Data

1. Select Load.

2. Select the Year, Quarter, Beginning Date, and Ending Date.

3. Enter the Business Identification Number.

4. Select Load, then Yes.

5. Save the OR Unemployment Load Summary Report file, then select OK.

6. Navigate to the folder containing the Load Summary Report file.

7. Inspect the file. Update data if needed.

8. Repeat these steps until all required data is loaded.

Maintain Data

You can correct loaded data before submitting the report. However, any corrections to application information must also be updated in the source data.

1. On the OR Unemployment Report page, enter the search criteria to find the required records, then select Search.

2. Add or manage records as needed:

   • To add a record, select Add new. Enter valid information and select Save. Select Yes.

   • To edit a record, double-click the record. Update the information and select Save.

   • To delete a record, select the record, then select Delete. Select Yes.

Create File

1. On the OR Unemployment Report page, select Report.

2. Select the Year and Quarter.

3. Create a hard copy of the report to verify data before you create the electronic file:

   1. Under File Type, select Hard Copy.

   2. Under File Format, select PDF or Excel.

   3. If you have security to view the Social Security number without masking and want to include the entire Social Security Number, select Print Full Social Security Number.

   4. Select Create, then Yes.

4. Save the file and navigate to the folder containing the report file.

5. Inspect the file. Update data if needed.

6. Repeat these steps until all required data is included.

7. Create the electronic file:

   1. Under File Type, select Electronic File.

   2. Select Create, then Yes.

8. Save the file and select OK.

Follow the state's submission procedures.

Purge Data

You can purge the data for the report when you want to:

• Discard the data for the report.

• Change the setup or employee data and reload the data.

To purge report data:

1. Select Purge.

2. Select the Year and Quarter.

3. Select Submit.

4. Select Yes, then OK.