FileSpec:201700LEP-ELLAssessmentPre-Code

Item

Item Name

Column Name

Required

Definition

Code Set

Data Type

Length

Precision

005

Collection Version

CollectionVersion

Required

Collection version should contain this value '2017LEPELL1.0AsmPre' for the 2017 Precode

Text

50

010

Current School Year

CurrentSchoolYear

Required

The ending year of the current school year. For example, use '2007' for the 2006-2007 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

030

Reporting School Code

ReportingSchoolCode

Required

DESE assigned 4 digit school code where the student is being reported from.

DESE_School_Codes

Text

4

050

MOSIS Student ID

StateID

Required

State assigned student identifier. See http://dese.mo.gov/MOSIS for more information.

Text

10

055

Local Student ID

LocalStudentID

Optional

Local student id maintained by the district. Allows for data to be associated to local systems from DESE source systems.

Text

20

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

Required

Date of birth.

Text

10

095

Student Grade Level

StudentGradeLevel

Required

Grade level as of the time data is being submitted unless otherwise specified.

Student_Grade_Level_Codes

Text

2

100

Gender

Gender

Required

Gender

Gender_Codes

Text

1

105

Race/Ethnicity

RaceEthnicity

Required

Pre-defined Race / Ethnic code.

Race_Ethnicity_Codes

Text

1

110

Assessment

Assessment

Required

Choose the assessment the student will be taking.

ASMNT_Type_Codes

Text

6

115

Testing Method

TstMethod

Conditional

Required for all Students taking an EOC assessment. Testing Method is the method used to administer the assessment.

ASMNT_Test_Method_Codes

Text

6

130

Educator First Name

EDFirstName

Required

Educator First Name is the first name of the educator who will be administering the assessment.

Text

60

135

Educator Last Name

EDLastName

Required

Educator Last Name is the last name of the educator who will be administering the assessment.

Text

60

140

Subject

Subject

Conditional

Required for all Students taking an EOC assessment. Subject is the subject in which the student will be assessed in.

ASMNT_Subject_Codes

Text

6

145

Period

Period

Conditional

Required for all Students taking an EOC assessment. Period is the period in which the instruction took place.

Period_Codes

Text

2

150

Sort

Sort

Conditional

Required for all Students taking the MAP assessment. The final value in which the labels will be sorted.

Text

40

155

Examiner Email

ExaminerEmail

Required

This email address will receive a username and password for assessment administration.

Text

60