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 EditorReport 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 no Primary enrollment 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 is on or after the Effective Date.
Generating the Extract
- Select the Extract Type, 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.
- If cross-site enrollment functionality is enabled at the district level, the Exclude Cross-Site Data checkbox will display (defaults to checked). Deselect if you want cross-site data included in the report.to display.
- 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 be generated. CSV, XML, and HTML formats can be used for 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 |
