IRI Student Extract

Contents

Introduction

This report returns course enrollments and special program enrollments for 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] and [CC] tables based on the following criteria:

The student must be enrolled in a grade level selected at report runtime.
The student must have a course enrollment at a school included in the report.
The course enrollment entry date must occur on or before the report end date.
The course enrollment exit date must occur after the report start date.
The course enrollment must be associated with a valid course number from the Courses table.
The course enrollment must be associated with a section that is scheduled for one of the periods selected at report runtime.

Back to Top

Report Input

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

Field	Description
Grades (leave blank for all)	Select the checkboxes for the appropriate grade levels to include in the report.
Period(s) (leave blank for all)	Select the checkboxes for the appropriate class periods to include in the report.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10:05 AM.
Include Header	Select the checkbox to include a header with column names in the report output.
Customer ID	Enter the customer account number for AIMSWEB.
District Name	Enter the district name to print on the report.
School Name	Enter the school name to print on the report.
Start Date	Enter the start date for the report.
End Date	Enter the end date for the report.
Unique Student ID to extract	Choose one of the following from the pop-up menu to print for students on the report: Student Number State Student ID (EUID)

Back to Top

Report Output

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

Item #	Data Element	Description	[Table]FieldName
1	District Name	The district name, as entered at report runtime.	N/A
2	School Name	The school name, as entered at report runtime.	N/A
3	Teacher First Name	The teacher’s first name.	[Users]First_Name
4	Teacher Middle Name	The teacher’s middle name.	[Users]Middle_Name
5	Teacher Last Name	The teacher’s last name.	[Users]Last_Name
6	Teacher Title	The teacher’s title (Mr., Mrs. etc.).	[Users]Title
7	Teacher Phone	The teacher’s phone number.	[Users]School_Phone
8	Teacher Email	The teacher’s email address.	[Users]Email_Addr
9	Class Name	The name of the class.	[Courses]Course_Name
10	Student First Name	The student’s first name.	[Students]First_Name
11	Student Middle Name	The student’s middle name.	[Students]Middle_Name
12	Student Last Name	The student’s last name.	[Students]Last_Name
13	Unique Identifier	The student’s unique identifier. Either the student’s locally assigned identifier or their state assigned identifier is reported, based on the selection at report runtime.	[Students]Student_Number [Students]State_StudentNumber
14	Student Email	The student’s email address.	N/A
15	Grade	The student’s grade level.	[Students]Grade_Level
16	Enrollment Grade	The student’s enrollment grade level.	[Students]Grade_Level
17	Gender	The student’s gender.	[Students]Gender
18	DOB	The student’s date of birth.	[Students]DOB
19	Meal Status	The student’s meal status. Valid values: Free (reported from F or FDC) Reduced None	[Students]LunchStatus
20	Service Code	Indicates whether the student is enrolled in special education. The student must be enrolled in a special program with the name SPE or TIA. The special program entry date must occur on or before the report end date and the special program exit date must be after the report start date. If the student’s special program name is SPE, then Special Ed is reported. If the student’s special program name is TIA, then Title I is reported. If the student is note enrolled in either program, then General Ed is reported.	[SpEnrollments]Enter_Date [SpEnrollments]Exit_Date [SpEnrollments]ProgramID [Gen]Name [Gen]Cat=specprog
21	Ethnicity	The student’s ethnicity code. If the federal ethnicity option is selected, then a value of 06 is reported. If the student is assigned more than one race, then a value of 07 is reported. If no value is selected for the student then “ErrorNotSet” is returned. Valid values: 01 – American Indian or Alaska Native 02 – Asian 03 – Black or African American 04 – Native Hawaiian or Pacific Islander 05 – White 06 - Hispanic 07 – Multi Race	[Students]FedEthnicity [StudentRace]RaceCd
22	IDEIA	Reported as “No.”	N/A
23	ESL	Indicates whether the student is enrolled in an English as a Second Language (ESL) program. The student must be enrolled in a special program with the name LEP or LEP1. The special program entry date must occur on or before the report end date and the special program exit date must be after the report start date.	[SpEnrollments]Enter_Date [SpEnrollments]Exit_Date [SpEnrollments]ProgramID [Gen]Name [Gen]Cat=specprog
24	Section 504	Indicates whether the student is enrolled in Section 504 program. The student must be enrolled in a special program with the name 504. The special program entry date must occur on or before the report end date and the special program exit date must be after the report start date.	[SpEnrollments]Enter_Date [SpEnrollments]Exit_Date [SpEnrollments]ProgramID [Gen]Name [Gen]Cat=specprog
25	Gifted Talented	Indicates whether the student is enrolled in a gifted and talented program. The student must be enrolled in a special program with the name GAT. The special program entry date must occur on or before the report end date and the special program exit date must be after the report start date.	[SpEnrollments]Enter_Date [SpEnrollments]Exit_Date [SpEnrollments]ProgramID [Gen]Name [Gen]Cat=specprog
26	Behavioral Disorder	Reported as “No.”	N/A
27	Correctional	Reported as “No.”	N/A
28	Summer School	Reported as “No.”	N/A
29	After School	Reported as “No.”	N/A
20	Mobility	Reported as “No.”	N/A
31	RFEP	Reported as “No.”	N/A
32	IEP Goal	Reported as “No.”	N/A
33	Intervention Level	Reported as “Blank.”	N/A
34	Federal Disability Categories	Reported as “Blank.”	N/A
35	School Year	Derived from the term selected at the top of the page	N/A
36	IRI_90Perc	Indicates whether the student meets IRI 90% criteria.	[S_ID_STU_X]IRI_90Perc

Back to Top