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
- 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.
- Select a Format in which the report will generate from the dropdown options. Available formats include: Tab Delimited, CSV, and HTML.
- Select the Calendars to include in this report.
- 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
| Element | Description | Type, Format, and Length | Campus Database | Campus Location |
|---|---|---|---|---|
| School Year | The four digit year in which the current school year ends. | Date Field, 4 characters YYYY | Calendar.endDate | System Administration > Calendar > Calendar > End Date |
| Serving County District Code | The 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. | Student Information > General > Enrollments > General Enrollment Information > Serving District Code |
| District Student ID | The student identifier assigned by the district to the student. | Numeric, 50 digits | Person.studentNumber | Census > People > Demographics > Person Identifiers > Student Number |
| SSID | The student identifier assigned by the state to the student. | Numeric, 10 digits | Person.stateID | Census > 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 characters | Identity. 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.
If Race/Ethnicity Determination - 01, 02, 03, or 04, a value of 3 is reported. | Numeric, 1 character | Identity.raceEthnicity Determination | Census > People > Identities > Identities Editor > Identities Information > Race/Ethnicity > Race/Ethnicity Determination |
