CTSO File Layout
| Field # | Field Name | Data Type | Field Length | eSchoolPLUS table.column | Validation Table | Where in eSchoolPLUS? |
|---|---|---|---|---|---|---|
| 005 | Collection Version | Text | 50 | Collection version should contain this value '2018Jun1.0CTSO' for the 2018 June Cycle Career and Technical Student Organization File Layout. The MOSIS Download uses the School Year and Collection Cycle prompts to create this value. | Regulatory > MOSIS > MOSIS > MO MOSIS Download: School Year and Collection Cycle | |
| 010 | Current School Year | Integer | 4 | 4-digit year as entered through the MOSIS Download page, School Year prompt. | Regulatory > MOSIS > MOSIS > MO MOSIS Download: School Year The MOSIS Download uses the School Year prompt to determine which rows get reported from the MOSIS CTSO student district-defined page. For details, refer to the MOSIS CTSO section in the Missouri eSchoolPLUS user guide. | |
| 025 | Reporting District Code | Text | 6 | 1. First, see if the student has a reg_user.field_value for the list_sequence being reported where screen_number = 529 and field_number = 3. If yes, use the first six digits of this value. If not, see if the student has reg_programs.program_value for program_id and field_number mapping to reg_program_column.state_code_equiv = MORPTBLG. If yes, use the first six digits of this value. If not, use reg_entry_with.district. 2. Convert to reg_district..state_code_equiv | Administration > General Setup > District > District > click District link where Validation Only = N > Preferences panel > Other section: State Equivalency Code Administration > General Setup > District > District > click District link where Validation Only = Y > Validation District oanel: State Equivalency Code Registration > Entry & Reports > Student District Defined > MOSIS CTSO: Reporting School Registration > Entry & Reports > Student District Defined > MOSIS Demographics: Reporting District/School | |
| 030 | Reporting School Code | Text | 4 | 1. First, see if the student has a reg_user.field_value for the list_sequence being reported where screen_number = 529 and field_number = 3. If yes, use the last four digits of this value. If not, see if the student has reg_programs.program_value for program_id and field_number mapping to reg_program_column.state_code_equiv = MORPTBLG. If yes, use the last four digits of this value. If not, use reg_entry_with.building. 2. Convert to reg_building.state_code_equiv | Administration > Registration Setup > Building > Building Definition > Preferences panel: State Equivalency Code Registration > Entry & Reports > Student District Defined > MOSIS Demographics: Reporting District/School Registration > Entry & Reports > Student District Defined > MOSIS CTSO: Reporting School Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building | |
| 035 | Sending District Code | Text | 6 | reg.alt_district | Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: Alternate District | |
| 040 | Sending School Code | Text | 4 | reg.alt_building | Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: Alternate Building | |
| 050 | MOSIS Student ID | Text | 10 | reg_personal.state_report_id | Registration > Entry & Reports > Student Demographic > Personal > General panel: MOSIS State ID | |
| 055 | Local Student ID | Text | 20 | reg.student_id | Registration > Entry & Reports > Student Demographic > Registration > ID field | |
| 060 | Legal Last Name | Text | 60 | reg.last_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name | |
| 065 | Legal First Name | Text | 60 | reg.first_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: First Name | |
| 070 | Legal Middle Name | Text | 60 | reg.middle_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Middle Name | |
| 075 | Legal Name Suffix | Text | 10 | reg.generation | regtb_generation | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Generation |
| 080 | Date of Birth | Text | 10 | reg.birthdate | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Birthdate | |
| 095 | Student Grade Level | Text | 2 | reg_entry_with.grade | reg_grade | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Grade |
| 100 | Gender | Text | 1 | reg.gender | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Gender | |
| 105 | Race/Ethnicity | Text | 1 | reg_personal.fed_race_ethnic | Registration > Entry & Reports > Student Demographic > Personal > Federal panel: Federal Code | |
| 110 | DECA | Text | 1 | reg_user.field_value where screen_number = 529 and field_number = 4 for the reported list_sequence | motb_ctso_part | Registration > Entry & Reports > Student District Defined > MOSIS CTSO: DECA |
| 115 | FBLA | Text | 1 | reg_user.field_value where screen_number = 529 and field_number = 5 for the reported list_sequence | motb_ctso_part | Registration > Entry & Reports > Student District Defined > MOSIS CTSO: FBLA |
| 120 | FCCLA | Text | 1 | reg_user.field_value where screen_number = 529 and field_number = 6 for the reported list_sequence | motb_ctso_part | Registration > Entry & Reports > Student District Defined > MOSIS CTSO: FCCLA |
| 125 | HOSA | Text | 1 | reg_user.field_value where screen_number = 529 and field_number = 7 for the reported list_sequence | motb_ctso_part | Registration > Entry & Reports > Student District Defined > MOSIS CTSO: HOSA |
| 130 | SkillsUSA | Text | 1 | reg_user.field_value where screen_number = 529 and field_number = 8 for the reported list_sequence | motb_ctso_part | Registration > Entry & Reports > Student District Defined > MOSIS CTSO: SkillsUSA |
| 135 | TSA | Text | 1 | reg_user.field_value where screen_number = 529 and field_number = 9 for the reported list_sequence | motb_ctso_part | Registration > Entry & Reports > Student District Defined > MOSIS CTSO: TSA |
| 140 | FFA | Text | 1 | reg_user.field_value where screen_number = 529 and field_number = 10 for the reported list_sequence | motb_ctso_part | Registration > Entry & Reports > Student District Defined > MOSIS CTSO: FFA |
| 145 | FEA | Text | 1 | reg_user.field_value where screen_number = 529 and field_number = 11 for the reported list_sequence | motb_ctso_part | Registration > Entry & Reports > Student District Defined > MOSIS CTSO: FEA |
| 150 | Pathways | Text | 1 | reg_user.field_value where screen_number = 529 and field_number = 12 for the reported list_sequence | motb_ctso_part | Registration > Entry & Reports > Student District Defined > MOSIS CTSO: Pathways |