FileSpec:00DirectCertification
Item Item Name Column Name Required Definition Code Set Data Type Length Precision
005 Collection Version CollectionVersion Required Collection version should contain this value 'ALL1.0DirectCert' for the 0000 00 Direct Certification Lookup File Layout.
Text 50
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
085 Social Security Number SSN Optional Social Security Number. Formats allowed (999999999) or (999-99-9999)
Text 11
095 Student Grade Level StudentGradeLevel Optional Grade level as of the time data is being submitted unless otherwise specified. Student_Grade_Level_Codes Text 2
100 Gender Gender Optional Gender Gender_Codes Text 1
105 Race/Ethnicity RaceEthnicity Optional Pre-defined Race / Ethnic code. Race_Ethnicity_Codes Text 1