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. | [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.