Skip to main content
Skip table of contents

Staff Assignments (SFTP)

Introduction

This report generates records for staff serving in the role of Principal (PRN)

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

This report will extract records for every staff member meeting the following criteria:

  • The staff member is assigned to a school that is not excluded from state reporting
  • The NY State staff ID has been populated in the staff record marked as their Primary Record
  • A Principal Staff Assignment record exists with dates that fall within the currently selected year (Start Page > Staff > Select A Staff Member > Edit Information > New/Edit NY Principal Staff Assignment)

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

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.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Note: StaffAssignmentforPrincipal is a virtual table. See Virtual Tables for more information.

Item #

Data Element

Description

[Table]FieldName

Req

Max length

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

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.