ORS-PSERS - Maintain data - MIP Wage and Service tab

Use the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page to view, add, update, and delete employee wage and service records for Michigan Office of Retirement Services (ORS) reporting. This tab displays detailed wage and service credit information to be submitted to ORS for employees participating in the Michigan Public School Employees Retirement System (MPSERS) Member Investment Plan (MIP).

If errors are encountered during the Load data process, you can correct the source data on the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) 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 MI ORS-PSERS (Public School Employees Retirement) page, filter records using the 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, click Add Record. Select the MIP Wage and Service tab and then select Add Record. Refer to the Field descriptions and enter valid information in the required fields. Select Add and then select Save.
  - To edit a record, select the ellipsis in the Actions column and then select Edit. Update the information, select Update, and then select Save.
  - To delete a record, select the ellipsis in the Actions column and select Delete.

Field descriptions

The following table describes the fields on the MIP Wage and Service form of the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page.

Field	Description	Load logic - Data source and Valid values
Start	The beginning date of the reporting period for this wage and service record. Typically aligns with the starting check date entered during the load process.	Calculated during the data load process. The calculated value represents the beginning date of the reporting period. The value is initially set from the Starting Check Date field on the MI ORS-PSERS - Load page. For retroactive payment records, the start date is overridden with the corresponding retroactive pay period Start Date from the Retro-Active Pays section on the MI ORS-PSERS - Load page.
End	The ending date of the reporting period for this wage and service record. Adjusted to the employee's termination date if the employee terminated during the period.	Calculated during the data load process. The calculated value represents the ending date of the reporting period. The value is initially set from the Ending Check Date field on the MI ORS-PSERS - Load page. If the employee's termination date falls within the reporting period, the end date is adjusted to that date. For retroactive payment records, the end date is overridden with the corresponding retroactive pay period End Date from the Retro-Active Pays section on the MI ORS-PSERS - Load page.
Class	The ORS (Office of Retirement Services) class code that identifies the employee's retirement classification for this wage record. Used to determine contribution rates and service credit.	For a list of valid values, refer to 13.02.01: Detail 2 records - employment class codes and definitions. Calculated during the data load process. The calculated value represents the ORS retirement class code for the wage record. The system first attempts to look up the class on the MI ORS-PSERS - Reference Tables - ORS Class Crosswalk page using the job classification from the check history record. If a crosswalk entry exists, the ORS class code is used. Otherwise, the job classification from the check history record is used. For retiree employees, the class code is retrieved from the Class (Acct) field on the Payroll Information - State Required page.
Wage Code	The two-digit code identifying the type of wages being reported.	For a list of valid values, refer to 13.02.02: Detail 2 records - wage codes. Calculated during the data load process. The calculated value represents the type of wages being reported to ORS. The system determines the wage code based on the following criteria: Regular wages are assigned code 01. Retroactive payments are assigned code 04 based on the Retro-active Pays configuration on the MI ORS-PSERS - Load page. Wages with no member contributions for retirees are assigned code 07. Wages with no service (hours outside pay rate class date range in Q2/Q3) are assigned code 08. Adjustment codes (05, 06) are assigned for positive/negative adjustments.
Wages	The total reportable wages earned by the employee during the reporting period for this class code. This amount is subject to retirement contributions.	Populated during the data load process. The field value is retrieved from the Amount field on the employee's Check History page for earnings with a retirement deduction.
Pay Rate	The employee's annual salary amount used for retirement reporting purposes. May represent the primary pay rate or a sum of multiple pay rates, depending on configuration. The pay rate is required to be reported in each pay period based on the member's classification: Hourly employees: Report the hourly rate based on the pay schedule. Contract/salaried employees: Report pay rate representing the full amount of compensation allowed by the contract that is recognized as compensation by law and would be earned in the entire school year, even if only part of the year is worked.	Calculated during the data load process. The calculated value represents the employee's annual salary. The value is retrieved from the Annual Salary field on the Pay Rate Information page. Depending on the state configuration, the system may sum annual salaries from all active pay rates or use only the primary pay rate. Non-reportable pay codes are excluded from the sum.
EE Contrib.	The employee's retirement contribution amount deducted from wages for this class code during the reporting period. Prorated when an employee has multiple class codes.	Calculated during the data load process. The calculated value represents the employee's retirement contribution amount for this class code. The total employee deduction amount from the check history is prorated across all wage/service records based on the proportion of wages for each class code. The formula is: (Wages for this class ÷ Total wages for all classes) × Total employee deduction amount.
ER Contrib.	The employer's retirement contribution amount paid on behalf of the employee for this class code during the reporting period. Prorated when an employee has multiple class codes.	Calculated during the data load process. The calculated value represents the employer's retirement contribution amount for this class code. The total employer fringe/benefit amount from the check history is prorated across all wage/service records based on the proportion of wages for each class code. The formula is: (Wages for this class ÷ Total wages for all classes) × Total employer contribution amount.
Hours	The hours worked for retirement service credit during the reporting period. FLSA overtime premium hours are excluded. Used by ORS to calculate service credit for hourly employees. This field’s calculated value excludes FLSA overtime. For accurate FLSA overtime calculation, ensure that the Fair Labor Standards Act (FLSA) work cycles used in your organization are configured correctly.	Calculated during the data load process. The calculated value represents the hours worked for retirement service credit. The system calculates hours based on pay method and pay code type: For Full Day Pay Codes: Hours from check history × Hours Per Day from the MI ORS-PSERS - Reference Tables - Full and Half Day Pay Codes page. For Half Day Pay Codes: Hours from check history × Hours Per Day from the MI ORS-PSERS - Reference Tables - Full and Half Day Pay Codes page. For Hourly/Salaried employees: Hours from check history or Pay Hours from the Pay Rate Information page. Hours are excluded (set to zero) for FLSA overtime premium records, retroactive payments (Wage Code 04), and the Retirement Hour Exempt Pay Codes on the Human Resources Profile – State page.
Excpt. Wage	The exception wage amount for the employee. Used for reporting wages that differ from the standard calculation, such as for employees with special wage agreements.	Populated during the data load process. The field value is retrieved from the Special Exempt field on the Payroll Information - State Required page. This represents the employee's exception wage amount for ORS reporting.
Freq.	The pay frequency indicating the number of pay periods per year for the employee (e.g., 12 for monthly, 24 for semi-monthly, 26 for bi-weekly).	Populated during the data load process. The field value is retrieved from the Pays/Year field on the Pay Rate Information page. This represents the number of pay periods per year for the employee's pay rate.
Cont. Begin	The contract start date for salaried or contract employees. Indicates when the employee's employment contract period begins for the current fiscal year.	Calculated during the data load process. The calculated value represents the contract start date. If Contract Position is selected on the Pay Rate Information page, the value is retrieved from the Start Date field on the same page. For salaried employees without a contract flag, the value defaults to the Fiscal Year Start date on the Fund Accounting Profile page. For hourly employees without a contract, this field is blank.
Cont. End	The contract end date for salaried or contract employees. Indicates when the employee's employment contract period ends for the current fiscal year.	Calculated during the data load process. The calculated value represents the contract end date. If Contract Position is selected on the Pay Rate Information page, the value is retrieved from the End Date field on the same page. For salaried employees without a contract, the value defaults to the Fiscal Year End date on the Fund Accounting Profile page. For hourly employees without a contract, this field is blank.