Staff Assignments ENYP (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.

Left Pad State Staff ID with Leading Zeros (force 9 characters)

When this option is enabled, the State StaffID will be extracted with leading zeros to force 9 characters. 

EX:  State Staff ID as stored in PowerSchool: 1234567

• With this option enabled (checked), the State Staff ID will extract as: 001234567
• With this option disabled (not checked), the State Staff ID will extract exactly as stored (1234567)

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

 (ACCESS ROLE)

For ENYP access, choose assignment codes from the ENYP code subset

[StaffAssignmentforENYP]user_defined_text2

Yes

4

*ASSIGNMENT LOCATION CODE

(ACCESS/LOCATION CODE)

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

Send one record for each access role/location code combination. 

[StaffAssignmentforENYP]user_defined_text

Yes

6

5

*SCHOOL YEAR DATE

Use June 30 of the reporting school year. Ex: 2014–15 = 2015-06-30

N/A

Yes

10

6

*ASSIGNMENT DATE

(ACCESS START DATE)

Use first day of school year, or first date of the school year that the staff member was granted access for the defined location/assignment code combination, whichever comes last.

[StaffAssignmentforENYP]user_defined_date

Yes

10

7

*COMPLETION DATE

(ACCESS END DATE)

Do not report unless access for the defined access role/location code combination has ended.

[StaffAssignmentforENYP]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

ENYP: Use ALL

Hard coded to extract as ‘ALL’

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

No

N/A

27

ASSIGNMENT ORDER

Not reported

N/A

No

N/A

28

ASSIGNMENT STUDENT COUNT

Not reported

N/A

No

N/A

28

YEARS EXPERIENCE IN ASSIGNMENT

Not reported

N/A

No

N/A