Staff Assignment File

Select Schools*

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.

Report Start Date

Enter the desired report start date

Report End Date

Enter the desired report end date

Select to calculate instructional hours using:

• Bell Schedule Minutes
• Course Average Daily Minutes Scheduled Field

File Name

OR_ClassRoster_[SchoolID/DistrictNumber]_[Timestamp].csv

Destination

The report defaults to the Reporting Queue.

Scheduling

Choose a time to run the report from following options:

• Run Now (default)
• Schedule

A

Unique Staff Identifier

ODE Unique Staff Identifier

[S_OR_USR_X]UniqueStaffID

int

10

B

Teacher Standards and Practices Commission Account Identifier

TSPC (Teacher Standards and Practices Commission) assigned account identifier.

[S_OR_USR_X]TSPCAcctID

varchar

10

C

Employer Institution Identifier

ODE Institution Identification number for the institution employing the staff member.  If a staff member is employed by more than one institution this field will indicate the last employer to update the record.

[Schools]Alternate_School_Number

[Schools]School_Number

int

10

D

Employer Staff Identifier

Identifier assigned by the employer used to identify the staff member.  This identifier should be unique within the employer system that assigned it.

[Users]TeacherNumber

varchar

10

E

Partial Social Security Number

Last four (4) digits of the Social Security Number of the staff member.

[Users]SSN

varchar

4

F

Legal Last Name

Legal Last Name of the staff member.

[Users]Last_Name

varchar

50

G

Legal First Name

Legal First Name of the staff member.

[Users]First_Name

varchar

40

H

Legal Middle Initial

Legal Middle Initial of the staff member.

[Users]Middle_Name

char

1

I

Date of Birth

Date of Birth of the staff member.

[UserCoreFields]DOB

varchar

8

J

Gender Code

Code indicating the gender of the staff member.

[UserCoreFields]Gender

char

1

K

Hispanic/Latino Ethnic Flag

Indicates a staff member of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. The term, “Spanish origin,” can be used in addition to “Hispanic or Latino.”

[Users]FedEthnicity

char

1

L

American Indian/Alaskan Native Race Flag

Indicates a staff member having origins in any of the original peoples of North and South America (including Central America), and who maintains tribal affiliation or community attachment.

[TeacherRace]RaceCd

When [TeacherRace]RaceCd = I

char

1

M

Asian Race Flag

Indicates a staff member having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam.

[TeacherRace]RaceCd

When [TeacherRace]RaceCd = A

char

1

N

African American Race Flag

Indicates a staff member having origins in any of the black racial groups of Africa.

[TeacherRace]RaceCd

When [TeacherRace]RaceCd = B

char

1

O

White Race Flag

Indicates a staff member having origins in any of the original peoples of Europe, the Middle East, or North Africa.

[TeacherRace]RaceCd

When [TeacherRace]RaceCd = W

char

1

P

Native Hawaiian/Other Pacific Islander Race Flag

Indicates a staff member having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.

[TeacherRace]RaceCd

When [TeacherRace]RaceCd = P

char

1

Q

Filler

Filler

N/A

varchar

21

R

Instructional Unit Identifier (IUID)

ODE assigned Instructional Unit Identifier (IUID) with a trailing check digit.

[S_OR_SEC_X]InstrctUnitID

int

10

S

District Institution Identifier

ODE Institution Identification number for the ESD or District administering the program or school in which the class being reported is situated.

[prefs]value when name=’districtname’

int

10

T

School Institution Identifier

ODE Institution Identification number for the program or school where the class being reported is conducted.

[Schools]Alternate_School_Number

[Schools]School_Number

int

10

U

District Section Identifier

Identifier that distinguishes the specific instance of a class being reported.  This identifier can be any convention used by the institution.

[Sections]Section_Number

char

15

V

District Course Identifier

Local identifier, assigned by the district, used to uniquely identify the course.

[Sections]Course_Number

varchar

15

W

Course Code

The alternate course number. This is the National Center for Education Statistics (NCES) or Non-NCES code for the course that is taught in the location identified by the combination of Class Room ID and Class Period.

[Courses]Alt_Course_Number

varchar

6

X

Course Begin Date

The date the course started.

[Terms]FirstDay

date

8

Y

Team Teaching Flag

Flag indicating that the course is being team taught.

[SectionTeacher] when there is a teacher assigned with a role that is not Lead Teacher

char

1

Z

Teacher License Flag

Flag indicating this teacher is licensed, or registered, with TSPC (Teacher Standards and Practices Commission).

[S_OR_USR_X]TSPCLicensed

char

1

AA

Class Instructional Hours

This total represents yearly hours of instruction that this teacher is scheduled to teach this class.

If Sections field is blank, the Course field is reported.

If both Course and Section is blank, the value will be calculated at run-time by looking at either the Course/Section Average Daily Minutes field or Bell Schedule Minutes. (For more information see Report Description above).

[S_OR_CRS_X]YearlyCourseInstructionalHours

[S_OR_SEC_X]YearlyCourseInstructionalHours

int

4

AB

This number represents the total number of hours of instruction for a full-time schedule at this school.

Note: The School level value is reported unless overridden at the teacher level.

[S_OR_SCH_X]FullTimeSchedHours

[S_OR_SSF_X]FullTimeSchedHours

int

4

AC

Alternate License Last Name

The other last name that may be used on the teacher's license.

[S_OR_USR_X]AlternateLicNumber

varchar

50

AD

Qualification Comment

A comment field for explanation of teacher's licensure.

[S_OR_USR_HQ_C]HQPlanCmnt

varchar

200

AE

Emergency/Provisional Determination Flag

ODE determination of a teacher holding an emergency or provisional license for this course.

Not Reported

char

1

AF

Out of Field Determination Flag

ODE determination of teacher being out of field for this course.

Not Reported

char

1

AG

Preliminary Determination Flag

ODE determination of teaching holding a preliminary license for this course.

Not Reported

varchar

2

AH

Class Instructional Full Time Equivalency

ODE Calculation of the amount of a full time instructional schedule that this class (IUID) constitutes.

Not Reported

varchar

2

AI

N/A

varchar

1