Skip to main content
Skip table of contents

Educator School Extract

Report Description

The Educator School extract contains a record for every position an educator serves in a school. This extracts one or more records for each building in the district where the educator has a position code or approved career education position.

This report can be run at the District or School level.

Selection Criteria

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

Staff Selection

The report selects records from the Users-related and School Staff-related tables based on the following criteria:

  • The staff member must be associated with the schools included in the report.

  • The staff member's school must not be excluded from state reporting.

  • The staff must not be excluded from state reporting on the Compliance Data Collection page (S_USR_X.State_ExcludeFromReporting != 1).

  • The staff member's social security number must not be blank.

  • The staff member must be active. The active checkbox must be checked on the school staff record (SchoolStaff.Status = 1).

  • The staff member must have a position code updated on the Compliance Data Collection page.

Report Input

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

Field

Description

Schools to Include

Choose the schools to include for the report.

Current Selection Staff

Select staff to run the report or select All Staff to include all the staff in the selected schools.

Reporting Year

By default, the currently school year is selected. To change the school year, click Term at the top of the page and choose the appropriate school year term.

Validations Only

Select Yes or No indicate whether to run the validation report only.

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.  

Note: In the Required column, a value of "C" indicates that the element is conditional – if the element applies to the particular record, then it is required.

Item

Data Element

Description

[Table]FieldName

OCT

005

Collection Version

The report concatenates the current year, such as 2025 for the 2024-2025 school year, the reporting cycle, followed by 1.0EdSchool.
For example:
2025Oct1.0EdSchool

[Terms]LastDay

R

010

Current School Year

The ending year of the current school year, such as 2025 for the 2024-2025 school year.

[Terms]LastDay

R

025

Reporting District Code

The district responsible for reporting the educator's data.

[Prefs]Value

[Prefs]Name=districtnumber

R

030

Reporting School Code

The educator's school number. If the alternate school number is less than 4 digits, then the alternate school number is reported. If the alternate school number is not populated for the school, then if the school number is less than 4 digits, the school number is reported.

[Schools]Alternate_School_Number

[Schools]School_Number

R

050

ED SSN

The educator's social security number reported with the dashes removed.

[Teachers]SSN

R

060

Legal Last Name

The educator's legal last name.

[Teachers]Last_Name

O

065

Legal First Name

The educator's legal first name.

[Teachers]First_Name

O

070

Position Code

The educator's position code.

[S_MO_SSF_C]PositionCode

R

080

CTE Program Type

The program type code for the educator's CTE-approved program.

[S_MO_SSF_C]ProgType

C

090

FTE

The educator's full-time equivalency is the percent of the time the educator works in the associated attendance center.

[S_MO_SSF_C]FTE

R

100

Salary

The educator's salary, which they receive for the associated position and attendance center, includes only regular term and extended contract salary.

[S_MO_SSF_C]Salary

R

110

CTE Month

The total number of months the educator is contracted for a CTE program.

[S_MO_SSF_C]CTEMonth

C

120

Late Start Date

The date the educator was hired or replaced by another educator after the beginning of the school year.

[S_MO_SSF_C]LateHireDate

C

130

Early End Date

The date the educator was terminated or replaced by another educator prior to the end of the school year.

[S_MO_SSF_C]EarlyTermDate

C

140

Course Comment

Comments regarding the teacher.

[S_MO_SSF_C]CourseComments

C

150

Baseline Salary Grant

Indicates the baseline salary granted to the staff.

[S_MO_SSF_C]BaseSalaryGrant

Report Validations

  • The Reporting District Code is not 6 characters.

  • The Reporting School Code is more than 4 characters.

  • SSN is more than 9 characters.

  • Last Name is more than 60 characters.

  • First Name is more than 60 characters.

  • Position Code is more than 2 characters.

  • FTE is more than 4 characters.

  • The Salary is more than 6 characters.

  • CTE Month is more than 2 characters.

JavaScript errors detected

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

If this problem persists, please contact our support.