The Iowa Testing Barcode Extract allows an LEA (Local Education Agency) to send a file to the Iowa Testing Program, which returns barcode labels to be affixed to the student's ITBS or ITED answer sheet.
Iowa Testing Barcode Extract
Report Logic
A record reports for each Primary student enrollment in the calendar and grade selected where the End Date is null or on or after the Effective Date. If there is not a Primary enrollment that meets the above criteria, a record reports for the most recent enrollment with a Service Type of S: Partial, if the Start Date is on or before and the End Date on or after the Effective Date.
Generating the Extract
- Select the Extract Type to be generated, in this case Iowa Testing Barcode.
- Enter an Effective Date in mmddyyyy format or by clicking the calendar icon and selecting a date. This field defaults to the current date.
- Select an Ad hoc Filter to limit the students in the report to those included in the filter.
- Select the appropriate checkboxes to indicate which Grades should be included in the report.
- Select the Format in which the report should generate. CSV, XML and HTML formats can be used to data review and verification, whereas State Format should be used when submitting data to the state.
- Indicate which Calendar(s) should be included in the report. All calendars selected should be in the same school year.
- Click Generate Extract to generate the report in the designated format.
Iowa Testing Barcode Extract - State Format
Iowa Testing Barcode Extract - CSV Format
Iowa Testing Barcode Extract - XML Format
Iowa Testing Barcode Extract - HTML Format
Extract Layout
| Element Name | Description | Campus Location |
LAST NAME | The legal last name of the student. Alphanumeric, 60 characters | Census > People > Demographics > Last Name Identity.lastName |
FIRST NAME | The legal first name of the student. Alphanumeric, 60 characters | Census > People > Demographics > First Name Identity.firstName |
BIRTH DATE | The student's date of birth. Date field: MM/DD/YYYY | Census > People > Demographics > Birth Date Identity.birthDate |
GENDER | Indicates whether the student is Male: M or Female: F. Alphanumeric, 1 character | Census > People > Demographics > Gender Identity.gender |
GRADE | The student's current grade level. Alphanumeric, 2 characters | Student Information > General > Enrollments > Grade Enrollment.grade |
| BUILDING NAME | The name of the school building the student currently attends. Alphanumeric, 20 characters | System Administration > Resources > School > Name School.name |
| CLASS NAME | The name of the primary teacher of the course in which the student is scheduled that is marked as Homeroom and not marked as State Exclude with the most recent section enrollment Start Date that is on or before the extract Effective Date. Alphanumeric, 20 characters | Scheduling > Courses > Course > Homeroom Course.homeroom |
| STATE ID | The state-assigned student identification number. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > State ID Person.stateID |
| AMERICAN IND | Indicates if the student is of American Indian or Alaska Native descent. If Yes, reports as 1. Otherwise, 0. Numeric, 1 digit | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicityFed |
| ASIAN | Indicates if the student is of Asian descent. If Yes, reports as 1. Otherwise, 0. Numeric, 1 digit | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicityFed |
| AFROAMERICAN | Indicates if the student is of Black or African American descent. If Yes, reports as 1. Otherwise, 0. Numeric, 1 digit | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicityFed |
| HISPANIC LATINO | Indicates if the student is of Hispanic/Latino ethnicity. If Yes, reports as 1. Otherwise, 0. Numeric, 1 digit | Census > People > Demographics > Race/Ethnicity > Is the individual Hispanic/Latino? Identitiy. hispanicEthnicity |
| HAWAII PI | Indicates if the student is of Native Hawaiian or Other Pacific Islander descent. If Yes, reports as 1. Otherwise, 0. Numeric, 1 digit | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicityFed |
| WHITE | Indicates if the student is of White descent. If Yes, reports as 1. Otherwise, 0. Numeric, 1 digit | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicityFed |
| OI Field 1 | The value entered in the first Other Information field on the Iowa Testing Program answer sheet. Currently reports as Null. Numeric, 3 digits | N/A |
| OI Field 2 | The value entered in the second Other Information field on the Iowa Testing Program answer sheet. Currently reports as Null. Numeric, 3 digits | N/A |
| OI Field 3 | Indicates if the student's parent(s) or guardian(s) are on active military duty. Reports as 1 if the student has a Military Connections record active on the extract Effective Date with a Status of 1: Active Duty, Deployed or 2: Active Duty, Not Deployed. Otherwise reports as 0. Numeric, 1 digit | Census > People > Military Connections Calculated, not dynamically stored |
| ADM P | The Full Academic Year (FAY) status, which indicates whether or not the student changed district or building between the previous test date and the current test date. Currently reports as Null. | N/A |
| PROG SE | Indicates if the student has an IEP. Reports as 1 if the student has an IEP level of 0, 1, 2, or 3. Otherwise reports as 0. Numeric, 1 digit | Student Information > General > Enrollments > Special Ed Fields > IEP Level Enrollment.special EdSetting |
| PROG 504 | Indicates if the student has a 504 plan. Reports as 1 if the student has a Section 504 record with a Start Date on or before the extract Effective Date and an End Date that is null or on or after the extract Effective Date. Otherwise reports as 0. Numeric, 1 digit | Student Information > Program Participation > Section 504 Calculated, not dynamically stored |
| PROG FRL | Indicates if the student is eligible for free or reduced lunch. If State Code is 1: Reduced or 2: Free, reports as 1. Otherwise reports as 0. Numeric, 1 digit | FRAM > Eligibility > State Code POSEligibility.eligibility |
| PROG GT | Indicates if the student is identified as gifted/talented. Reports as 1 if the student has a Gifted/Talented record with a Start Date on or before the extract Effective Date and an End Date that is null or on or after the enrollment Calendar End Date. Otherwise reports as 0. Numeric, 1 digit | Student Information > Program Participation > Gifted/Talented Calculated, not dynamically stored |
| PROG EL | Indicates if the student is considered to be an English language learner. When the student has an EL record with the most recent Identified Date on or before the extract Effective Date and a Program Exit Date that is null or on or after the extract Effective Date, reports as 1. Otherwise reports as 0. Numeric, 1 digit | Student Information > Program Participation > English Learners (EL) > Program Status Lep.programStatus |
| PROG MG | Indicates if the student is considered migratory. This field always reports as 0. Numeric, 1 digit | Student Information > General > Enrollments > State Reporting Fields > Migrant Enrollment.migrant |
| PROG TILANG | Indicates if the student participated in a Title 1 Targeted Assistance Reading program. If the most recent School History record with an Effective Date on or before the extract Effective Date has a Title 1 value of Targeted Assistance Eligible - No Program, Schoolwide Eligible - No Program, OR Not a Title I School, reports as 0. If the School History record has a Title 1 value of Schoolwide Program, Targeted Assistance Program, Schoolwide Eligible - Targeted Assistance or is null, reports based on the student's Title 1 Status. If the student's Title 1 record has a Start Date on or before the extract Effective Date and an End Date that is null or on or after the Start Date of the enrollment Calendar and a Title 1 Program value of 1 or 3, reports as 1. Otherwise reports as 0. Numeric, 1 digit | System Administration > Resources > School > School History > Title 1; Student Information > Program Participation > Title 1 SchoolAttribute.title1 Enrollment.title1 |
| PROG TIMATH | Indicates if the student participated in a Title 1 Targeted Assistance Math program. If the most recent School History record with an Effective Date on or before the extract Effective Date has a Title 1 value of Targeted Assistance Eligible - No Program, Schoolwide Eligible - No Program, OR Not a Title I School, reports as 0. If the School History record has a Title 1 value of Schoolwide Program, Targeted Assistance Program, Schoolwide Eligible - Targeted Assistance or is null, reports based on the student's Title 1 Status. If the student's Title 1 record has a Start Date on or before the extract Effective Date and an End Date that is null or on or after the Start Date of the enrollment Calendar and a Title 1 Program value of 1 or 3, reports as 1. Otherwise reports as 0. Numeric, 1 digit | System Administration > Resources > School > School History > Title 1; Student Information > Program Participation > Title 1 SchoolAttribute.title1 Enrollment.title1 |
| FOSTER CARE | Indicates if the student is in foster care. Reports as 1 if the student has a Foster Care record active on the extract Effective Date with 1 or 2 selected for If not in Foster Care. Otherwise reports as 0. Numeric, 1 digit | Student Information > General > Enrollments > State Reporting Fields > Foster Care Enrollment.fosterCare |
| HOMELESS | Reports as 1 if the student has a Homeless record with a Start Date on or before the extract Effective Date, Start and End Dates that fall within the calendar of enrollment (or End Date is null), and an Initial Homeless TYpe of 1, 2, 3, or 6. Numeric, 1 digit | Student Information > Program Participation > Homeless > Initial Homeless Type Homeless.primary NightTimeResidence |
| LOCAL ID | The student identification number assigned and maintained by the district. Numeric, 20 digits | Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber |
| RES DIST | The state-assigned code of the district where the parents/guardians reside. Alphanumeric, 4 characters | Student Information > General > Enrollments > State Reporting Fields > Resident District Enrollment. residentDistrict |
| ATT SCHOOL | The code assigned to each school building by the Iowa Department of Education. Numeric, 4 digits | System Administration > Resources > School > Number School.number |
| ENT TYPE | The start status of the enrollment period. Numeric, 2 digits | Student Information > General > Enrollments > Start Status Enrollment. startStatus |
