FileSpec:201806JuneCTSO
Item Item Name Column Name Required Definition Code Set Data Type Length Precision
005 Collection Version CollectionVersion Required Collection version should contain this value '2018Jun1.0CTSO' for the 2018 June Cycle Career and Technical Student Organization File Layout.
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
035 Sending District Code SendDistCode Conditional Required if Reporting School Code begins with 11. student was sent to another institution. 6-digit number and name of sending district else null.
Text 6
040 Sending School Code SendSchoolCode Conditional Required if student was sent to another institution. 4-digit number and name of sending high school else null.
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 DECA DECA Required Distributive Education Clubs of America Participation_Level_Codes Text 1
115 FBLA FBLA Required Future Business Leaders of America Participation_Level_Codes Text 1
120 FCCLA FCCLA Required Family, Career and Community Leaders of America Participation_Level_Codes Text 1
125 HOSA HOSA Required Health Occupations Students of America - Future Health Professionals Participation_Level_Codes Text 1
130 SkillsUSA SkillsUSA Required Technical, Skilled and Service Occupations and Health Sciences Participation_Level_Codes Text 1
135 TSA TSA Required Technology Student Association Participation_Level_Codes Text 1
140 FFA FFA Required Future Farmers of America Participation_Level_Codes Text 1
145 Educators Rising EdRising Required Educators Rising Participation_Level_Codes Text 1
150 Pathways Pathways Required Pathways to Prosperity Participation_Level_Codes Text 1