Staff Assignments (SFTP)

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.
• District Wide – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The District Wide option is only available when running the report from the District Office.

Display Headers

Choose Yes or No from the pop-up menu to indicate whether to display the header (data element name) for each column in the report output, as well as to display additional fields used to audit the data in the report.

SFTP connections

Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically.

Please refer to the System Administrator portion of the PowerSchool Administrator User Guide for details on how to create an SFTP connection for use with this new report parameter.

Note: Remote connection requires PowerSchool 7.1.4 or higher.

1

*DISTRICT CODE
(DISTRICT OF RESPONSIBILITY CODE)

Public school districts: NYnnnnnn       
(NY followed by the first 6 digits of the BEDS code)

Charter and nonpublic schools, State agencies, State-operated schools, AND child care institutions with schools: 8nnnnnnn
(8 followed by the last 7 digits of their Institution code)

If Pref NY_CHARTER_NP = 0 then ‘NY’ concatenated with Pref NY_BEDS_CODE

If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X]DistrictLocationCode is blank then ‘8’  concatenated with Pref NY_BEDS_CODE

If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X]DistrictLocationCode is not blank then ‘8’  concatenated with [S_NY_SCH_X]DistrictLocationCode

Yes

8

2

*STAFF ID

Staff ID must be unique within the LEA. For NYC, the local staff ID must be unique within NYC.  The staff ID for each staff member must be consistent across all templates. 

[S_NY_USR_X]StateStaffID

Yes

12

3

*ASSIGNMENT CODE

Hard coded in output as ‘PRN’

N/A

Yes

4

*ASSIGNMENT LOCATION CODE

For school districts and charter schools, use building code used by the Data Warehouse, uniquely identifying the building to which a principal is assigned, typically assigned by the local student management system.

[StaffAssignmentforPrincipal]user_defined_text2

[S_NY_SCH_X]BOCESBuilding

Yes

6

5

*SCHOOL YEAR DATE

Use June 30 of the reporting school year. Ex: 2018–19 =  2019-06-30

N/A

Yes

10

6

*ASSIGNMENT DATE

Use first day of school year, or first date of the school year that the staff member was assigned to the "location" as the principal, whichever comes last.

[StaffAssignmentforPrincipal]user_defined_date

Yes

10

7

*COMPLETION DATE

Last date of assignment in the building or grade level.

[StaffAssignmentforPrincipal]user_defined_date2

Yes?

10

8

ASSIGNMENT JOB CODE

Not reported

N/A

No

N/A

9

ASSIGNMENT FIELD

Not reported

N/A

No

N/A

10

ASSIGNMENT ROOM

Not reported

N/A

No

N/A

11

ASSIGNMENT SITE

Not reported

N/A

No

N/A

12

ASSIGNMENT PROGRAMS CODE

Not reported

N/A

No

N/A

13

OBSOLETE

Not reported

N/A

No

N/A

14

OBSOLETE

Not reported

N/A

No

N/A

15

ASSIGNMENT PRIMARY FUND SOURCE CODE

Not reported

N/A

No

N/A

16

ASSIGNMENT QUALIFICATION STATUS CODE

Not reported

N/A

No

N/A

17

SUBJECT CODE

Not reported

N/A

No

N/A

18

PERCENT TIME ASSIGNED

Not reported

N/A

No

N/A

19

ASSIGNMENT FIELD STATUS

Not reported

N/A

No

N/A

20

*ASSIGNMENT GRADE LEVEL

Principals for the entire building should use "ALL" for the Assignment Grade Level.  Otherwise send one record for each grade level.

[StaffAssignmentforPrincipal]user_defined_integer

[StaffAssignmentforPrincipal]user_defined_text2

Yes

4

21

CONTROLLING DISTRICT CODE

Leave blank.

N/A

No

N/A

22

ASSIGNMENT SECONDARY FUND SOURCE CODE

Not reported

N/A

No

N/A

23

ASSIGNMENT TERTIARY FUND SOURCE CODE

Not reported

N/A

No

N/A

24

ASSIGNMENT QUATERNARY FUND SOURCE CODE

Not reported

N/A

No

N/A

25

ASSIGNMENT TITLE

Not reported

N/A

No

N/A

26

PRIMARY ASSIGNMENT INDICATOR

Not reported

N/A

N/A