Skip to main content
Skip table of contents

PERA Exclusion Report

According to Minnesota law, school districts and local government units that meet the definition of a governmental subdivision are required to submit an Annual Exclusion report to PERA. The report aims to list all employees and elected or appointed non-governing body public officials who do not have coverage in a PERA retirement plan or another statewide system, such as TRA or the Minnesota State Retirement System. After receiving the exclusion report, the PERA reviews the report and may contact the employer with questions about a person’s exclusion from membership in a PERA Defined Benefit Plan.

For more information, you can refer to the Annual Exclusion Reports section in the PERA Employer Manual.

Menu path

From the Human Resources menu, select State. From the State - MN menu, select PERA Exclusion Report.

Submission period

At the end of the fiscal year.

Selection rule

Employees and non-governing body elected officials who worked any amount during the fiscal or calendar year and did not have pension deductions withheld from their earnings are selected and reported.

Prerequisites

Load data

Use the MN PERA Exclusion Report - Load page to specify the criteria for loading the required data for the report.

  1. On the MN PERA Exclusion Report page, select Load.

  2. In the Load Criteria section, select the Exclusion Year from the list.

  3. In the Fiscal Year Start field, select the exclusion year start date.

  4. In the Fiscal Year End field, select the exclusion year-end date.

  5. Select Load, and then Yes.

  6. If data for the selected criteria is loaded, select Yes to delete and reload the data.

  7. Save the Load Summary report file and select OK.

  8. Navigate to the file location.

  9. Inspect the file. Refer to Maintain data and update the data if needed.

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

Maintain data

If errors are encountered during the Load data process, you can correct the source data on the <name> form of the <name> page. After corrections, you must purge and reload the data.

PowerSchool recommends that you correct the report’s source data that is retrieved from the Core application.

  • On the MN PERA Exclusion Report page, you can filter records using filter criteria. To enter filter criteria:

    1. Select an option in the first field.

    2. Select or enter a value.

    3. Select Add if the button is enabled.
      Refer to Search for records for more information.

      • To add a record, select Add Record. Refer to the Field descriptions and enter valid information in the required fields. Select Save, then Yes.

      • To edit a record, select the ellipsis in the Actions column and then select Edit. Update the information and select Save.

      • To delete a record, select the ellipsis in the Actions column, select Delete, and then select Yes.

      • To download the information, select Download, and then select Download PDF or Download as an Excel Document.

Field descriptions

The following table describes the fields on the MN PERA Exclusion Report Information form of the MN PERA Exclusion Report page.

Field

Description

Load logic - Data source and Valid values

Exclusion Year 

The calendar or fiscal year of the report.

Valid values are 2014 and later.

Employee Number

The employee number.

Select Lookup to search for and select an employee number.

This field is view-only.

The field value is retrieved from the Employee Number field on the Employee Information page.

Exclusion Code

The exclusion reason code.

Valid values:

  • 001 - Full-Time Student < 23

  • 002 - TRA Annuitants

  • 003 - Receiving PERA Benefit

  • 004 - Foreign Citizen

  • 005 - Federal Service Excl

  • 006 - Degree or Residency PGM

  • 007 - Student Internship

  • 008 - Patient/Inmate Personnel

  • 010 - Pension Coverage Prohibtd

  • 011 - Supported Empl/Work Study

  • 012 - Trades Worker

  • 101 - Temporary Position < 6 MO

  • 102 - Emergency Employee

  • 103 - Part-Time Teaching Serv

  • 104 - Paid/Volunteer Ambulance

  • 105 - Election Official

  • 106 - Seasonal Position

  • 108 - Paid/Volunteer Firefighte

  • 201 - Elected Official

  • 301 - Earning <= $425/Month

The field value is retrieved from the PERA Exclusion field on the Payroll Information - State Required page.

This field value overrides the PERA Exclusion field value on the Payroll Information - State Required page.

The values in the drop-down list are retrieved from the User Defined Table EX.

Social Security

The employee's Social Security number. 

This field is view-only.

The field value is retrieved from the Social Security field on the Employee Information page.

Last Name

The employee's last name.

The field value is retrieved from the Last Name field on the Employee Information page.

This field value overrides the Last Name field value on the Employee Information page.

First Name

The employee’s first name.

The field value is retrieved from the First Name field on the Employee Information page.

This field value overrides the First Name field value on the Employee Information page.

Middle Initial

The employee’s middle initial.

The field value is retrieved from the Middle Name field on the Employee Information page.

This field value overrides the Middle Name field value on the Employee Information page.

Original Hire Date

The actual hire date of the employee.

The field value is retrieved from the Original Hire field on the Employment tab of the Employee Information page.

This field value overrides the Original Hire field value on the Employment tab of the Employee Information page.

Last Hire Date

The original hire date or the latest hire date.

The date may differ from the original if the employee quit and rejoined later.

The field value is retrieved from the Hire Date field on the Employment tab of the Employee Information page.

This field value overrides the Hire Date field value on the Employment tab of the Employee Information page.

Employee Status

The status of the employee.

Valid values:

  • A - Active

  • T - Terminated

The field value is retrieved from the Status field on the Terminate Employee page.

This field value overrides the Status field value on the Terminate Employee page.

Annual Salary

The employee’s annual salary.

The field value is retrieved from the Total Gross - Year field on the Earnings tab of the Employee Information page.

This field value overrides the Total Gross - Year field value on the Earnings tab of the Employee Information page.

Last Paid Amount

The last amount paid to the employee.

The field value is retrieved from the employee’s Check History.

This field value overrides the employee’s Check History field value.

Pay Cycle

The pay cycle of the employee.

Valid values:

  • 1 - Monthly

  • 2 - Semi-Monthly

  • 3 - Bi-weekly

  • 4 - Quarterly

  • 5 - Yearly

  • 6 - Semi-Yearly

  • 7 - Weekly

  • 8 - Bi-Monthly

  • 9 - Lump Sum

The field value is retrieved from the Pay Frequency field on the Payroll tab of the Employee Information page.

This field value overrides the Pay Frequency field value on the Payroll tab of the Employee Information page.

Job Title

The job title of the employee.

The field value is retrieved from the PERA Job Title field on the Payroll Information - State Required page.

This field value overrides the PERA Job Title field value on the Payroll Information - State Required page.

Create file

  1. On the MN PERA Exclusion Report page, select Report.

  2. Select the Exclusion Year.

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

    1. Select Hard Copy.

    2. Select PDF or Excel.

    3. If you have the security permission to review the entire Social Security number (without masking) and want to include it, select Print Full Social Security Number.
      The required access privileges are granted by assigning the appropriate security resource.

    4. Select Create and then select Yes.

  4. Save the file and select OK.

  5. Navigate to the folder containing the report file.

  6. Inspect the file. Update data if needed.

  7. Repeat these steps until all the required data is included.

  8. Create the electronic file:

    1. Select Electronic File.

    2. Select Create, and then Yes.

    3. Save the file and select OK.

The default file name is <PERAX><PERA Employer Number><Exclusion Year>.txt. For example, PERAX1308002019.txt.

For information about file layout, refer to PERA Exclusion Report - File Layout and Data Mapping.

Purge data

If you need to correct setups or employee data, purge the existing records and reload the data.

  1. On the MN PERA Exclusion Report page, select Purge.

  2. Select the Exclusion Year.

  3. Select Submit.

  4. Select Yes, and then OK.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.