Staff Assignment File Layout

1

*DISTRICT CODE

(DISTRICT OF RESPONSIBILITY CODE)

1 - 8

NYS Reporting

reg_district.State_Code_Equiv

If length is not 8 or value does not begin with '8', then use 'NY' followed by first six digits of state_code_equiv

Administration > General Setup > District > District: State Equivalency Code

2

*STAFF ID

9 – 20

NYS Reporting

reg_staff,staff_state_id

Only report if staff member has a record in reg_user_staff_bld where screen_number = 15110 or in reg_user_staff where screen_number = 10250

Administration > Registration Setup > Building > Staff > Staff Information panel: Staff State ID field

Administration > Registration Setup > Building > Staff > Building Information panel > click Building link > District-Defined panel > Staff Assignment link

Administration > Registration Setup > Building > Staff > District-Defined panel > District Wide Staff Assignment link

3

*ASSIGNMENT CODE

21 – 50

NYS Reporting

If the staff member has a record in reg_user_staff_bld where screen_number = 15110, use field_number = 4 for the ENYP submission or field_number = 5 for the PMF submission.

If the staff member has a record in reg_user_staff where screen_number = 10250, use field_number = 3 for the ENYP submission or field number = 4 for the PMF submission.

Administration > Registration Setup > Building > Staff > Building Information panel > click Building link > District-Defined panel > Staff Assignment link: ENYP Assignment Code or PMF Assignment Code

Administration > Registration Setup > Building > Staff > District-Defined panel > District Wide Staff Assignment link: ENYP Assignment Code or PMF Assignment Code

Based on Submission Type selection on the Staff Assignment Download page.

4

*ASSIGNMENT LOCATION CODE

51 – 56

NYS Reporting

reg_staff_bldgs.building unless the record comes from the District Wide Staff Assignment page.

For district-wide staff, use a Location Code of 000000.

Administration > Registration Setup > Building > Staff > Building Information panel > click Building link: Building

5

*SCHOOL YEAR DATE

57 – 66

NYS Reporting

(School Year from Download prompt) + '-06-30'

Regulatory > Downloads > Downloads > NY Staff Assignment Download: School Year followed by -06-30

6

*ASSIGNMENT DATE

67 – 76

 NYS Reporting

If the record is for building-level staff, check if reg_user_staff_bld.field_value for screen_number = 15110 and field_number = 1 is earlier than first day in calendar for prompted School Year from NY Staff Assignment Download.

If yes, use first day in the prompted School Year's calendar.

If the date is later than the first day in the calendar, use reg_user_staff_bld.field_value where screen_number = 15110 and field_number = 1

If the record is for district-level staff, reference reg_user_staff.field_value for screen_number = 10250 and field_number = 1 instead of the reg_user_staff_bld.field_value.

For the School Year, use Regulatory > Downloads > Downloads > NY Staff Assignment Download

Administration > Registration Setup > Building > Staff > Building Information panel > click Building link > District-Defined tab > Staff Assignment: Assignment Date field

Administration > Registration Setup > Building > Staff > District-Defined panel > District Wide Staff Assignment: Assignment Date field

7

*COMPLETION DATE

77 – 86

NYS Reporting

reg_user_staff_bld.field_value where screen_number = 15110 and field_number = 2

Or if this is a district-level staff assignment,

reg_user_staff.field_value where screen_number = 10250 and field_number = 2

Administration > Registration Setup > Building > Staff > Building Information panel > click Building link > District-Defined panel > Staff Assignment: Completion Date field

Or,

Administration > Registration Setup > Building > Staff > District-Defined panel > District Wide Staff Assignment: Completion Date field

8

ASSIGNMENT JOB CODE

87 – 94

Leave blank

N/A

9

ASSIGNMENT FIELD

95 – 144

Leave blank

N/A

10

ASSIGNMENT ROOM

145 – 174

Leave blank

N/A

11

ASSIGNMENT SITE

175 – 224

Leave blank

N/A

12

ASSIGNMENT PROGRAMS CODE

225 – 244

Local use only

Leave blank

N/A

13

OBSOLETE

245 – 264

Leave blank

N/A

14

OBSOLETE

265 – 284

Leave blank

N/A

15

ASSIGNMENT PRIMARY FUND SOURCE CODE

285 – 308

Leave blank

N/A

16

ASSIGNMENT QUALIFICATION STATUS CODE

309 – 328

Leave blank

N/A

17

SUBJECT CODE

329 – 353

Leave blank

N/A

18

PERCENT TIME ASSIGNED

354 – 357

Leave blank

N/A

19

ASSIGNMENT FIELD STATUS

358 – 360

Leave blank

N/A

20

*ASSIGNMENT GRADE LEVEL

361 – 364

NYS Reporting

For any ENYP submission type record, this value is ALL.

For PMF submission type records, if field_number = 6 is blank on reg_user_staff_bld.screen_number = 15110, then this value is ALL.

If the field has a comma-delimited list of valid Assignment Grade Level Codes, create a separate record for each grade level.

If the record is from the District Wide Staff Assignment page, this value is ALL.

Administration > Registration Setup > Building > Staff > Building Information panel > click Building link > District-Defined panel > Staff Assignment: PMF Grade List field

You choose the Submission Type on the Staff Assignment Download page.

District-wide staff are updated on Administration > Registration Setup > Building > Staff > District-Defined panel > District Wide Staff Assignment

21

CONTROLLING DISTRICT CODE

365 – 384

Leave blank

N/A

22

ASSIGNMENT SECONDARY FUND SOURCE CODE

385 – 408

Leave blank

N/A

23

ASSIGNMENT TERTIARY FUND SOURCE CODE

409 – 432

Leave blank

N/A

24

ASSIGNMENT QUARTERNARY FUND SOURCE CODE

433 – 456

Leave blank

N/A

25

ASSIGNMENT TITLE

457 – 506

Local use only

Leave blank

N/A

26

PRIMARY ASSIGNMENT INDICATOR

507 – 509

Leave blank

N/A

27

ASSIGNMENT ORDER

510 – 511

Leave blank

N/A

28

ASSIGNMENT STUDENT COUNT

512 – 516

Leave blank

N/A

29

YEARS EXPERIENCE IN ASSIGNMENT

517 – 518

Leave blank

N/A