L - Student Ethnicity File 2022-2023

Introduction

The Ethnicity file includes at least one ethnicity record for each student served in the district during the current school year. If the Ethnicity Code equals 10 (Non-Hispanic), then this is the only record for the student. If the student is Hispanic, there can be multiple records for all sub-categories of Hispanic with which the student identifies.

Selection Criteria

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

Student Selection

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

The student's school enrollment must be within the current school year:

1. The student's school Entry Date must be on or before the last day of the current school year.
2. The student's school Exit Date must be on or after the first day of the current school year.
3. The student must not be excluded from state reporting.
4. The student must not be excluded from CEDARS reporting.
5. The student's school must not be excluded from state reporting.

Report Input

For help with report navigation and generation, 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 the 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.
Current Selection Students	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 or district that meet the selection criteria. If you are running the report for a single student, or a group of students, select the students before running the report.
School Year	Choose the year for which to run the report.
Scheduling	Select Schedule to run the report on a specific date and time. The default selection is "Run Now."

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	Reqd	Field Type	Length
L01	School Year	The four-digit year in which the school year ends.	[Terms]LastDay	Yes	Char	4
L02	Serving County District Code	The county district code for the district providing service to the student. Use leading zeroes where necessary.	[Prefs]Value [Prefs]Name=districtnumber	Yes	Char	5
L03	District Student ID	The locally assigned student identifier.	[Students]Student_Number	Yes	VarChar	50
L04	State Student ID (SSID)	The identifier assigned to each WA public school student by OSPI. Rule: This field is not required if the student has not yet been assigned an SSID.	[Students]State_studentnumber	Con	Char	10
L05	Ethnicity Code	Indicates if the student is Hispanic or Non-Hispanic and, if Hispanic, which sub-group(s). If Ethnicity Collection Method = 1 or 2, then Race Code is reported. If Ethnicity Collection Method = 3, then Alternate Race Code is reported. If Ethnicity Collection Method is blank, then XX is reported. Refer to the Appendix for valid federal and district ethnicity and race values.	[StudentRace]Racecd 2018-19 school year: [Gen] where cat='Race' [Gen]Value2 (Alternate Race Code) [Gen]Name (Race code)	Yes	Char	2
L06	Ethnicity Collection Method	Indicates the method used to collect the student's selected ethnicity. Valid values: 1 - Ethnicity reported by parent/guardian or the student 2 - Ethnicity not reported by parent/guardian or the student, Observed 3 - Student has not yet been resurveyed (Obsolete as of 2022 - 2023. Replace with 4) 4 - Resurvey request not completed by parent/guardian or the student, mapped from legacy code Note: If for an existing student, the Ethnicity Collection Method is 3, then the report displays 4 instead of 3.	[S_WA_STU_X]EthnicityCollectionMethod	Yes	Char	1