PowerSchool ERP New York

SIRS - Staff Assignment Report - File Layout and Data Mapping

The default file name of the SIRS Staff Assignment report is NY SIRS Staff Assignment Electronic Report_<Year>.csv. 

The file format is comma-delimited.

The following table shows the field numbers, names, descriptions, lengths, data types, and the data sources or valid values for the SIRS Staff Assignment report.

Field Number

Field Name

Description

Length

Data Type

Data Source or Valid Values

Required or Optional

1

DISTRICT CODE

The SIRS District Code


8

Alphanumeric

Retrieved from the District Code field on the NY SIRS - Staff Assignment Report - Load page.

Required

2

STAFF ID

The employee’s staff ID.

12

Alphanumeric

Retrieved from the Staff ID field on the Staff Information form of the NY SIRS - Staff Assignment Report page.

Required

3

ASSIGNMENT CODE

The employee’s assignment code.

30

Alphanumeric

Retrieved from the Assignment Code field on the Staff Information form of the NY SIRS - Staff Assignment Report page.

For more information about valid assignment codes, refer to Assignment Codes and Descriptions in the SIRS Manual on the NYSED website.

Required

4

ASSIGNMENT LOCATION CODE

The local location code for the employee’s assignment.

6

Alphanumeric

Retrieved from the Assignment Local Location Code field on the Staff Information form of the NY SIRS - Staff Assignment Report page.

Required

5

SCHOOL YEAR DATE

June 30 of the reporting school year.


10

Date

Retrieved from the Year field on the Staff Information form of the NY SIRS - Staff Assignment Report page.

The valid value is June 30 of the reporting school year in YYYY-MM-DD format.

Required

6

ASSIGNMENT DATE

The date the employee’s assignment started.

10

Date

Retrieved from the Assignment Start Date field on the Staff Information form of the NY SIRS - Staff Assignment Report page.

Required

7

COMPLETION DATE

The date the employee’s assignment was completed.

10

Date

Retrieved from the Assignment Completion Date field on the Staff Information form of the NY SIRS - Staff Assignment Report page.

Required

8

ASSIGNMENT JOB CODE

Leave blank

8

Not applicable

Blank

Not applicable

9

ASSIGNMENT FIELD

The field of the employee’s assignment.


50


Retrieved from the Assignment Field field on the Staff Information form of the NY SIRS - Staff Assignment Report page.

Required for social workers, counselors, nurses, and school psychologists.

10

ASSIGNMENT ROOM

Leave blank

30

Not applicable

Blank

Not applicable

11

ASSIGNMENT SITE

Leave blank

50

Not applicable

Blank

Not applicable

12

ASSIGNMENT PROGRAMS CODE

Local use only

20

Not applicable

Blank

Not applicable

13

OBSOLETE

Leave blank

20

Not applicable

Blank

Not applicable

14

OBSOLETE

Leave blank

20

Not applicable

Blank

Not applicable

15

ASSIGNMENT PRIMARY FUND SOURCE CODE

Leave blank

24

Not applicable

Blank

Not applicable

16

ASSIGNMENT QUALIFICATION STATUS CODE

Leave blank

20

Not applicable

Blank

Not applicable

17

SUBJECT CODE

Leave blank

25

Not applicable

Blank

Not applicable

18

PERCENT TIME ASSIGNED

The percentage of the employee’s time spent on the assignment.

8,3

Numeric

Retrieved from the Percent Time Assigned field on the Staff Information form of the NY SIRS - Staff Assignment Report page.

Required for social workers, counselors, nurses, and school psychologists.

19

ASSIGNMENT FIELD STATUS

Leave blank

3

Not applicable

Blank

Not applicable

20

ASSIGNMENT GRADE LEVEL

The grade level assigned to the employee.


3


Retrieved from the Assignment Grade Level field on the Staff Information form of the NY SIRS - Staff Assignment Report page.

Required

21

CONTROLLING DISTRICT CODE

Leave blank

20

Not applicable

Blank

Not applicable

22

ASSIGNMENT SECONDARY FUND SOURCE CODE

Leave blank

24

Not applicable

Blank

Not applicable

23

ASSIGNMENT TERTIARY FUND SOURCE CODE

Leave blank

24

Not applicable

Blank

Not applicable

24

ASSIGNMENT QUATERNARY FUND SOURCE CODE

Leave blank

24

Not applicable

Blank

Not applicable

25

ASSIGNMENT TITLE

Local use only

50

Not applicable

Not applicable

Not applicable

26

PRIMARY ASSIGNMENT INDICATOR

Leave blank

3

Not applicable

Blank

Not applicable

27

ASSIGNMENT ORDER

Leave blank

2,0

Not applicable

Blank

Not applicable

28

ASSIGNMENT STUDENT COUNT

Leave blank

5,0

Not applicable

Blank

Not applicable

29

YEARS EXPERIENCE IN ASSIGNMENT

Leave blank

2,0

Not applicable

Blank

Not applicable