ASVAB 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 '2018ALL1.0ASVAB' for the 2018 June Cycle. The MOSIS Download uses the School Year prompt to create this value. | Regulatory > MOSIS > MOSIS > MO MOSIS Download: School Year | |
| 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 | |
| 025 | Reporting District Code | Text | 6 | 1. First, see if the student has a 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 Demographics: Reporting District/School | |
| 030 | Reporting School Code | Text | 4 | 1. First, see if the student has a 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 Demographic > Entry/Withdrawal: 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 | ASVAB Test Date | Text | 10 | ltdb_stu_test.test_date where test_code='MOASVAB' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Definition panel: Test Date field | |
| 115 | Verbal Skills | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOVERBAL' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: Verbal Skills score | |
| 120 | Math Skills | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOMATH' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: Math Skills score | |
| 125 | Science and Tech Skills | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOSCTECH' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: Science and Tech Skills score | |
| 130 | General Science | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOGENSC' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: General Science score | |
| 135 | Arithmetic Reasoning | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOARIREAS' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: Arithmetic Reasoning score | |
| 140 | Word Knowledge | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOWORDKNOW' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: Word Knowledge score | |
| 145 | Paragraph Comprehension | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOPARACOMP' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: Paragraph Comprehension score | |
| 150 | Mathematics Knowledge | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOMATHKNOW' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: Math Knowledge score | |
| 155 | Electronics Information | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOELECINFO' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: Electronics Info score | |
| 160 | Auto and Shop Information | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOAUTO' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: Auto and Shop Info score | |
| 165 | Mechanical Comprehension | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOMECH' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: Mechanical Comprehension score | |
| 170 | Military Entrance Score | Integer | 2 | ltdb_stu_subtest.score where score_code maps to ltdb_subtest_score with test_code ='MOASVAB' and state_code_equiv='MOMES' | Test Scores > All > Student > Test History by Student > click appropriate Test Date for MOASVAB - 1 - 1 > Subtests and Scores panel: Military Entrance Score |