The Educator School File requires a single record for every position an educator serves in a school. This file collects 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 only be run at the District Level.
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.
The report selects records from the [Users] 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 member must not be excluded from state reporting.
- The staff member's social security number must not be blank.
- The staff member's Status on the Edit Information page must be Current (1).
For help with navigation and running the report, see How to Find and Generate a Report.
The pop-up menu defaults to the currently selected school year. To change the school year, click Term at the top of the page and choose the appropriate school year term.
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.
The report concatenates the current year, such as 2012 for the 2011-2012 school year, the reporting cycle, followed by 1.0EdSchool.
Current School Year
The ending year of the current school year, such as 2012 for the 2011-2012 school year.
Reporting District Code
The district responsible for reporting the educator's data.
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.
The educator's social security number reported with the dashes removed.
Legal Last Name
The educator's legal last name.
Legal First Name
The educator's legal first name.
The educator's position code.
Note: For code sets go to MO Code Set Document
CTE Program Type
The program type code for the educator's CTE-approved program.
The educator's full-time equivalency is the percent of the time the educator works in the associated attendance centre.
The educator's salary, which they receive for the associated position and attendance centre, includes only regular term and extended contract salary.
The total number of months the educator is contracted for a CTE program.
Late Start Date
The date the educator was hired or replaced by another educator after the beginning of the school year.
Early End Date
The date the educator was terminated or replaced by another educator prior to the end of the school year.
Comments regarding the teacher.
|Baseline Salary Grant
|Indicates the baseline salary granted to the staff.