Tool Search: MOSIS Extracts
The MOSIS ASVAB extract generates a report of students who took the Armed Services Vocational Aptitude Battery (ASVAB) exam during the school year.
See the MOSIS Extracts article for additional information.
Report Logic
- Reports a record for any student who has taken the ASVAB test during the school year and was enrolled during the date range selected on the extract editor.
- Reports the latest High School Enrollment when there are multiple enrollment records for a student. Only one record reports.
- Only reports from High School Enrollments and Calendars.
- Reports the highest score when there are multiple assessments taken with different scores.
Generate Report
- Navigate to the MOSIS Extracts editor.
- Select the ASVAB file from the Extract Type dropdown.
- Enter a Date Range.
- Optional: select an Ad Hoc Filter to narrow results.
- Select a Format, either State Format (CSV), tab delimited, HTML, or XML.
- Select which Calendar(s) to include on the report.
- Click Generate Extract.
Report Layout
| # | Data Element Label | Description | Location |
|---|---|---|---|
| 1 | Collection Version | Always reports as "2024ALL1.0ASVAB" for the 2024 June cycle. Alphanumeric, 50 characters | Not dynamically stored |
| 2 | Current School Year | The ending year of the current school year as displayed in the selected year in the Campus toolbar. Numeric, 4 digits (YYYY) | Calendar Information > School Year > End Year SchoolYear.endYear |
| 3 | Reporting District Code | The DESE-assigned 6-digit county district code. Numeric, 6 digits | Enrollments > State Reporting Fields > Residing District |
| 4 | Reporting School Code | The DESE-assigned 4-digit school code for the reporting school. Numeric, 4 digits | Enrollments > State reporting Fields > Reporting School |
| 5 | State ID | The state-assigned student identifier. Numeric, 10 digits | Demographics > Person Identifiers > Student State ID Person.stateID |
| 6 | Local Student ID | The local student ID maintained by the district. Allows for data to be associated to local systems from DESE source Systems. Alphanumeric, 20 characters | Demographics > Person Identifiers > Local Student Number Person.studentNumber |
| 7 | Last Name | The student's last name. Alphanumeric, 60 characters | Demographics > Person Information > Last Name Identity.lastName |
| 8 | First Name | The student's first name. Alphanumeric, 60 characters | Demographics > Person Information > First Name Identity.firstName |
| 9 | Middle Name | The student's middle name. Alphanumeric, 60 characters | Demographics > Person Information > Middle Name Identity.middleName |
| 10 | Suffix | The student's name suffix. Alphanumeric, 10 characters. | Demographics > Person Information > Suffix Identity.suffix |
| 11 | Date of Birth | The student's birth date. Date field, 10 characters (MM/DD/YYYY) | Demographics > Person Information > Birth Date Identity.birthDate |
| 12 | Student Grade Level | The grade level at the time data is being submitted. Alphanumeric, 2 characters | Enrollments > General Enrollment Fields > Grade Enrollment.grade To identify the appropriate mapped value: Calendar > Grade Levels > Grade Level Detail |
| 13 | Gender | The student's gender. Alphanumeric, 1 character | Demographics > Person Information > Gender Identity.gender |
| 15 | Race Ethnicity | The Race/Ethnicity Code of the student. The following values are returned:
Alphanumeric, 1 character | Demographics > Person Information > Race Ethnicity Identity.raceEthnicity |
| 16 | Test Date | The day of the test. Date field, 10 characters (MM/DD/YYYY) | Assessment > Date |
| 17 | Verbal Skills | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB VS. Numeric, 2 digits | Assessment > Scale Score |
| 18 | Math Skills | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB MS. Numeric, 2 digits | Assessment > Scale Score |
| 19 | SnT Skills | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB ST. Numeric, 2 digits | Assessment > Scale Score |
| 20 | General Science | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB GS. Numeric, 2 digits | Assessment > Scale Score |
| 21 | Arithmetic Reasoning | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB AR. Numeric, 2 digits | Assessment > Scale Score |
| 22 | Word Knowledge | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB WK. Numeric, 2 digits | Assessment > Scale Score |
| 23 | Para Comprehension | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB PC. Numeric, 2 digits | Assessment > Scale Score |
| 24 | Math Knowledge | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB MK. Numeric, 2 digits | Assessment > Scale Score |
| 25 | Electronics Info | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB EI. Numeric, 2 digits | Assessment > Scale Score |
| 26 | Auto Shop Info | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB AS. Numeric, 2 digits | Assessment > Scale Score |
| 27 | Mech Comprehension | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB MC. Numeric, 2 digits | Assessment > Scale Score |
| 28 | Entrance Score | The scale score for those tests under a parent test that has a national test of ASVAB, and the test has the code of ASVAB MES. Numeric, 2 digits | Assessment > Scale Score |
