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: Job titles for Course 887900 Course titles for "Other" (xxxx99) courses Supplemental assignments for Course 880000 Teachers assisted by an aide/paraprofessional Aide/paraprofessional assisting a teacher Other non-standard information	[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