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.