ID Student Enrollment Extract Report

Introduction

The report generates student enrollment data for use with the Idaho State Assessment (ISAT) system. This report provides basic student demographic, course offering, and special program information for students enrolled within a specified date range. The report extracts students in grade 3 and above who are enrolled in the selected reporting period.The report can be run at the district and school level.

Report output file name format: ISAT_SE_[CurrentDate].csv

Navigation: Start Page, Reports, State Reports, ISAT Data Collection, ID Student Enrollment Extract

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:

Student's grade level is 3 or higher.
Student's enrollment entry date is on or before the report end date.
Student's enrollment exit date is after the report start date.
Student is not marked as "Exclude from State Reporting".
Student's school is not marked as "Exclude from State Reporting".

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.
Current Selection Students	Option to limit report to students from the current student selection.
Start Date	Enter the start date for the report.
End Date	Enter the end date for the report.
Grace Period for Deletion (days)	Number of days (0-999) added to exit date to determine if student should be marked for deletion.

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	DistrictID	The state-assigned district identifier	[Prefs]DistrictNumber
2	SchoolID	The state-assigned school identifier. Uses alternate school number if populated, otherwise school number	[Schools]Alternate_School_Number or School_Number
3	LastOrSurname	Student's last name (legal last name if available)	[StudentCoreFields]PSCORE_LEGAL_LAST_NAME or [Students]Last_Name
4	FirstName	Student's first name (legal first name if available)	[StudentCoreFields]PSCORE_LEGAL_FIRST_NAME or [Students]First_Name
5	MiddleName	Student's middle name (legal middle name if available)	[StudentCoreFields]PSCORE_LEGAL_MIDDLE_NAME or [Students]Middle_Name
6	BirthDate	Student's date of birth in MMDDYYYY format	[Students]DOB
7	EDUID	Idaho Education Unique Identifier, left-padded with zeros to 9 digits	[Students]State_StudentNumber
8	Grade	Student's grade level (PK, KG, NG, 01-12)	[Students]Grade_Level, [S_ID_STU_X]No_Grade
9	Gender	Student's gender (M or F) using legal gender if available	[StudentCoreFields]PSCORE_LEGAL_GENDER or [Students]Gender
10	HispanicOrLatinoEthnicity	Indicates if student is Hispanic/Latino (Y/N)	[Students]FedEthnicity
11	AmericanIndianOrAlaskaNative	Indicates American Indian or Alaska Native race (Y/N)	[StudentRace]RaceCd = '01'
12	Asian	Indicates Asian race (Y/N)	[StudentRace]RaceCd = '02'
13	BlackOrAfricanAmerican	Indicates Black or African American race (Y/N)	[StudentRace]RaceCd = '03'
14	White	Indicates White race (Y/N)	[StudentRace]RaceCd = '05'
15	NativeHawaiianOrOtherPacificIslander	Indicates Native Hawaiian or Pacific Islander race (Y/N)	[StudentRace]RaceCd = '04'
16	Section504Status	Indicates if student has an active 504 plan (Y/N)	[SPEnrollments] where program name contains '504'
17	SpecialEducationStatus	Indicates if student has active Special Education enrollment (Y/N)	[SPEnrollments] where program starts with 'SPE' and has Exceptionality
18	IDAAEligible	Indicates if student is eligible for IDAA testing (Y/N)	[S_ID_STU_X]IDAAEligible
19	PrimaryDisabilityType	Student's primary disability code (SLD, ID, SI, LI, EBD, OHI, OI, DE, VI, DB, MD, DD, ASD, TBI, or N/A)	[S_ID_SEN_X]Exceptionality
20	ELStatus	Indicates if student is an English Learner (Y/N)	[SPEnrollments] LEP/EL program with LEP status
21	ELCategory	English Learner category code (L1, LE, EW, X1-X4, FL, SO, or N/A)	[S_ID_SEN_X]LEPStatus
22	ISATPaperTester	Indicates if student will test on paper for ISAT (Y/N or blank)	[S_ID_STU_X]ISATPaperTester
23	IDAAFixedForm	Indicates if student will use IDAA fixed form testing (Y/N or blank)	[S_ID_STU_X]IDAAFixedForm
24	DeleteStudent	Indicates if student should be deleted based on grace period (Y/N). Y if report end date > (exit date + grace period days)	Calculated from exit date and grace period