Student Enrollment Extract (ISAT)

Contents

Introduction

This report includes demographic and program enrollment information for students, including enrollment in Idaho Standards Achievement Tests (ISAT) courses.

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 [ReEnrollments] tables based on the following criteria:

The student’s school must be included in the report and not excluded from state reporting.
The student must not be excluded from state reporting.
The student’s school exit date must occur after the report start date.
The student’s school entry date must occur on or before the report end date.
The student’s school enrollment must not be excluded from state reporting.

Special Program Selection

The report selects records from the [SpEnrollments] table based on the following criteria:

The program record must be associated with a school included in the report.
The program record exit date must be blank (0/0/0) or occur after the report end date.
The program record start date must occur on or before the report end date.

Back to Top

Report Input

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

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
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 – Run the report for all students in the current school that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running 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.
Start Date	Enter the start date for the report.
End Date	Enter the end date for the report.
Include Header	Select the checkbox to include a header with the name of each data column in the report output.

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 Number	The district number.	[Prefs]Value [Prefs]Name=districtnumber
2	School Number	The school number.	[Schools]ID
3	Student – Education Unique ID (EDUID)	The student’s state assigned identifier.	[Students]State_StudentNumber
4	Local Student ID	The student’s locally assigned identifier.	[Students]Students_Number
5	District Enrollment Date	The student’s first date of entry in the district.	[Students]DistrictEntryDate
6	School Enrollment Date	The student’s first date of entry to the school.	[Students]SchoolEntryDate
7	Student Last Name	The student’s last name.	[Students]Last_Name
8	Student First Name	The student’s first name.	[Students]First_Name
9	Student Middle Name	The student’s middle name.	[Students]Middle_Name
10	Student Date of Birth	The student’s date of birth.	[Students]DOB
11	Student Gender	The student’s gender.	[Students]Gender
12	Student Grade	The student’s grade level.	[Students]Grade_Level
13	Student Ethnicity Code	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
14	Reading Teacher ID	The locally assigned teacher number for the teacher assigned to the ISAT Reading course.	[Users]TeacherNumber [S_ID_CRS_X]ISAT_Type=RD
15	Reading Teacher	The first and last name of the teacher assigned to the ISAT Reading course.	[Users]First_Name [Users]Last_Name
16	Reading Class Description	The period number and course name for the ISAT Reading course.	[Section_Meeting]Period_Number [Section_Meeting]SectionID=[CC]SectionID [Courses]Course_Name
17	Mathematics Teacher ID	The locally assigned teacher number for the teacher assigned to the ISAT Mathematics course.	[Users]TeacherNumber [S_ID_CRS_X]ISAT_Type=MT
18	Mathematics Teacher	The first and last name of the teacher assigned to the ISAT Mathematics course.	[Users]First_Name [Users]Last_Name
19	Mathematics Class Description	The period number and course name for the ISAT Mathematics course.	[Section_Meeting]Period_Number [Section_Meeting]SectionID=[CC]SectionID [Courses]Course_Name
20	Language Usage Teacher ID	The locally assigned teacher number for the teacher assigned to the ISAT Language Usage course.	[Users]TeacherNumber [S_ID_CRS_X]ISAT_Type=LU
21	Language Usage Teacher	The first and last name of the teacher assigned to the ISAT Language Usage course.	[Users]First_Name [Users]Last_Name
22	Language Usage Class Description	The period number and course name for the ISAT Language Usage course.	[Section_Meeting]Period_Number [Section_Meeting]SectionID=[CC]SectionID [Courses]Course_Name
23	Science Teacher ID	The locally assigned teacher number for the teacher assigned to the ISAT Science course.	[Users]TeacherNumber [S_ID_CRS_X]ISAT_Type=SC
24	Science Teacher	The first and last name of the teacher assigned to the ISAT Science course.	[Users]First_Name [Users]Last_Name
25	Science Class Description	The period number and course name for the ISAT Science course.	[Section_Meeting]Period_Number [Section_Meeting]SectionID=[CC]SectionID [Courses]Course_Name
26	Reading AA	Indicates whether the student is enrolled in a reading program. The student must be enrolled in a special program where the program name starts with ACR.	[Gen]Name [Gen]Cat=specprog
27	Mathematics AA	Indicates whether the student is enrolled in a reading program. The student must be enrolled in a special program where the program name starts with ACM.	[Gen]Name [Gen]Cat=specprog
28	Language Usage AA	Indicates whether the student is enrolled in a reading program. The student must be enrolled in a special program where the program name starts with ACL.	[Gen]Name [Gen]Cat=specprog
29	Science AA	Indicates whether the student is enrolled in a reading program. The student must be enrolled in a special program where the program name starts with ACS.	[Gen]Name [Gen]Cat=specprog
30	Reading Accommodation 1	Indicates the student’s reading accommodation status.	[S_ID_SEN_X]Acc1
31	Reading Accommodation 2	Indicates the student’s reading accommodation status.	[S_ID_SEN_X]Acc2
32	Reading Accommodation 3	Indicates the student’s reading accommodation status.	[S_ID_SEN_X]Acc3
33	Reading Adaptation	Indicates the student’s reading adaptation status.	[S_ID_SEN_X]Adapt
34	Mathematics Accommodation 1	Indicates the student’s mathematics accommodation status.	[S_ID_SEN_X]Acc1
35	Mathematics Accommodation 2	Indicates the student’s mathematics accommodation status.	[S_ID_SEN_X]Acc2
36	Mathematics Accommodation 3	Indicates the student’s mathematics accommodation status.	[S_ID_SEN_X]Acc3
37	Mathematics Adaptation	Indicates the student’s mathematics adaptation status.	[S_ID_SEN_X]Adapt
38	Language Usage Accommodation 1	Indicates the student’s language usage accommodation status.	[S_ID_SEN_X]Acc1
39	Language Usage Accommodation 2	Indicates the student’s language usage accommodation status.	[S_ID_SEN_X]Acc2
40	Language Usage Accommodation 3	Indicates the student’s language usage accommodation status.	[S_ID_SEN_X]Acc3
41	Language Usage Adaptation	Indicates the student’s language usage adaptation status.	[S_ID_SEN_X]Adapt
42	Science Accommodation 1	Indicates the student’s science accommodation status.	[S_ID_SEN_X]Acc1
43	Science Accommodation 2	Indicates the student’s science accommodation status.	[S_ID_SEN_X]Acc2
44	Science Accommodation 3	Indicates the student’s science accommodation status.	[S_ID_SEN_X]Acc3
45	Science Adaptation	Indicates the student’s science adaptation status.	[S_ID_SEN_X]Adapt
46	Economically Disadvantaged	Indicates whether the student is economically disadvantaged	[Students]LunchStatus
47	Gifted and Talented	Indicates whether the student is qualifies as gifted and talented. The student must be enrolled in a special program with a name that contains GAT.	[SpEnrollments]ProgramID [Gen]Name [Gen]Cat=specprog
48	Homelessness	Indicates whether the student is homeless. The student must be enrolled in a special program with a name that contains HML.	[SpEnrollments]ProgramID [Gen]Name [Gen]Cat=specprog
49	Private School Student	Indicates the student’s private school status.	[S_ID_STU_X]PrivateSchoolStudent
50	Limited English Proficient	Indicates whether the student is designated as Limited English Proficient. The student must be enrolled in a special program with a name that begins with LEP. The special program exit date must be blank or after the report end date and the special program entry date must be on or before the report end date. This value is based on the LEP Status field on the Edit Special Program page.	[S_ID_SEN_X]LEPStatus [SpEnrollments]Enter_Date [SpEnrollments]Exit_Date [Gen]Name [Gen]Cat=specprog
51	Migrant	Indicates whether the student is a migrant. The student must be enrolled in a special program with the name MIG.	[SpEnrollments]ProgramID [Gen]Name [Gen]Cat=specprog
52	Neglected or Delinquent	Indicates whether the student is designated as neglected or delinquent. The student must be enrolled in a special program with the name NOD.	[SpEnrollments]ProgramID [Gen]Name [Gen]Cat=specprog
53	Professional Technical Education	Indicates whether the student is enrolled in a course that is designated as professional technical education (PTE). The student’s course enrollment date must be on or before the report end date and the course exit date must be after the report start date.	[S_ID_CRS_X]PTE [CC]Course_Number = [Courses]Course_Number [CC]StudentID
54	Special Education Status	The student’s special education status. The student must be enrolled in a special program with a name that begins with SPE. The special program exit date must be blank or after the report end date and the special program entry date must be on or before the report end date. If the special program name is SPE – X1, then the value is reported as X1. If the special program name is SPE – X2, then the value is reported as X2. If the special program name is SPE, then the value is reported as SE.	[SpEnrollments]Enter_Date [SpEnrollments]Exit_Date [Gen]Name [Gen]Cat=specprog
55	Title I A	Indicates whether the student is a migrant. The student must be enrolled in a special program with the name TIA.	[SpEnrollments]ProgramID [Gen]Name [Gen]Cat=specprog
56	504 Plan	Indicates whether the student is a migrant. The student must be enrolled in a special program with the name 504.	[SpEnrollments]ProgramID [Gen]Name [Gen]Cat=specprog
57	Reading Home School	Indicates whether the student is home schooled in reading. The student must be enrolled in a special program with a name that contains HMS.	[S_ID_SEN_X]ReadingHS [SpEnrollments]ProgramID [Gen]Name
58	Mathematics Home School	Indicates whether the student is home schooled in mathematics. The student must be enrolled in a special program with a name that contains HMS.	[S_ID_SEN_X]MathematicsHS [SpEnrollments]ProgramID [Gen]Name
59	Language Usage Home School	Indicates whether the student is home schooled in language usage. The student must be enrolled in a special program with a name that contains HMS.	[S_ID_SEN_X]LanguageHS [SpEnrollments]ProgramID [Gen]Name
60	Science Home School	Indicates whether the student is home schooled in science. The student must be enrolled in a special program with a name that contains HMS.	[S_ID_SEN_X]ScienceHS [SpEnrollments]ProgramID [Gen]Name
61	Reading Exited	Indicates whether the student exited the district for reading. If the student is transferred out of school (Enroll_Status value is 2), then a value of Y is reported. Otherwise, the value is reported blank.	[Students]Enroll_Status
62	Mathematics Exited	Indicates whether the student exited the district for mathematics. If the student is transferred out of school (Enroll_Status value is 2), then a value of Y is reported. Otherwise, the value is reported blank.	[Students]Enroll_Status
63	Language Usage Exited	Indicates whether the student exited the district for language usage. If the student is transferred out of school (Enroll_Status value is 2), then a value of Y is reported. Otherwise, the value is reported blank.	[Students]Enroll_Status
64	Science Exited	Indicates whether the student exited the district for science. If the student is transferred out of school (Enroll_Status value is 2), then a value of Y is reported. Otherwise, the value is reported blank.	[Students]Enroll_Status

Back to Top