Skip to main content
Skip table of contents



Report Description

This file is used to submit the staff assignment and course section data. This report produces the Staff Section Assignment extract for the current school year in a comma-delimited format. 

Selection Criteria

Selection criteria determine which database records are used in the report.

Staff Selection

  • If the lead teacher has an educator ID of 9999100, 9999150, 9999200, 9999300 or 9999350, the report outputs a record for the co-teacher associated with the section.

Report Input 

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



Select Schools

Choose one of the following:

  • Current School Only – Includes all student records associated with the current school that meet the 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.
  • All Schools – Includes all student records on the PowerSchool server that meet the selection criteria.

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

File Path

Enter the file path. If applicable, select the associated checkbox to save as the default value.
Data Collection Name

Choose the applicable Data Collection.

  • 03_NightlyCollection_Unofficial
  • 04_YearEndCollection_Official
  • 07_SpringOfficial
SFTP ConnectionsChoose a selection from the pop-up menu. The default value is Disable.

Report Output 

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

Item #

Data Element



Field Type

Field Length

 1ADMINIDThe district's SU/SD ID.


 2POSIDThe place of service ID.


 3LOCALCOURSEIDThe course number.[Sections]Course_NumberString55 
 4COURSESECTIONUnique Course section ID.[Sections]IDString30

The teacher's state-assigned staff ID.



Code set for the role with a course assignment.

Valid values

  • 10: Teacher of Record 
  • 20: Co-Teacher of Record 
  • 30: Other Contributing Professional 
  • 40: Instructor, not credit awarding
 7SYThe school year.[S_VT_District_S]SYNumber

Back to top

JavaScript errors detected

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

If this problem persists, please contact our support.