Staff Roster Record Extract

Process Current School Only

Choose either Yes or No from the drop down menu:

• No – This is the default value if the report is being run from the district office. If no is selected staff from all schools will be included in the report.
• Yes – If this option is selected only staff from the current school will be included in the report.

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 Control (CTRL) 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.

Staff List Option*

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

• Select Staff – Run the report for the staff members selected in the Select Staff selection list (see below).
• All Staff – Run the report for all staff 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.

Select Staff

If the Staff List Option above is set to ‘Select Staff’, choose the staff to include in the report from the selection list. Select multiple staff using the Control (CTRL) key. The selection is ignored if the Staff List Option is set to ‘All Staff’

Submission Type

Select the Submission Type:

• October
• End of Year

Please select when to run

Select when to run the report:

• Run now – the report runs when the Submit button is clicked.
• Schedule – set up the date, time and recurrence of the report.

Please select schedule settings

Only visible when ‘Schedule’ is selected above. Enter or select the following:

• Start Date
• Start Time
• Run Once or Repeat (Daily, Weekly, Monthly, Yearly)

SR01

MEPID

The MEPID of the staff member. This field is entered on the Edit Information page, Start Page > Staff > Select A Staff Member > Edit Information.

[S_MA_USR_X]MEPID

Alpha-numeric

8

SR02

Local Employee Number

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

[S_MA_USR_X]LocalEmpNum if present or [Users]TeacherNumber

Alpha-numeric

20

SR03

License/Certification Number

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

[S_MA_USR_X]LicenseCertificationNum

Alpha-numeric

20

SR04

First Name

The first name of the staff member. This field is entered on the Edit Information page, Start Page > Staff > Select A Staff Member > Edit Information > Name.

[Users]First_Name

Alpha-numeric

30

SR05

Middle Name/Initial

The middle name of the staff member.

If Extended Middle Name is entered on the Edit Staff Roster Record page, that value is reported.

Extracted as ‘NMN’ if no middle name is entered in either field.

[S_MA_USR_Demographic_X] StateOverride_MiddleName, if present or [Users]Middle_Name

Alpha-numeric

30

SR06

Last Name

The last name of the staff member. This field is entered on the Edit Information page, Start Page > Staff > Select A Staff Member > Edit Information > Name.

[Users]Last_Name

Alpha-numeric

30

SR07

Date of Birth

The staff member’s date of birth. This field is entered on the Edit Information page, Start Page > Staff > Select A Staff Member > Edit Information > DOB.

[UsersCoreFields]DOB

Date

10

SR08

Race-Ethnicity

The staff member’s ethnicity. This field is calculated by concatenating the following fields from the Edit Information page, Start Page > Staff > Select a Staff Member > Edit Information:

• Ethnicity
• Race

[Users]FedEthnicity and [TeacherRace]RaceCd are used to calculate [S_MA_USR_X]EthnicityRaceCode

Numeric

N/A

SR09

Employment Status

The staff member’s employment status. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR09 Employment Status at Time of Data Collection.

[S_MA_USR_StaffRoster_X] EmployStatusCollTime

Alpha-numeric

2

SR10

Reason for Exit

The reason the staff member left the school district. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR10 Reason for Exit.

[S_MA_USR_StaffRoster_X] ReasonForExit

Alpha-numeric

2

SR11

Date of Hire

The date the staff member was hired. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR11 Date of Hire.

[S_MA_USR_StaffRoster_X]DateOfHire

Date

10

SR12

Federal Salary Source 1

The first Federal salary source for this staff member. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR12 Federal Salary Source 1.

[S_MA_USR_StaffRoster_X] FedSalarySource1

Alpha-numeric

3

SR13

Percent of Federal Salary Source 1

The percentage of the Federal Salary Source. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR13 Percent of Federal Salary Source 1.

[S_MA_USR_StaffRoster_X] PercentFedSalarySource1

Numeric

5 with 3 decimal places

SR14

Federal Salary Source 2

The second Federal salary source for this staff member. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR14 Federal Salary Source 2.

[S_MA_USR_StaffRoster_X] FedSalarySource2

Alpha-numeric

3

SR15

Percent of Federal Salary Source 2

The percentage of the Federal Salary Source. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR15 Percent of Federal Salary Source 2.

[S_MA_USR_StaffRoster_X] PercentFedSalarySource2

Numeric

5 with 3 decimal places

SR16

Federal Salary Source 3

The third Federal salary source for this staff member. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR16 Federal Salary Source 3.

