FileSpec:202210OctoberCycleEducatorCore
Item Item Name Column Name Required Definition Code Set Data Type Length Precision
005 Collection Version CollectionVersion Required Collection version should contain this value '2022Oct1.0EdCore' for the 2022 Educator Core October Cycle File Layout.
Text 50
010 Current School Year CurrentSchoolYear Required The ending year of the current school year. For example, use '2022' for the 2021-2022 school year.
Integer 4
025 Reporting District Code ReportingDistrictCode Required DESE assigned 6 digit county district code for the district reporting. DESE_District_Codes Text 6
050 ED SSN EDSSN Required Social Security Number. Format allowed '999999999'.
Text 9
060 ED Legal Last Name EDLastName Required Legal last name.
Text 60
065 ED Legal First Name EDFirstName Required Legal first name.
Text 60
070 ED Legal Middle Name EDMiddleName Optional Legal middle name.
Text 10
075 ED Legal Name Suffix EDSuffix Optional Legal name suffix.
Text 10
080 ED Date of Birth EDDateofBirth Optional Date of birth as appears on certificate of birth.
Text 10
100 ED Gender EDGender Required Gender Gender_Codes Text 1
105 ED Race/Ethnicity EDRaceEthnicity Required Pre-defined Race / Ethnic code. Race_Ethnicity_Codes Text 1
110 ED Email EDEmail Optional Educator email address.
Text 70
120 Extended Contract Duration EDExtConDur Conditional Number of extra days an educator has contracted to perform services for district beyond regular contract duration reported on District Data (Screen 02), if applicable. (Employees with 12-month contracts may show 260 days minus the regular contract duration.)
Integer 3
130 Extended Contract Salary EDExtConSal Conditional Extra salary that teacher, counselor, librarian, or any position except administrator (Position Codes 10 and 20) receives for working more than a 9-month term.
Integer 6
140 Regular Term Salary EDRegTermSal Required 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). Administrators' salaries should include all compensation (e.g., base salary, tax sheltered annuities, vehicle allowance, etc.). 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), show the full salary normally paid for that position.
Integer 6
150 Extra Duty Salary EDExtDutySal Conditional 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.
Integer 6
160 Min. Salary Supplement EDMinSalSupplmt Conditional Annualized state-paid supplemental salary received by a teacher; counselor; or librarian to bring the salary up to the state minimum salary level.
Integer 6
170 Career Ladder Stage EDCareerLadr Conditional Career ladder stages (1, 2 or 3) of participating educators. Enter 1 for Stage I; enter 2 for Stage II; enter 3 for Stage III. Educator_Career_Ladder_Stages Text 1
180 Highest Degree EDHighDegree Required Highest degree of educator. Educator_Highest_Degree Text 4
190 Public School Years - District EDYrExpDist Required Total number of years experience of educator in 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.
Integer 2
195 Public School Years - Missouri EDYrExpMO Required Total number of years experience of educator 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.
Integer 2
200 Public School Years -Public EDYrExpPublic Required Total number of years experience of educator in all public school systems including the current year.
Integer 2
210 Late Hire Date EDLateHireDate Conditional Date (month/day) educator was hired if later than start of regular school term else null.
Text 10
220 Early Termination Date EDEarlyTermDate Conditional Date (month/day) educator terminated services if earlier than end of regular school term else null.
Text 10
230 ED Comments EDComments Conditional Free-form notes used to indicate (1) job titles for Course 887900, (2) course titles for "Other" (xxxx99) courses, (3) supplemental assignment for Course 880000, (4) teachers assisted by an aide, (5) aides assisting a teacher or (6) other nonstandard information.
Text 70
240 Fiscal Agent County District EDFiscAgentCoDist Required County-district code number of the fiscal agent. (Fiscal agent is the district that provides the salary.) The code number 999-999 may be used to represent an agency other than a public school with the name of the agency entered in the “Comments” area. Fiscal_Agent_District_Codes Text 6
250 Min. Salary Days Worked EDMinSalDaysWrkd Conditional Total number of contract days worked during the regular term by an educator receiving a minimum salary supplement.
Integer 3