Student Ethnicity File (L) Extract

PATH: WA State Reporting > Ethnicity File (L)

The Student Ethnicity File (L) Extract collects one record for each student served in the district during the current school year along with ethnicity data associated with the student.


Image 1: Student Ethnicity File (L)

Report Logic

Logic reports one record per State Race ethnicity selected for a student.

Generating the Extract

  1. Input the Start and End Date fields by clicking on the field and typing in the date or clicking on the calendar icon and selecting the date.
  2. Select a Format in which the report will generate from the dropdown options. Available formats include: Tab Delimited, CSV, and HTML.
  3. Select the Calendars to include in this report.
  4. Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when the report will generate.

Users have the option of submitting report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. The generated extract is available in the Process Inbox. For more information about submitting a report to the batch queue, see the Batch Queue article. 

Only the header row will report if there are no records reported in the extract.

Image 2: Student Ethnicity File (L) - HTML Example

Report Layout

ElementDescriptionType, Format, and LengthCampus DatabaseCampus Location
School YearThe four digit year in which the current school year ends.Date Field, 4 characters 

YYYY
Calendar.endDateSystem Administration > Calendar > Calendar > End Date
Serving County District CodeThe County-District code for the district providing service to the student. If the Serving School from the enrollment record is null, the State District Number reports.Alphanumeric, 5 characters

Enrollment.
servingDistrict

Student Information > General > Enrollments > General Enrollment Information > Serving District Code

District Student IDThe student identifier assigned by the district to the student.Numeric, 50 digitsPerson.studentNumberCensus > People > Demographics > Person Identifiers > Student Number
SSIDThe student identifier assigned by the state to the student. Numeric, 10 digitsPerson.stateIDCensus > People > Demographics > Person Identifiers > Student State ID
Ethnicity Code

Code distinguishing whether the student is Hispanic or Non-Hispanic and if Hispanic, which Hispanic subgroups. 

Logic reports the code selected in the State Hispanic Ethnicity dropdown list plus adds values from the State Race Ethnicity subgroups list. 

If 'Is the individual Hispanic/Latino?' = N: No, a value of 10 is reported.

Alphanumeric, 3 charactersIdentity.
stateHispanicEthnicity
Census > People > Identities > Identities Editor > Identities Information > Race/Ethnicity > Is the Individual Hispanic/Latino?, State Hispanic Ethnicity
Ethnicity Collection Method

Indicates how the student's ethnicity was reported/collected by the school.

  • 1 – Ethnicity reported by parent, guardian, or student
  • 2 – Observed, Ethnicity not reported by parent/guardian/student
  • 3 – Student has not yet been resurveyed

If Race/Ethnicity Determination - 01, 02, 03, or 04, a value of 3 is reported.

Numeric, 1 characterIdentity.raceEthnicity
Determination
Census > People > Identities > Identities Editor > Identities Information > Race/Ethnicity > Race/Ethnicity Determination