[S_MA_USR_StaffRoster_X] FedSalarySource3

Alpha-numeric

3

SR17

Percent of Federal Salary Source 3

The percentage of the Federal Salary Source. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR17 Percent of Federal Salary Source 3.

[S_MA_USR_StaffRoster_X] PercentFedSalarySource3

Numeric

5 with 3 decimal places

SR18

Degree Type 1

The first type of degree earned by the staff member. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR18 Degree Type 1.

[S_MA_USR_StaffRoster_X] DegreeType1

Alpha-numeric

3

SR19

Degree Institution 1

The institution from which the staff member earned the first degree. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR19 Degree Institution 1.

[S_MA_USR_StaffRoster_X] DegreeInstitution1

Alpha-numeric

4

SR20

Degree Subject 1

The subject of the staff member’s first degree. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR20 Degree Subject 1.

[S_MA_USR_StaffRoster_X] DegreeSubject1

Alpha-numeric

2

SR21

Degree Type 2

The second type of degree earned by the staff member. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR18 Degree Type 1.

[S_MA_USR_StaffRoster_X] DegreeType2

Alpha-numeric

3

SR22

Degree Institution 2

The institution from which the staff member earned the second degree. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR19 Degree Institution 1.

[S_MA_USR_StaffRoster_X] DegreeInstitution2

Alpha-numeric

4

SR23

Degree Subject 2

The subject of the staff member’s second degree. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR20 Degree Subject 1.

[S_MA_USR_StaffRoster_X] DegreeSubject2

Alpha-numeric

2

SR24

Degree Type 3

The third type of degree earned by the staff member. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR18 Degree Type 1.

[S_MA_USR_StaffRoster_X] DegreeType3

Alpha-numeric

3

SR25

Degree Institution 3

The institution from which the staff member earned the third degree. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR19 Degree Institution 1.

[S_MA_USR_StaffRoster_X] DegreeInstitution3

Alpha-numeric

4

SR26

Degree Subject 3

The subject of the staff member’s third degree. This field is extracted from Start Page > Staff > Select A Staff Member > Edit Information > Staff Roster Record > SR20 Degree Subject 1.

[S_MA_USR_StaffRoster_X] DegreeSubject3

Alpha-numeric

2

SR27

Exit Date

The month, day, and year in which an individual exits the district

[S_MA_USR_StaffRoster_X] StaffExitDate

Alphanumeric

10

SR28

District Level Educator’s Professional Teacher Status

Educator’s current professional teacher status as determined by district policies. This element should be completed for all staff and include 00 if the status is not relevant for a specific educator

[S_MA_USR_StaffRoster_X] DistLvlEducProfTeacherStatus

Alpha-numeric

2

SR29

Overall Annual Summative Evaluation or Formative Evaluation Rating

Educator’s current schoolyear overall Summative Evaluation rating or Formative Evaluation rating defined in 603 CMR 35.00

[S_MA_USR_StaffRoster_X] StdEvalRating29

Alpha-numeric

2

SR30

Standard (1) Evaluation Rating

Educator’s current school year evaluation rating on Standard (1).

[S_MA_USR_StaffRoster_X] StdEvalRating30

Alpha-numeric

2

SR31

Standard (2) Evaluation Rating

Educator’s current school year evaluation rating on Standard (2).

[S_MA_USR_StaffRoster_X] StdEvalRating31

Alpha-numeric

2

SR32

Standard (3) Evaluation Rating

Educator’s current school year evaluation rating on Standard (3).

[S_MA_USR_StaffRoster_X] StdEvalRating32

Alpha-numeric

2

SR33

Standard (4) Evaluation Rating

Educator’s current school year evaluation rating on Standard (4).

[S_MA_USR_StaffRoster_X] StdEvalRating33

Alpha-numeric

2

SR34

Impact on Student Learning Growth and Achievement Rating

Educator’s current school year rating on impact on student learning growth and achievement.

[S_MA_USR_StaffRoster_X] ImpStudLearnGrowthAchRating

Alpha-numeric

2

SR35

Educator Evaluation Plan

No longer collected - extracts '99' for all staff

N/A

Alpha-numeric

2

SR36

Staff Days of Attendance

Number of days the educator was present in the school for the school year.

[S_MA_USR_StaffRoster_X] StaffActualAttendDays

Alpha-numeric

3

SR37

Staff Expected Days of Attendance

Number of days the educator was scheduled or expected to be present in the school for the current school year.

[S_MA_USR_StaffRoster_X] StaffExpectedAttendDays

Alpha-numeric

3