Course Instructor Assignment (SFTP)
Introduction
This report provides data about teachers and their course assignments, including the term, teacher assignment start and end dates, and whether they are a Primary and/or Special Ed Instructor.
You can choose to extract a header record and left pad State Staff IDs as in other reports. In addition, for this report, the Lead Teacher role is a default parameter and you can select additional or other Teacher Roles to include in the extract (e.g. Co-Teacher, Teacher's Aid, Class Observer, etc.).
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.
Section Selection
- The course is not excluded from state reporting.
- The section is not excluded from state reporting.
- The section is at a school that is not excluded from state reporting.
- The section's term has NY data set up to define the Term Code mapping (School Setup > Final Grade/Reporting Term Setup).
- For all staff members assigned to the section, the NY State staff ID has been populated in the staff record that is tied to the school where the section is being taught.
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 All Schools option is only available when running the report from the District Office. |
Display Header | 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 zeros | Select this option to use leading zeros to force the State Staff ID to be 9 characters. For example, if a State Staff ID is 1234567:
|
| Exclude records with an Instructional Responsibility Weight equal to 0.00 | Select this option to exclude teachers who have an Instructional Responsibility Weight of 0.00. |
Roles | Select the course instructors to be reported, based on the section's roles. The default is Lead Teacher. Use Ctrl+click to choose multiple roles. |
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 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.
Item # | Data Element | Description | [Table]FieldName | Max Length |
1 | Course District Code | For public school districts, this code is: NYnnnnnn (NY followed by the first 6 digits of the BEDS code) For charter and nonpublic schools, State agencies, State-operated schools, AND child care institutions with schools, this code is 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 ‘NY’ concatenated with Pref NY_BEDS_COD If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X] DistrictLocationCode is blank then ‘8’ concatenated with Pref NY_BEDS_COD If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X]DistrictLocationCode is not blank then ‘8’ concatenated with [S_NY_SCH_X]DistrictLocationCode | 8 |
2 | Course Location Code | This is the local building code, used by the Data Warehouse, uniquely identifying the location associated with the course sections for which the staff person is responsible, typically assigned by the local student management system. For school districts and charter schools, this is the building code that uniquely identifies the building to which the staff person is assigned. For BOCES, this is a virtual location code. | [Sections]WhereTaught [S_NY_SCH_X]BOCESBuilding | 6 |
3 | School Year Date | June 30th of the current school year. | [Terms]LastDay | 10 |
4 | Course Code (Long) | The course code that uniquely identifies the course. | [Courses]Course_Number | 12 |
5 | Supplementary Course Differentiator | The code used to indicate that the course code is offered in more than one session during the school year. | Always reported as N/A | 3 |
6 | Section Code (Long) | The section code. | [Sections]Section_Number | 25 |
7 | Term Code | The term in which the course/section is offered. | [S_NY_TRB_X]Term_Code | 20 |
8 | Marking Period Code | The marking period. | [S_NY_TRB_X]Marking_Period_Number | 40 |
9 | Instructor District Code | The District Code of the entity which has primary control of the Primary Instructor’s course/section assignments. This is the same as the District Code. NYC will use the Chancellor's Office 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 | 8 |
10 | Instructor ID | This is the New York State staff ID. If the report parameter option “Left pad State Staff ID with zeros” was enabled, 9 numeric characters are displayed. | [S_NY_USR_X]StateStaffID | 12 |
11 | Instructor Start Date | The first day of the school year the staff member was assigned to this "location” in this course/section assignment. Blank if date is in the future. | [TeacherSectionsAssignment]StartDate | 10 |
12 | Instructor End Date | The last date in this course/section assignment for the staff member. Blank if date is in the future | [TeacherSectionsAssignment]EndDate | 10 |
13 | Primary Instructor Indicator | Indicates the primary instructor for this course/section assignment. Report displays “Y” only for any teacher set as Lead Teacher, Co-teacher, and/or as an additional teacher assigned 100% allocation. | [S_NY_STC_TeacherWeight_C]SectionTeacherID [S_NY_STC_X]PrimaryInstructor_TF | 3 |
14 | Primary Special Ed Instructor Indicator | The special education instructor for the course/section. Valid values:
| [S_NY_STC_X]Special_Education_Instructor [S_NY_USR_X]Special_Education_Instructor | 3 |
15 | Instructor Type Code | Not reported | N/A | N/A |
| 16 | Primary Instructor Delivery Method Code | Indicates the delivery method of the instruction. Valid values:
| [S_NY_SEC_X]PrimaryInstructDeliveryMethod [S_NY_CRS_X]PrimaryInstructDeliveryMethod | 8 |
| 17 | Primary ENL Instructor Indicator | Indicates if the instructor has an ESL/ENL certification. This field displays for instructors designated as Lead Teacher, Co-Teacher, and/or additional teacher. Valid values:
| [S_NY_STC_X]ENLIndicator [S_NY_USR_X]ENLInstructor | 1 |
| 18 | Primary Course Instruction Language Indicator | Indicates the primary language of instruction for this course. See Home Language Codes for valid values. | [S_NY_SEC_X]PrimaryInstructLangCode [S_NY_CRS_X]PrimaryInstructLangCode | 20 |
| 19 | Alternative Instruction Language Code | For state purposes. Leave blank. | N/A | 20 |
| 20 | Incidental Teaching Assignment Indicator | Identifies a course that a teacher can teach outside of their certification area.
| [S_NY_SEC_X]IncTeaAssignInd | 1 |