Set up user-defined codes used in MI State reporting. The following are the user-defined tables:
|
Table |
Description |
Referencing Report |
|---|---|---|
|
Educator Effectiveness Used in the Effectiveness field on the Employee Defined Page 500 MEIS REP page. |
||
|
Retirement Code Used in the Retire Code field on the Michigan Retirement page. |
ORS-PSERS (Public School Employees Retirement) – Federal/ORP Wages Report |
|
|
Non-Reportable Pay Codes for DTL2 Used in the Table Code for Pay Codes not Reportable for DTL2 field on the Human Resources Profile - State page. You can use any name for this table. In this procedure, we will use the table name NR. |
||
|
Non-Reportable Pay Codes for DTL4 Used in the Table Code for Pay Codes not Reportable for DTL4 field on the Human Resources Profile - State page. You can use any name for this table. In this procedure, we will use the table name D4. |
Populate EF
-
On the start page, select Human Resources.
-
Select Reference Tables, then from the Personnel menu, select User Defined Codes.
-
Select Add new.
-
Enter the Table Code as EF.
-
In the Code field, enter a code from the Educator Effectiveness Codes (for example, 01).
-
In the Title field, enter the corresponding title from the Educator Effectiveness Codes (for example, Highly Effective).
-
Select Accept.
-
Repeat these steps for the remaining codes listed under Educator Effectiveness Codes.
Educator Effectiveness Codes
|
Code |
Title |
|---|---|
|
01 |
Highly Effective |
|
02 |
Effective |
|
03 |
Ineffective |
|
08 |
Minimally Effective |
|
09 |
Exemption |
|
12 |
Effective |
|
13 |
Developing |
|
14 |
Needing Support |
|
15 |
Exemption: Teacher Effective |
|
16 |
Exemption: Administrator Effective |
|
17 |
Unevaluated: Worked Less than 60 days |
|
18 |
Unevaluated: Extenuating Circumstances |
|
19 |
Unevaluated: Vacated due to Grievance |
Populate RC
-
On the start page, select Human Resources.
-
Select Reference Tables, then from the Personnel menu, select User Defined Codes.
-
Select Add new.
-
Enter the Table Code as RC.
-
In the Code field, enter a code from the Retirement Codes (for example, 01).
-
In the Title field, enter the corresponding title from the Retirement Codes (for example, Regular Employee).
-
Select Accept.
-
Repeat these steps for the remaining codes listed under Retirement Codes.
Retirement Codes
|
Code |
Title |
How is it used |
|---|---|---|
|
01 |
Regular Employee |
ORP gross amount is set to zero for employees with this code |
|
02 |
Exclude from Federal/ORP |
Employees with this code are excluded from the Federal/ORP Wages report |
|
03 |
Retiree |
ORP gross amount is set to zero for employees with this code |
|
09 |
Substitute |
ORP gross amount is set to zero for employees with this code |
|
11 |
Employee with ORP |
ORP gross amount is reported for employees with this code |
Populate User-Defined Table For Non-Reportable Pay Codes for DTL2
When the retirement records are loaded, if an employee is a retiree and the pay code is in this user-defined table, the earnings associated with the pay code are not reported as retirement wages on the DTL2 (Wage and Service) record. They are included in the Non-Retirement Wages report.
-
On the start page, select Human Resources.
-
Select Reference Tables, then from the Personnel menu, select User Defined Codes.
-
Select Add new.
-
Enter the Table Code as NR.
-
Enter a Code and Title of your choice.
While the Code and Title do not have to be an exact match, they should help you recognize the code.
-
Select Accept.
-
Repeat these steps for the other non-reportable pay codes for DTL2.
Populate User-Defined Table For Non-Reportable Pay Codes for DTL4
When the retirement records are loaded, if an employee is a retiree and the pay code is in this user-defined table, the earnings associated with the pay code are not reported as retirement wages on the DTL4 (DC Contributions) record.
-
On the start page, select Human Resources.
-
Select Reference Tables, then from the Personnel menu, select User Defined Codes.
-
Select Add new.
-
Enter the Table Code as D4.
-
Enter a Code and Title of your choice.
While the Code and Title do not have to be an exact match, they should help you recognize the code.
-
Select Accept.
-
Repeat these steps for the other non-reportable pay codes for DTL4.