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:
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. |
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 | Public school districts: NYnnnnnn | 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 |