Skip to main content
Skip table of contents

MEPID Extract Report

Introduction

The MEPID Extract creates a file to upload to the state for MEPID ID assignments. The MEPID (Massachusetts Education Personnel ID) is a unique 8-digit ID created for staff members and assigned by the DOE.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Use

Choose one of the following:

  • Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
  • All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The All Schools option is only available when running the report from the District Office.

Records to Include

Indicate which records to include in the report by selecting one of the following options:

  • The selected [number] records only – Run the report for records in the current selection.
  • All records – Run the report for all records in the current school or district that meet the selection criteria.

Note: If running the report for a single record, or group of records, select the records prior to running report.

Processing Options

Choose a time to run the report from the pop-up menu:

  • In Background Now (Recommended) – Execute the report immediately in the background.
  • ASAP – Execute the report in the order it is received in the Report Queue.
  • At Night – Execute the report during the next evening.
  • On Weekend – Execute the report during the next weekend.
  • On Specific Time – Execute the report on the date and time specified.

Specific Date/Time

Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry.

Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05.

Select Schools to be Reported for one Sub District.

Select the schools you want to include in the extract for the sub district. Use this field only for Regional School Districts with Sub Districts. Select multiple schools using the command key.

Note: If your organization runs a single version of PowerSchool with multiple districts, you must use the Sub-district Configuration option to create the Regional School List displayed on this report interface page.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #

Data Element

Description

[Table]FieldName

Field Type

Field Length

ID01

First Name

The first name of the staff member. This field is extracted from the Edit Information page, Start Page > Staff Search > Select A Staff Member > Edit Information > MEPID Assign Record > ID01 First Name.

[Users]First_Name

Alpha-numeric

30

ID02

Middle Name/Middle Initial/NMN

The middle name of the staff member. This field is extracted from the Edit Information page, Start Page > Staff Search > Select A Staff Member > Edit Information > MEPID Assign Record > ID02 Middle Name.

[S_USR_Demographic_X] StateOverride_MiddleName

or

[Users]Middle_Name

Alpha-numeric

30

ID03

Last Name

The last name of the staff member. This field is extracted from Edit Information page, Start Page > Staff Search > Select A Staff Member > Edit Information > MEPID Assign Record > ID03 Last Name.

[Users]Last_Name

Alpha-numeric

30

ID04

Date of Birth

The staff member's date of birth. This field is extracted from the Edit Information page, Start Page > Staff Search > Select A Staff Member > Edit Information > MEPID Assign Record > ID04 Date of Birth.

[UsersCoreFields]DOB

Date

10

ID05

Gender

The staff member's gender, or N if the Nonbinary Gender flag is set. This field is extracted from the Edit Information page, Start Page > Staff Search > Select A Staff Member > Edit Information > MEPID Assign Record > ID05 Gender.

[UsersCoreFields]Gender

[S_USR_Demographic_X]NonBinary_Gender_TF

Alpha-numeric

1

ID06

License/Certification Number

The staff member's license or certification number. This field is extracted from the Edit MEPID Assign Record page, Start Page > Staff Search > Select A Staff Member > Edit Information > MEPID Assign Record > ID06 License Certification Number.

[S_MA_USR_X]LicenseCertificationNum

Alpha-numeric

20

ID07

Local Employee Number

The staff member's employee number assigned by the school or district. This field is extracted from the Edit MEPID Assign Record page, Start Page > Staff Search > Select A Staff Member > Edit Information > MEPID Assign Record > ID07 Local Employee Number.

[S_MA_USR_X]LocalEmpNum

Alpha-numeric

20

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.