Staff Assignment File Layout

Unique Staff Identifier

10

Y

Y

1 - 10

N/A

or_usid_download.staff_id

Not found in eSchoolPlus. You load USIDs into the download table following the procedure Uploading Staff USIDs Using a File.

Teacher Standards and Practices Commission Account Identifier

10

N

N

11 - 20

N/A

or_usid_download.tspc_id

Not found in eSchoolPlus.

Employer Institution Identifier

10

Y

Y

21 - 30

N/A

or_usid_download.building

Not found in eSchoolPlus.

Employer Staff Identifier

10

N

N

31 - 40

N/A

or_usid_download.ode_id

Not found in eSchoolPlus.

Partial Social Security Number

4

Y

Y

41 - 44

N/A

or_usid_download.SSN

Not found in eSchoolPlus.

Legal Last Name

50

Y

N

45 - 94

N/A

or_usid_download.legal_last_name

Not found in eSchoolPlus.

Legal First Name

40

Y

N

95 - 134

N/A

or_usid_download.legal_first_name

Not found in eSchoolPlus.

Legal Middle Initial

1

N

N

135 - 135

N/A

or_usid_download.legal_mid_initial

Not found in eSchoolPlus.

Date of Birth

8

Y

Y

136 - 143

N/A

or_usid_download.birthdate

Not found in eSchoolPlus.

Gender Code

1

Y

N

144 - 144

N/A

or_usid_download.gender

Not found in eSchoolPlus.

Hispanic/Latino Ethnic Flag

1

Y

N

145 - 145

N/A

or_usid_download.ethnicity

Not found in eSchoolPlus.

American Indian/Alaskan Native Race Flag

1

Y

N

146 - 146

N/A

or_usid_download.amer_ind_als_race

Not found in eSchoolPlus.

Asian Race Flag

1

Y

N

147 - 147

N/A

or_usid_download.asian_race

Not found in eSchoolPlus.

African American Race Flag

1

Y

N

148 - 148

N/A

or_usid_download.black_race

Not found in eSchoolPlus.

White Race Flag

1

Y

N

149 - 149

N/A

or_usid_download.white_race

Not found in eSchoolPlus.

Native Hawaiian/Other Pacific Islander Race Flag

1

Y

N

150 - 150

N/A

or_usid_download.pac_islnd_race

Not found in eSchoolPlus.

Filler

21

N

N

151 - 171

Instructional Unit Identifier

10

Y

Y

172 - 181

schd_ms_user.field_value where screen_number = '700' and field_number = '19'

or_stafassign_down.iuid

Scheduling > Courses > District Courses > OR OPTE Information: IUID field

District Institution Identifier

10

Y

Y

182 - 191

reg_district.district

or_stafassign_down.district

School Institution Identifier

10

Y

Y

192 - 201

reg_staff.building

or_stafassign_down.building

District Section Identifier

15

Y

Y

202 - 216

schd_ms.course_section.

or_stafassign_down.dist_crs_section

District Course Identifier

15

Y

Y

217 - 231

schd_ms.course

or_stafassign_down.dist_course_id

Course Code

6

Y

Y

232 - 237

schd_ms.state_crs_equiv

or_stafassign_down.
course_code

Course Start Date

8

Y

N

238 - 245

reg_mp_dates.start_date

or_stafassign_down.
crs_start_date

Team Teaching Flag

1

Y

N

246 - 246

Calculated based on schd_ms_staff.staff_id. If more than one staff member assigned to section, then Y.

or_stafassign_down.
team_taught

Highly Qualified Status Determination Code

1

Y

N

247 - 247

schd_ms_user.field_value screen_number = 700 and field_number = 3

or_stafassign_down.
hq_code

Highly Qualified Status Comment Code

2

Y

N

248 – 249

schd_ms_user.field_value screen_number = 700 and field_number = 22

or_stafassign_down.hq_status_comment_code

Highly Qualified Status Comment

200

N

N

250 - 449

schd_ms_user.field_value screen_number = 700 and field_number = 4

or_stafassign_down.hq_status_comment

Reason Not Highly Qualified Code

1

N

Y

450 - 451

schd_ms_user.field_value screen_number = 700 and field_number = 5

or_stafassign_down.
not_hq

Highly Qualified Plan Comment

200

N

N

452 – 651

schd_ms_user.field_value screen_number = 700 and field_number = 6

or_stafassign_down.
hq_plan_comment

Teacher Standards and Practices Commission License Flag

1

N

N

652 – 652

N/A

or_stafassign_down.staff_tspc

Teacher License Flag

1

Y

N

653 – 653

schd_ms_staff_user.field_value where field_number = 2

Default to Y if this field is N (un-checked).

Scheduling > Courses > Course Sections > Master Schedule, then click Primary Staff link on Session Information panel. On the Ataff Date Tracking window, the Teacher License Set to N field determines the flage value.

Report N for No if the checkbox is selected. Otherwise, report Y for Yes when checkbox is not selected.

Low Grade Responsibility Code

2

Y

N

654 – 655

Determine which students are in the course using schd_stu_course and schd_stu_crs_dates, linking to schd_ms_session using the section_key.

For each student, get the reg_entry_with.grade, then, in reg_grade, find the corresponding grade_order value for each student's grade.

Use the lowest reg_grade.grade_order to get the correct reg_grade.state_code_equiv. Zero (0) is considered lowest.

or_stafassign_down.low_grade

Student course dates display on the Date Range Detail panel of the Student Course page (Scheduling > Student Schedules > Student > Schedule Entry, then click appropriate Description link).

For the student's grade level, use Registration > Entry & Reports > Student Demographic > Entry/Withdrawal

For grade level setup, use Administration > General Setup > District > Validation Tables and select the Course Grade table

High Grade Responsibility Code

2

Y

N

656 – 657

Determine which students are in the course using schd_stu_course and schd_stu_crs_dates, linking to schd_ms_session using the section_key.

For each student, get the reg_entry_with.grade, then, in reg_grade, find the corresponding grade_order value for each student's grade.

Use the highest reg_grade.grade_order to get the correct reg_grade.state_code_equiv. Zero (0) is considered lower than one (1).

or_stafassign_down.high_grade

Student course dates display on the Date Range Detail panel of the Student Course page (Scheduling > Student Schedules > Student > Schedule Entry, then click appropriate Description link).

For the student's grade level, use Registration > Entry & Reports > Student Demographic > Entry/Withdrawal

For grade level setup, use Administration > General Setup > District > Validation Tables and select the Course Grade table

Special Education Flag

1

Y

N

658 – 658

schd_ms_user.field_value where screen_number = 700 and field_number = 21

or_stafassign_down.special_education

Scheduling > Courses > Course Sections > OR OPTE Information: Special Education field

Distance Learning Flag

1

Y

N

659 - 659

schd_ms_user.field_value where screen_number = 700 and field_number = 7

or_stafassign_down.distance_learning

Scheduling > Courses > Course Sections > OR OPTE Information: Distance Learning field

Filler

20

N

N

660 – 679