PowerSchool ERP Michigan

Upload Effectiveness

Use the Upload Effectiveness option to upload Educator Effectiveness codes from a file.

The file must follow this format:

  • No header row

  • Tab-separated into two columns

  • .dat extension

The file must contain the following columns:

Column Name

Maximum Length

Note

Social Security Number

11

With or without dashes

Educator Effectiveness Code

2

Valid values:

  • 01 = Highly Effective

  • 02 = Effective

  • 03 = Ineffective

  • 04 = Exceeds Goals

  • 05 = Meets Goals

  • 06 = Progressing Towards Goals

  • 07 = Does not Meet Goals

  • 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

Upload The Effectiveness File

  1. Choose Upload Effectiveness.

  2. Click Choose File.

  3. Navigate to the file location and select the file.

  4. Click Open.

  5. Click Load.

For each employee whose Social Security number is in the Effectiveness file, the system updates the Effectiveness field on the Employee Defined Page 500 – MEIS REP page to the Effectiveness code from that file.

Run the Load Employee Information process to update the records in the Compliance table.