Skip to main content
Skip table of contents

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:

  • 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 the selection criteria.

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 YearChoose 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]
PSCore_Legal_Last_Name

[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]
PSCore_Legal_First_Name

[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]
PSCore_Legal_Middle_Name

[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.

  • If the student's grade level is less than 0, then PK is reported.
  • If the student's grade level is 0, then the report references the Kindergarten Program field and reports either K1 or K2.
  • If the Student, Reenrollment, and School fields are blank, the grade level defaults to K2.

[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
if [Students]ExitCode (Not Blank)

[ReEnrollments]ExitDate
if [ReEnrollments]ExitCode (Not Blank)

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]
WA_GradRequirementsYear

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]
Expected_Grad_Year

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:

  • Grade level 7 or higher.
  • Store code S1 or S2.

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:

  • Grade level 7 or higher.
  • Store code S1 or S2.

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:

  • Grade level 7 or higher.
  • Store code S1 or S2.
  • Potential credit greater than 0.

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
USASch

[S_WA_REN_X]NumMonthsNon
USASch

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

B35Preferred 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_nameYesVarChar60
B36Preferred 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_nameConVarChar60
B37Preferred 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_NameConVarChar60
B38ASVAB Test StatusIndicates 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

ConString1
B39ASVAB Test ScoreThe ASVAB test scores the student received.[S_WA_STU_Grad_Req_X]ASVABTestScoreConString3
B40ASVAB Administration YearThe school year that the student took the ASVAB.[S_WA_STU_Grad_Req_X]ASVABTestYearConString4
B41Credit 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]CreditWaiverConString1
B43Language(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]PreferredLanguageYesString40
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.