Iowa Testing Barcode

PATH: IA State Reporting > State Extracts > Iowa Testing Barcode

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.


Image 1: 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

  1. Select the Extract Type to be generated, in this case Iowa Testing Barcode.
  2. Enter an Effective Date in mmddyyyy format or by clicking the calendar icon and selecting a date. This field defaults to the current date.
  3. Select an Ad hoc Filter to limit the students in the report to those included in the filter.
  4. Select the appropriate checkboxes to indicate which Grades should be included in the report.
  5. 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.
  6. Indicate which Calendar(s) should be included in the report. All calendars selected should be in the same school year.
  7. Click Generate Extract to generate the report in the designated format.


Image 2: Iowa Testing Barcode Extract - State Format


Image 3: Iowa Testing Barcode Extract - CSV Format


Image 4: Iowa Testing Barcode Extract - XML Format


Image 5: 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

Save

Save

Save

Save