Educator Core Report

Contents

Report Description

The October Educator Core File requires a single record for every educator in the district and is used to report data items about each educator including: (1) personnel requiring a certificate; (2) aides/ paraprofessionals, ancillary personnel, and parent educators funded by state or federal programs or used to meet classification standards; and (3) 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. The report will default to the District level.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Staff Selection

The report selects records from the [Teachers]tables based on the following criteria:

The staff member must not be excluded from state reporting.
The staff member’s school must not be excluded from state reporting.
The staff member’s social security number must not be blank and must be entered exactly the same if the staff member is at multiple schools.
The staff member’s Status on the Edit Information page must be Current (1).

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Records to Include	Indicate which records to include in the report by selecting one of the following options: The selected [number]records only – Run the report for staff in the current selection. All records – Run the report for all staff in the current school or district that meet the selection criteria. Note: If running the report for a single staff member, or group of staff members, select the staff members prior to running report.
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 of the fields displayed in the output of the report are 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 2012 for the 2011-2012 school year, the reporting cycle, followed by 1.0EdCore. For example: 2012Oct1.0EdCore	[Terms]LastDay	R
010	Current School Year	The ending year of the current school year, such as 2012 for the 2011-2012 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.	[S_MO_SSF_X]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.	[S_MO_SSF_X]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