Skip to main content
Skip table of contents



Report Description

This file is used to submit staff data by employing organization. This report produces the employee org extract for current teachers in a comma-delimited format.

Selection Criteria

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

Staff Selection

The report selects records from the [Users] table based on the following criteria:

  • The staff member must have an active educator ID number. The report does not include records that are linked to an inactive educator ID number.

Note: The report selects the same staff members as the 00_Staff_Identity report.

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 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 selection criteria.

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

Select Students

Choose one of the following:

  • The Selected [x] Students Only – Run the report for students in the current selection.
  • All Students – Run the report for all students in the current school or district.

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 from the pop-up menu.

  • 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 are 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.


 2EMPORGIDThe state-assigned ID for the district employing the staff.[S_VT_USR_X]EmpOrgID String6
 3EDUCATORIDThe staff member's state-assigned staff ID.[S_VT_USR_X]EducatorIDNumber10 

The staff member's employment beginning date.

Note: MM/DD/YYYY format.


The staff member's employment end date.

Note: MM/DD/YYYY format.

 6EMPSTATNOThe staff member's employment status number (code set).[S_VT_USR_X]EmpStatNoNumber3
 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.