Educator Core Exract
The Educator Core extract contains a single record for every educator in the district and is used to report data items about each educator, including
personnel requiring a certificate;
aides/ paraprofessionals, ancillary personnel, and parent educators funded by state or federal programs or used to meet classification standards; and
administrators involved with instructional programs.
Data include Social Security Number, name, race, sex, highest degree, years of experience, extended contract duration, career ladder, regular term salary, extended contract salary, extra duty salary, minimum salary supplement, minimum salary days worked, late hire and early termination dates, and comments.
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.
Staff Selection
The report selects records from the Users-related and School Staff-related tables based on the following criteria:
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 school must not be excluded from state reporting.
The selected school must be the staff member’s home school.
The staff member’s social security number must not be blank and entered the same if the staff member is at multiple schools.
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 school staff record in the selected schools.
The primary school staff record shall be the record where the SchoolId (in the SchoolStaff table) equals the Users.HomeSchoolId (from the Users table defined in the Account Access and Affiliations).
This is because the report must report only one record per staff member, regardless of the number of school staff records.
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 | 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. |
Report Validation Errors | If Yes-Report Validation Errors is selected, a Validation Report will process and include all of the errors. If No-Produce Extract File is selected, the Educator Core Extract will process. If there were errors that did not get corrected, the field with the error will not get reported. Note: It is highly recommended that the Validation Report be run prior to Producing the extract file |
Report Output
Each field displayed in the report output 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, 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.0EdCore. For example: 2025Oct1.0EdCore | [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 |
015 | Reporting District Code | The district responsible for reporting the student’s data. | [Prefs]Value [Prefs]Name=districtnumber | R |
050 | ED SSN | The educator’s social security number, reported with the dashes removed. | [Users]SSN | R |
060 | ED Legal Last Name | The educator’s legal last name. | [Users]Last_Name | R |
065 | ED Legal First Name | The educator’s legal first name. | [Users]First_Name | R |
070 | ED Legal Middle Name | The educator’s legal middle name. | [Users]Middle_Name | O |
075 | ED Legal Name Suffix | This element is not collected. | N/A | O |
080 | ED Date of Birth | The educator’s date of birth, reported in the format MM/DD/YYYY. | [UsersCoreFields]DOB | O |
100 | ED Gender | The educator’s gender. | [UsersCoreFields]Gender | R |
105 | ED Race/Ethnicity | The educator’s race/ethnicity. Note: For code sets go to MO Core Data/MOSIS | [Users]FedEthnicity [TeachersRace]RacecdRaceCD | R |
110 | ED Email | The educator’s email address. | [Users]Email_Addr | O |
120 | Extended Contract Duration | The number of extra days an educator has contracted to perform services for district beyond their regular contract duration, if applicable. Note: Employees with 12-month contracts may show 260 days minus the regular contract duration. | [S_MO_USR_X]ExtContractDur | C |
130 | Extended Contract Salary | The educator’s salary for the extended contract except for administrators (Position Codes 10 and 20), if applicable. | [S_MO_USR_X]ExtContractSalary | C |
140 | Regular Term Salary | The educator's regular term salary (excluding minimum salary supplement), based upon the FTE of an approximate 9-month teaching contract except for administrators (Position Codes 10 and 20). The salary should correspond with the FTE. If an educator is employed full-time for a portion of the year, such as 7 months, report the salary on the 9-month basis. Board-paid insurance and other fringe benefits are not included. If a position is filled temporarily by a substitute (Position Code 60), report the full salary normally paid for that position. Paid insurance and other fringe benefits are not included. | [S_MO_USR_X]RegularTermSalary | R |
150 | Extra Duty Salary | The educator's salary for all activities that generate additional pay beyond the regular term salary, except for extended contract salary and the career ladder and minimum salary supplements. Include salary for time outside the regular school day. If a teacher receives additional pay above the salary schedule through an Incentive Grant project, the extra pay is reported as Extra Duty Salary. If a teacher's entire salary is paid from an Incentive Grant, this pay is reported as Regular Term Salary, except for after-school assignments that are reported as Extra Duty Salary. | [S_MO_USR_X]ExtraDutySalary | C |
160 | Min. Salary Supplement | The annualized state-paid supplemental salary received by a teacher, counselor, or librarian to bring the salary up to the state minimum salary level. | [S_MO_USR_X]MinSalarySupplement | C |
170 | Career Ladder Stage | The educator’s career ladder stage of 1, 2 or 3 for participating educators. | [S_MO_USR_X]Careerladder | C |
180 | Highest Degree | The educator’s highest degree code. Note: For code sets go to MO Core Data/MOSIS | [S_MO_USR_X]HighestDegree | R |
190 | Public School Years - District | The educator's total number of years of experience in the current district, including the current year. To be counted as one year, the contract must be for at least one half of the week and at least one half of the school year. | [S_MO_USR_X]PubSchYearExpDist | R |
195 | Public School Years - Missouri | The educator's total number of years of experience in Missouri public school systems, including the current year. To be counted as one year, the contract must be for at least one half of the week and at least one half of the school year. | [S_MO_USR_X]PubSchYearExpMO | R |
200 | Public School Years - Public | The educator's total years of experience in all public school systems, including the current year. | [S_MO_USR_X]PubSchYearExpTot | R |
210 | Late Hire Date | The date (month/day) that the educator was hired, if later than the start of the regular school term. This field is based on the staff’s homeschool. | [S_MO_SSF_C]LateHireDate | C |
220 | Early Termination Date | The date (month/day) that the educator terminated their services, if earlier than the end of the regular school term, reported in the format MM/DD/YYYY. This field is based on the staff’s homeschool. | [S_MO_SSF_C]EarlyTermDate | C |
230 | ED Comments | Comments to indicate:
| [S_MO_USR_X]Comments | C |
240 | Fiscal Agent County District | The county-district code number of the fiscal agent (the district that provides the salary). Note: Use the value 999-999 to represent an agency other than a public school. Enter this value with the name of the agency in the Comments area. | [S_MO_USR_X]CountyDistCode | R |
250 | Min. Salary Days Worked | The total number of contract days worked during the regular term by an educator receiving a minimum salary supplement. | [S_MO_USR_X]MinSalaryDaysWorked | C |
260 | Baseline Salary Grant | Indicates the baseline salary granted to the staff. | [S_MO_USR_X]BaseSalaryGrant |
Report Validations
The Reporting District Code is more than 6 characters
SSN is more than 9 characters
Last Name is more than 60 characters
First Name is more than 60 characters
Middle Name is more than 10 characters
Gender is more than 1 character
Race is missing
The Email Address is more than 70 characters
Extended Contract Duration is more than 3 characters
Extended Contract Salary is more than 6 characters
Regular Term Salary is more than 6 characters
Extra Duty Salary is more than 6 characters
Min. Salary Supplement is more than 6 characters
Career Ladder Stage is more than 1 character
Highest Degree is more than 4 characters
Public School Years - District is more than 2 characters
Public School Years - Missouri is more than 2 characters
Public School Years - Public is more than 2 characters
Comment is more than 6 characters
Fiscal Agent County District is more than 6 characters
Min. Salary Days Worked is more than 3 characters
Baseline Salary Grant is more than 6 characters