Iowa Statewide Assessment of Student Progress Extract

Contents

Introduction

This extract serves two different purposes to register students for state testing based on each selection criteria:

If run using the Assessment Registration selection criteria, the report extracts current, active students in grades 3-11 that enrolled or re-enrolled in the district after October 1 of the current year, excluding students with Entry Code 16.
If run using the Assessment Accommodations selection criteria, the report extracts current, active students in grades 3-11 that have at least one assessment accommodation.

The report can also be run for a user-defined selection of students.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] or [ReEnrollments] table that meets all of the following criteria:

The student must not be excluded from state reporting.
The student’s school exit date must occur after the school entry date.
The student’s school must not be excluded from state reporting.
Additional selection criteria apply when the default option to "Only include students meeting the state criteria" is selected. Refer to the Output Option below for additional details.
Assessment Registration selects students that enrolled in grades 3-11 after October 1, and remain actively enrolled when this extract is generated.
Assessment Accommodations select students in grades 3-11 that have been assigned at least one assessment accommodation on the IA Testing tab.
User-Defined Extract selects all students in grades 3-11 that are actively enrolled.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Schools to Include	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. All Schools option is only available when running the report from the District Office.
Test Mode: Online/Paper Default	Select the output format: Valid values: (O) Online (default) (P) Paper
Extract Run Options	Select one of the extract options: Assessment Registration Assessment Accommodations This option only receives an Online extract. User-Defined Extract
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students (default) - Run the report for all students in the current school or district that meet the selection criteria. If running the report for a single student, or group of students, select the students prior to running the report. This option appears only when the Extract Option is User-Defined Extract.
Output Option	Choose one of the following: Only include students meeting the state criteria (default): If you choose this option, the report includes only students who meet the following state criteria: Enrollment status is 0 Grade level is 3-11 Was not actively enrolled in any district school on October 1 of the current school year, but enrolled or re-enrolled in the district after October 1. Entry Code is not 16 Include user-defined selection of students: If you choose this option, the report includes the students you select, regardless of whether or not the students meet the state criteria.

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Type	Max Length
1	D0080 Student Last Name	LAST_NAME The student’s last name. PowerSchool removes commas, tildes, accent, and special characters.	[Students]Last_Name	A	20
2	D0060 Student First Name	FIRST_NAME The student’s first name. PowerSchool removes commas, tildes, accent, and special characters.	[Students]First_Name	A	20
3	D0020 Birth Date	BIRTH_DATE The student’s date of birth reported in the format MM/DD/YYYY.	[Students]DOB	D	10
4	D0050 Gender	GENDER The student’s gender. Valid values: M F	[Students]Gender	A	1
5	B0112 Grade Level_ISASP	GRADE_LEVEL The student’s grade level. Converted values: 0 – KG Less than 0 – PK	[Students]Grade_Level	A	2
6	Attending Org Code	ATT_ORG The organization number for the district and school that provided the assessment. This is a 4-character District Number along with the 4-character School Number. Both numbers are padded with leading zeros as required. Note: For the School Number portion of the code, the hierarchy is as follows: The School Number entered on the Enrollment tab and displayed on the Iowa Testing Bar Code Input page. The Alternate School Number assigned to the school on the Edit School page at the District. The number assigned to the school on the Edit School page at the District.	District Number: [Prefs]Name=districtnumber [Prefs]Value School Number: [S_IA_STU_X]School_Override [Schools]Alternate_SchoolNumber [Students]SchoolID = [Schools]School_Number
7	B0020 Class/Teacher Name	CLASS_NAME The report extracts the value entered on the Iowa Testing Bar Code Input page. PowerSchool removes commas, tildes, accents and special characters	[S_IA_STU_X]Class_Teacher_Name	A	20
8	K0020 State Student ID	STATE_ID The student’s state assigned identifier.	[Students]State_StudentNumber	N	10
9	D0043 American Indian or Alaska Native	AMERICAN_IND Indicates whether the student is American Indian or Alaska Native. Valid values: 1 – Yes 0 – No	[StudentRace]RaceCd = I	N	1
10	D0044 Asian	ASIAN Indicates whether the student is Asian. Valid values: 1 – Yes 0 – No	[StudentRace]RaceCd = A	N	1
11	D0045 Black or African American	AFROAMERICAN Indicates whether the student is Black or African American. Valid values: 1 – Yes 0 – No	[StudentRace]RaceCd = B	N	1
12	D0042 Hispanic / Latino	HISPANIC_LATINO Indicates whether the student is Hispanic or Latino. Valid values: 1 – Yes 0 – No	[Students]FedEthnicity = 0 or 1	N	1
13	D0046 Native Hawaiian or Other Pacific Islander	HAWAII_PI Indicates whether the student is Native Hawaiian or Other Pacific Islander. Valid values: 1 – Yes 0 – No	[StudentRace]RaceCd = P	N	1
14	D0047 White	WHITE Indicates whether the student is White. Valid values: 1 – Yes 0 – No	[StudentRace]RaceCd = W	N	1
15	Filler	FILLER Output is blank	N/A	N/A	N/A
16	Online Testing	ONLINE Output is blank	N/A	N/A	N/A
17	D0010 Local Student ID	LOCAL_ID The student number	[Students]Student_Number	A	10
18	D0095 Military Connected Status	MILITARY Indicates whether any of the student's parents or guardians are on active military duty at the time of submission. Valid values: 1 – Yes 0 – No blank	[S_IA_STU_X]Military_Connected_Status	N	1
19	Filler	FILLER	N/A	N/A	N/A
20	B0115 Special Education_ISASP	PROG_SE Derived based on IEP Level Valid values: 1 – If IEP Level is 0, 1, 2 or 3 0 – If IEP Level is 99 or NULL	Derived from [S_IA_STU_X]IEP_Level	N	1
21	D0300 Section 504	PROG_504 Indicates whether the student participates in Section 504. Valid value: 1 – Yes 0 – No	[S_IA_STU_X]Section_504	N	1
22	B0110 Free or Reduced Lunch_ISASP	PROG_FRL Indicates whether a student receives Free or Reduced Lunch, based on Lunch Status. A value of 1 indicates that the student receives free or reduced lunch. A value of 0 indicates that the student does not receive free or reduced lunch. Valid values: R – 1 F – 1 FDC – 1 RDC - 1 E – 0 T – 0 P – 0 NULL - 0	[Students]LunchStatus	N	1
23	D0310 Gifted/Talented	PROG_GT Indicates whether the student is qualified as Gifted/Talented. Valid values: 1 – Yes 0 - No	[S_IA_STU_X]Gifted	N	1
24	B0120 English Language Learner_ISASP	PROG_ELL Indicates student’s English Language Learner program status. Derived based on English Language Learner Status. Valid values: 1 – ELL Status (D0420) is 1 or 2 0 – ELL Status (D0420) is 4, 5, 7, 8, 99 or NULL	[S_IA_STU_X]ELL_Status	N	1
25	Filler	FILLER	N/A	N/A	N/A
26	D0250 Title I Reading	PROG_T1LANG Indicates whether the student receives assistance for Title I reading. The default value is 0. Valid values: 1 – Yes 0 - No	[S_IA_STU_X]TI_Target_Assist_Reading	N	1
27	D0252 Title I Math	PROG_T1MATH Indicates whether the student receives assistance for Title I math. The default value is 0. Valid values: 1 – Yes 0 - No	[S_IA_STU_X]TI_Target_Assist_Math	N	1
28	Filler	FILLER	N/A	N/A	N/A
29	B0170 Homeless_ISASP	HOMELESS Indicates whether student was homeless at some time during the year. Valid values: 1 – Homeless Type (D0340) is 1, 2, 3, or 6 0 – Homeless Type (D0340) is 99 or NULL	[Students]Homeless_Code	N	1
30	D0200 Resident District	RES_DIST The district in which the student resides, reported as a 4-digit numeric code. Padded with leading zeros if required.	[Students]DistrictOfResidence	A	4
31	Test Code	TEST_CODE The code to identify a test based on the grade level. Valid values: For Language/Writing: LA03 through LA11 For Reading: RD03 through RD11 For Mathematics: MA03 through MA11 For Science: SC05, SC08, and SC10	Calculated based on grade level All students get LA, RD, and MA SC is only for grades 05, 08, and 10	N/A	N/A
32	B0180 Entry Code_ISASP	ENR_TYPE The reason the student enrolled in the school for that particular school enrollment.	[Students]EntryCode [ReEnrollments]EntryCode	A	2
33	Language of Interface	IF_LANG Indicates the language of the menus and directions. Valid values: Blank SPA	[S_IA_STU_X]IF_LANG Output is SPA if Spanish is selected, if it is English the column is left blank	N/A	N/A
34	Alternate Language	ALT_LANG The alternate language of the test questions and answer choices. Valid values: Blank SPA	[S_IA_STU_X]ALT_LANG Output is SPA if Spanish is selected, if it is English the column is left blank	N/A	N/A
35	Text To Speech	TTS This indicates if student can have any on-screen text read aloud to them by the computer. Valid values: Blank 1	[S_IA_STU_X]TTS output is 1 if Enabled, blank if Disabled	N/A	N/A
36	Line Reader	LINE_RDR Indicates enabled feature that blocks all but a small section of the text on screen. Valid values: Blank 1	[S_IA_STU_X]LINE_RDR output is 1 if Enabled, blank if Disabled	N/A	N/A
37	Answer Masking	ANSWER_MASK Masks all answer choices until student clicks to reveal them. Valid values: Blank 1	[S_IA_STU_X]ANSWER_MASK output is 1 if Enabled, blank if Disabled	N/A	N/A
38	Color Contrast	COLOR_CONT Changes the color scheme of the test. Valid values: Blank black-cream black-lblue dgray-pgreen white-black yellow-blue black-lmagenta	[S_IA_STU_X]COLOR_CONT	N/A	N/A