M - Student Race File 2021-2022
Introduction
The Race file includes at least one race record for each student served by the district during the current school year. For students who are multiracial, individual records are submitted; one for each race the student has identified.
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:
- The student's school Entry Date must be on or before the last day of the current school year.
- The student's school Exit Date must be on or after the first day of the current school year.
- The student must not be excluded from state reporting.
- The student must not be excluded from CEDARS reporting.
- 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:
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:
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. Default 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 |
---|---|---|---|---|---|---|
M01 | School Year | The four-digit year in which the school year ends. | [Terms]LastDay | Yes | Char | 4 |
M02 | 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 |
M03 | District Student ID | The locally assigned student identifier. | [Students]Student_Number | Yes | VarChar | 50 |
M04 | 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 |
M05 | Race Code | Indicates the student's selected racial categories. If Race Collection Method = 1 or 2, then Race Code is reported. If Race Collection Method = 3, then Alternate Race Code is reported. If Race Collection Method is blank, then XX is reported. See Appendix for valid federal and district race values.
When race data entry is not entered, the report output will be XX.
| [StudentRace]Racecd 2018-19 school year: [Gen] where cat='Race' [Gen]Value2 (Alternate Race Code) Otherwise: [Gen]Name (Race Code) | Yes | Char | 3 |
M06 | Race Collection Method | Indicates the method used to collect the student's selected racial categories. Valid values:
| [S_WA_STU_X]RaceCollectionMethod | Yes | Char | 1 |