B - District Student File 2023-2024
Introduction
The District Student file includes one record for each student enrollment in the district during the current school year. If a student has multiple school enrollments in the district during the school year or if the student changes grade level mid-year, then multiple records are submitted for that student. Each record includes basic student demographic data. Entry and exit dates may not overlap for individual students.
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] and [ReEnrollments] tables based on the following criteria:
- 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. The default selection is "Run Now." |
Report Output
If the student changes grades mid-year, a distinct student record is created for each grade level that the student spends time in during the school year (no-show records are excluded).
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 |
---|---|---|---|---|---|---|
B01 | School Year | The four-digit year in which the current school year ends. | [Terms]LastDay Determined by the School Year report selection parameter. | Yes | Char | 4 |
B02 | Serving County District Code | The serving county district code for the district submitting the data. Use leading zeroes where necessary. | [Prefs]Value [Prefs]Name=districtnumber | Yes | Char | 5 |
B03 | Home County District Code | The county district code where the student physically resides. Rule: If this field is blank, the value from B02 is reported. | [Students]CountyofRes | Yes | Char | 5 |
B04 | District Student ID | The student identifier assigned by the district to the student. | [Students]Student_Number | Yes | VarChar | 50 |
B05 | State Student ID (SSID) | The identifier that is 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 |
B06 | Last Name | The student's legal last name. | [StudentCoreFields] [Students]Last_Name | Yes | VarChar | 60 |
B07 | First Name | The student's legal first name. Rule: This field is not required if the student has no first name. | [StudentCoreFields] [Students]First_Name | Con | VarChar | 60 |
B08 | Middle Name | The student's legal middle name. Rule: This field is not required if the student has no middle name. | [StudentCoreFields] [Students]Middle_Name | Con | VarChar | 60 |
B09 | Birth Date | The student's date of birth. | [Students]DOB | Yes | Date | 10 |
B10 | Birth Country | The country where the student was born. This element is intended to collect the physical location of the student's birth. It is not intended to collect information related to citizenship. Rule: This field is required for students identified as "Immigrant" in element B31. | [S_WA_STU_X]BirthCountry | Yes | Char | 3 |
B11 | No Longer An Active Data Element. Formerly CSRS Ethnicity Code. | Beginning with the 2011–2012 school year, all Ethnicity and Race information for students must be reported within Element L05 – Ethnicity Code and Element M05 – Race Code. This position in the extract is now filler (null). | N/A | N/A | N/A | 1 |
B12 | Gender | The student's gender. | [StudentCoreFields]PSCore_Legal_Gender [Students]Gender | Yes | Char | 1 |
B13 | Grade Level | The grade level in which the student is enrolled.
| [Students]Grade_Level [ReEnrollments]Grade_Level [S_WA_STU_X]KinderEnrollment [S_WA_REN_X]KinderEnrollment [S_WA_SCH_X]KinderEnrollment | Yes | VarChar | 2 |
B14 | District Enrollment Date | The date on which the student began school in the district. Rule: The Annual Measurable Objectives (AMO) half-year enrollment requirement is calculated using Element B14 and Element B15 – Date Exited from District. | [Students]DistrictEntryDate [S_WA_REN_X]DistrictEntryDate | Yes | Date | 10 |
B15 | District Exit Date | The date the student withdrew from the district. This field is reported when the student's current enrollment (Students table) exit code is not blank. or The student's previous enrollment exit code is not T1. or The student's previous enrollment exit code is T1, and the T1 exit represents a grade level change. Rule: This field must match data element C08 (School Exit Date) for the school that the student last attended. The enrollment date must be on or after Element B09 – Birth Date and can be no more than six months greater than the date on which the file is being submitted. The Annual Measurable Objectives (AMO) half-year enrollment requirement is calculated using Element B14 and Element B15 – Date Exited from District. | [Students]ExitDate [ReEnrollments]ExitDate | Con | Date | 10 |
B16 | Disability Code | Beginning with the 2014–15 school year Disability Code will be reported in Student Programs and Attributes File (I). This position in the extract is now filler (null). | N/A | N/A | N/A | |
B17 | Student Primary Language Code | The first learned language spoken by the student. | [Students]PrimaryLanguage | Yes | Numeric | 3 |
B18 | Language Spoken at Home | The primary language the student speaks at home. This language may change over time. | [S_WA_STU_X]LanguageAtHome | Yes | Numeric | 3 |
B19 | No longer an Active Data Element. Formerly SSN | This data element is no longer used in CEDARS. Deprecated as of 2017-2018. This position in the extract is now filler (null). | N/A | N/A | N/A | 9 |
B20 | Zip Code | The student's residential zip code plus four. | [Students]Zip | No | VarChar | 9 |
B21 | Is Student Homeless? | Indicates whether or not the student was homeless at any time during the current school year as defined in the McKinney–Vento Act, Section 725(2). Default value: N – Student has not been identified as homeless | [S_WA_STU_X]PriNighttimeRes | Yes | Char | 1 |
B22 | Is Student an Approved Private School Student Attending Class Part-Time? | Indicates whether the student is enrolled in an approved private school and is attending class part-time and the amount of claimed Alternative Learning Experience FTE. Default value: 0 – No | [S_WA_STU_X]PrivateSchoolPartTime | Yes | Char | 1 |
B23 | Is Student a Home-Schooled Student Attending Class Part-Time? | Indicates whether the student is a home-schooled student attending class part-time and the amount of claimed Alternative Learning Experience FTE. Default value: 0 – No | [S_WA_STU_X]HomeBasedPartTime | Yes | Char | 1 |
B24 | Student Exchange Status | Indicates whether a student is enrolled in your schoirol as a J-1 Foreign Exchange student or is enrolled with an F-1 Visa. Rule: J-1 VISA students are in a program that 'exchanges' a student from our country with a student from another country. As a result, foreign exchange students are regarded as 'regular' students in the district and generate apportionment for the district like any other resident student. Students on an F–1 Visa do not generate apportionment because someone is paying tuition to the district to enable their enrollment. Default value: N – No | [S_WA_STU_X]ForeignExchange | Yes | Char | 1 |
B25 | No Longer An Active Data Element. Formerly Is Student In Foster Care? | This data element is no longer collected through CEDARS. This position in the extract is now filler (null). | N/A | N/A | N/A | |
B26 | Graduation Requirements Year | The year the student is held accountable for meeting the requirements of graduation, reported in the format YYYY. This field is required for students in grade levels 9 – 12. | [S_WA_STU_Grad_Req_X] | Con | Char | 4 |
B27 | Expected Year of Graduation | The year the student is expected to graduate, reported in the format YYYY. This field is required for students in grade levels 9 – 12. | [S_WA_STU_Grad_Req_X] | Con | Char | 4 |
B28 | Cumulative Grade Point Average | The student's cumulative grade point average (GPA), as reported on the state standardized transcript, formatted as 0.00 to 9999.99. The report averages historical grades that are associated with:
The report uses the default PowerSchool Weighted GPA formula to calculate the GPA: round((gpa_sum(gpa_gpapoints()*gpa_potentialcredit())/sum(gpa_potentialcredit()) This field is required for students in grade levels 9 – 12. This field will now calculate and display values from all the available store codes for a student if the value of the Store Codes to be used in the CEDARS B file field is null at the school info page. | [StoredGrades]GPA_Points [StoredGrades]PotentialCrHrs [StoredGrades]Grade_Level = 7, 8, 9, 10, 11, or 12 [StoredGrades]StoreCode = S1 or S2 | Con | Numeric | 4,3 |
B29 | Credits Attempted | The cumulative number of credits the student attempted for courses that qualify for high school credit, reported in the format 0.00 to 9999.99. The report sums the potential credit hours for historical grades that are associated with:
This field is required for all credits attempted by the student for courses earning high school credit. This field will now calculate and display values from all the available store codes for a student if the value of the Store Codes to be used in the CEDARS B file field is null at the school info page. | [StoredGrades]PotentialCrHrs [StoredGrades]Grade_Level >= 7 [StoredGrades]StoreCode = S1 or S2 | Con | Numeric | 6,2 |
B30 | Credits Earned | The cumulative number of credits the student earned from courses that qualify for high school credit, reported in the format 0.00 to 9999.99. The report sums the earned credit hours for historical grades that are associated with:
This field is required for all credits earned by the student for courses earning high school credit. This field will now calculate and display values from all the available store codes for a student if the value of the Store Codes to be used in the CEDARS B file field is null at the school info page. | [StoredGrades]EarnedCrHrs [StoredGrades]Grade_Level >= 7 [StoredGrades]StoreCode = S1 or S2 [StoredGrades]PotentialCrHrs > 0 | Con | Numeric | 6,2 |
B31 | Is Student Identified as Immigrant? | This data element is no longer collected through CEDARS. Deprecated as of 2014-2015. | N/A | N/A | N/A | |
B32 | Initial USA Public School Enrollment | The date the student first enrolled in education anywhere in the United States in grade K or higher, excluding education in Department of Defense or Embassy schools. Reported in the format MM/DD/YYYY. | [S_WA_STU_X]InitialUSAEnrollment | Con | Date | 10 |
B33 | Number of Months Non US Attendance in School | The number of months the student received formal education outside the US in their native language (equivalent to grades K–12) before enrolling in this district. | [S_WA_STU_X]NumMonthsNon [S_WA_REN_X]NumMonthsNon | Con | Numeric | 3 |
B34 | Military Parent or Guardian | Indicates whether or not the student's parent or guardian is currently in the military as required by RCW 28A.300.505(2)(b) and further defined in Substitute Senate Bill 5163. See the CEDARS Data Manual document for valid values. | [S_WA_STU_X]MilitaryFamilyIndicator [S_WA_REN_X]MilitaryFamilyIndicator | Yes | Character | 1 |
B35 | Preferred Last Name | The preferred last name of the student. If the student's preferred last name is their legal last name, Element B36 and Element B06 – Legal Last Name should contain the same last name. | [Students]Last_name | Yes | VarChar | 60 |
B36 | Preferred First Name | The preferred first name of the student. If the student's preferred first name is their legal first name, Element B37 and Element B07 – Legal First Name should contain the same first name. May only be left blank only when the student has no first name. | [Students]First_name | Con | VarChar | 60 |
B37 | Preferred Middle Name(s) | The preferred middle name of the student. If the student's preferred middle name is their legal middle name, Element B37 and Element B08 – Legal Middle Name should contain the same last name. May only be left blank when the student has no middle name. | [Students]Middle_Name | Con | VarChar | 60 |
B38 | ASVAB Test Status | Indicates if the Armed Services Vocational Aptitude Battery (ASVAB) test is available for the student. If the student has taken the test, it also indicates if they are or are not eligible based on the minimum score identified by the State Board of Education - https://www.sbe.wa.gov/our-work/graduation-pathwayoptions. | [S_WA_STU_Grad_Req_X]ASVABTestStatus | Con | String | 1 |
B39 | ASVAB Test Score | The ASVAB test scores the student received. | [S_WA_STU_Grad_Req_X]ASVABTestScore | Con | String | 3 |
B40 | ASVAB Administration Year | The school year that the student took the ASVAB. | [S_WA_STU_Grad_Req_X]ASVABTestYear | Con | String | 4 |
B41 | Credit Waiver | This element indicates whether or not a student has been authorized, under district policy, to waive up to 2 credits due to the student's individual circumstances. This element only indicates eligibility and not use of the credit waiver as outlined in HB 1599. Defaults to 0 - 'Student not authorized' for students in grades 9-12. | [S_WA_STU_Grad_Req_X]CreditWaiver | Con | String | 1 |
B43 | Language(s) Family Prefers to Communicate In | The languages in which the parent/guardian prefers to communicate. If multiple languages have been selected during the student setup, then the codes associated with the select languages are displayed separated by a comma. Refer to Appendix K of the CEDARS Appendices 23 - 24 document for the complete list of available languages. http://www.k12.wa.us/CEDARS/Manuals.aspx. | [S_WA_STU_Grad_Req_X]PreferredLanguage | Yes | String | 40 |