FileSpec:202300EDPrep
Item Item Name Column Name Required Definition Code Set Data Type Length Precision
005 Collection Version CollectionVersion Required Collection version should contain this value '2023ALL1.0EDPrep' for the 2023 ED Prep File Layout.
Text 50
010 Current School Year CurrentSchoolYear Required The ending year of the current school year. For example, use '2023' for the 2022-2023 school year.
Integer 4
015 Completer Enrolled CompleterEnrolled Required Use codes to indicate individual's status: "C"=Completed; "M"= Mid-Stage Enrolled (after formal program admission); or "E"= Early-stage Enrolled. Include all individuals that were enrolled students in the fall of 2023 or who completed in the 2022-23 academic year. AT should only use E or M> Ed_Prep_Completer_Enrolled_Codes Text 1
025 Reporting Ed Prep Program ReportingEdPrepProgram Required DESE assigned 6 digit code for the reporting ed prep program. DESE_District_Codes Text 6
060 Legal Last Name LastName Required Legal last name.
Text 60
065 Legal First Name FirstName Required Legal first name.
Text 60
070 Legal Middle Name MiddleName Optional Legal middle name.
Text 60
075 Legal Name Suffix Suffix Optional Legal name suffix. E.g. Jr, Sr
Text 10
080 Date of Birth DateOfBirth Conditional Date of Birth. Required when a "C" is reported in Item number 15 or when an "M" is reported and AT is reported for item 140.
Text 10
085 Social Security Number SSN Conditional Social Security Number. Formats allowed (999999999) but cannot use (999999999). Required when a "C" is reported in Item number 15 or when an "M" is reported and AT is reported for item 140.
Text 9
100 Gender Gender Required Gender Ed_Prep_Gender_Codes Text 1
105 Race/Ethnicity RaceEthnicity Required Pre-defined Race / Ethnic code. PAP_Race_Ethnicity Text 1
110 Cert. Subject Area SubjectArea Conditional Certification Subject Area (see code set for list of codes) required when a "C" is reported in Item number 15. Ed_Prep_Certification_Subject_Area_Codes Text 8
125 Content GPA ContentGPA Conditional The aggregate GPA of all content courses approved by DESE to meet certification requirements for programs in which content and pedagogy are reported separately. See attached list of programs which must report Content GPA. GPA should be reported on a 4.00 scale (2 decimal points).
Number 4 2
130 Pedagogical GPA PedagogicalGPA Conditional The aggregate GPA of all pedagogy courses approved by DESE to meet certification requirements for programs in which content and pedagogy are reported separately. See attached list of programs which must report Pedagogical GPA. GPA should be reported on a 4.00 scale (2 decimal points).
Number 4 2
135 Program GPA ProgramGPA Conditional The aggregate GPA of all courses approved by DESE to meet certification requirements for programs in which content and pedagogy are not reported separately. See attached list of programs which must report Program GPA. GPA should be reported on a 4.00 scale (2 decimal points).
Number 4 2
140 Ed Prep Program Type EdPrepProgramType Required The “path” taken towards certification as defined in 5 CSR 20-400.320. Traditional (T) refers to conventional programs intended to prepare educators who are not already employed in the area of intended certification. Non-Traditional (NT) refers to alternative programs that are intended to prepare educators who are already employed in the area of intended certification. See Comprehensive Guide for additional details and examples. Required when a "C" is reported in Item number 15. Ed_Prep_Program_Type_Codes Text 2
145 Completion Year CompYear Required Year of program completion. (Ex. 2023 Ed Prep = AY 2022-2023).
Text 4
150 Comments Comments Optional Additional comments.
Text 500
155 Cooperating Teacher Standard 1 CTStandard1 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
160 Cooperating Teacher Standard 2 CTStandard2 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
165 Cooperating Teacher Standard 3 CTStandard3 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
170 Cooperating Teacher Standard 4 CTStandard4 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
175 Cooperating Teacher Standard 5 CTStandard5 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
180 Cooperating Teacher Standard 6 CTStandard6 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
185 Cooperating Teacher Standard 7 CTStandard7 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
190 Cooperating Teacher Standard 8 CTStandard8 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
195 Cooperating Teacher Standard 9 CTStandard9 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
200 University Supervisor Standard 1 USStandard1 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
205 University Supervisor Standard 2 USStandard2 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
210 University Supervisor Standard 3 USStandard3 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
215 University Supervisor Standard 4 USStandard4 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
220 University Supervisor Standard 5 USStandard5 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
225 University Supervisor Standard 6 USStandard6 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
230 University Supervisor Standard 7 USStandard7 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
235 University Supervisor Standard 8 USStandard8 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
240 University Supervisor Standard 9 USStandard9 Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 3
245 MPEA Performance Score MPEAPerformanceScore Required A score representing the degree to which the student has demonstrated the professional skills and knowledge required by this standard. Report a value between 0.0 and 4.0 (up to 1 decimal) . A value is required when a "C" is reported in Item number 15.
Text 4