Student Upload | PowerSchool SIS Compliance

Contents

Introduction

This report includes student demographic data for upload to the EAGLE system. EAGLE is an online system for teachers and students that provides detailed feedback regarding student proficiency with grade level expectations (GLEs).

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 meet the following criteria:

The student must be enrolled in a school included in the report and the school must not be excluded from state reporting.
The student and the student’s school enrollment 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 exit date must occur after the school entry date (excludes no-shows).
The student must be enrolled in grade level 1 or higher.
If the File Type selected at report runtime is “1,” then the Partial File Indicator checkbox must be selected on the Louisiana State Information student page.

Report Input

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

Field	Description
Select Schools*	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. Note: The All Schools option is only available when running the report from the District Office.
Select Students*	Select one of the following: The Select [Number] Students Only – only runs the report for the students in the current selection who meet the selection criteria of the report. All Students - Includes all student records from the school that meet the selection criteria.
Start Date	Enter the report start date.
End Date	Enter the report end date.
Which date to use for determining enrollment level values?	Choose one of the following from the pop-up menu: Start Date – Determine the students to report based on whether they were enrolled in the school on the report start date. End Date – Determine the students to report based on whether they were enrolled in the school on the report end date.
File Type	Choose one of the following from the pop-up menu: 1 – Partial File – Report students with the Partial File Indicator checkbox selected on the Louisiana State Information student page. 2 – Entire Batch File – Include all students who meet the selection criteria. 3 – Delete/Replacement File – Choose this option to indicate that the records already exist in the state database and need to be updated.

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	Max Length
1	DistrictCode	The district identification code. This value must match the district code displayed in the eDIRECT District drop-down.	[Prefs]Value where [Prefs]Name=LA_dist_cd	3
2	SchoolCode	The school identification code. This value must match the school code displayed in the eDIRECT School drop-down.	[Schools]School_Number	3
3	LASID	The Louisiana Secure ID Number.	[Students]State_StudentNumber	10
4	LastName	The student’s last name.	[Students]Last_Name	20
5	FirstName	The student’s first name.	[Students]First_Name	15
6	MiddleName	The student’s middle initial.	[Students]Middle_Name	30
7	Gender	The student’s gender. Valid values: M – Male F – Female	[Students]Gender	1
8	BirthDate	The student’s date of birth in mm/dd/yyyy format.	[Students]DOB	10
9	Grade	The student’s grade level.	[Students]Grade_Level [ReEnrollments]Grade_Level	3
10	HispanicLatino	Indicates if the student's race is Hispanic or Latino. Valid values: Y – Yes N – No	[Students]Fedethnicity	1
11	RaceAmericanIndianAlaskaNative	Indicates if the student's race is American Indian or Alaska Native. Valid values: Y – Yes N – No	[StudentRace]Racecd [Students]Fedracedecline	1
12	RaceAsian	Indicates if the student's race is Asian. Valid values: Y – Yes N – No	[StudentRace]Racecd [Students]Fedracedecline	1
13	RaceBlackAfricanAmerican	Indicates if the student's race is Black or African American. Valid values: Y – Yes N – No	[StudentRace]Racecd [Students]Fedracedecline	1
14	RaceNativeHawaiianOtherPacificIslander	Indicates if the student's race is Native Hawaiian or Other Pacific Islander. Valid values: Y – Yes N – No	[StudentRace]Racecd [Students]Fedracedecline	1
15	RaceWhite	Indicates if the student's race is White. Valid values: Y – Yes N – No	[StudentRace]Racecd [Students]Fedracedecline	1
16	Migrant	Indicates if the student is a migrant and receives LEP funding. Valid values: Y – Yes N – No	[S_LA_STU_Language_X]LEPFundingSource	1
17	EducationClassification	The student's education classification. Valid values: 0 – Regular Student 1 – Special Education 2 – Gifted and Talented	[S_LA_STU_504SPED_X]SPEDIndicator	1
18	SpecialEdExceptionality	The student's disability. See the Appendix for valid values.	[S_LA_STU_504SPED_X]SER_StuRosterExcptnlty	3
19	LEP	Indicates if the student is a LEP student. Valid values: Y – LEP N – Not LEP	[S_LA_STU_Language_X]EnglishProficiency	1
20	Section504	Indicates if the student is classified as 504. Valid values: Y – Yes N – No	[S_LA_STU_504SPED_X]Is504_TF	1
21	McKinney-VentoAct	Indicates if the student is homeless. Valid values: Y – Yes N – No	[S_LA_STU_X]HomelessCode	1
22	ELATTS	Indicates if the student requires text-to-speech accommodations English Language Arts. Valid values: Y – Yes N – No	[S_LA_STU_Accomodations_X]ELATTS	1
23	EnglishITTS	Indicates if the student requires text-to-speech accommodations for English I. Valid values: Y – Yes N – No	[S_LA_STU_Accomodations_X]EnglishITTS	1
24	EnglishIITTS	Indicates if the student requires text-to-speech accommodations for English II. Valid values: Y – Yes N – No	[S_LA_STU_Accomodations_X]EnglishIITTS	1
25	MathTTS	Indicates if the student requires text-to-speech accommodations for math. Valid values: Y – Yes N – No	[S_LA_STU_Accomodations_X]MathTTS	1
26	MathSpanish	Indicates if the student requires Spanish-translated test content for math. Valid values: Y – Yes N – No	[S_LA_STU_Accomodations_X]MathSpanish	1
27	AlgebraITTS	Indicates if the student requires text-to-speech accommodations for Algebra I. Valid values: Y – Yes N – No	[S_LA_STU_Accomodations_X]AlgebraITTS	1
28	AlgebraISpanish	Indicates if the student requires Spanish-translated test content for Algebra I. Valid values: Y – Yes N – No	[S_LA_STU_Accomodations_X]AlgebraISpanish	1
29	GeometryTTS	Indicates if the student requires text-to-speech accommodations for Geometry. Valid values: Y – Yes N – No	[S_LA_STU_Accomodations_X]GeometryTTS	1
30	GeometrySpanish	Indicates if the student requires Spanish-translated test content for Geometry. Valid values: Y – Yes N – No	[S_LA_STU_Accomodations_X]GeometrySpanish	1
31	SocialTTS	Indicates if the student requires text-to-speech accommodations for Social Studies. Valid values: Y – Yes N – No	[S_LA_STU_Accomodations_X]SocialTTS	1
32	USHistoryTTS	Indicates if the student requires text-to-speech accommodations for US History. Valid values: Y – Yes N – No	[S_LA_STU_Accomodations_X]USHistoryTTS	1