Skip to main content
Skip table of contents

B - District Student File 2019-2020

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

Note: 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.

Note: If running the report for a single student, or group of students, select the students prior to running report.

School YearChoose the year for which to run the report.

Scheduling

Default is Run Now. Select Schedule to run the report on a specific date and time.

Back to Top

Report Output

Note: 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 are 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 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 if the student identified as an Immigrant (yes) 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.

Notes:

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

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

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

Note: This element is required beginning in the 2012-2013 school year.

[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 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 school 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 F–1 Visas 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, reported in the format 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())

Review additional information about weighted GPA calculation.

This field is required for students in grade levels 9 – 12.

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

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

[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

No longer an Active Data Element.

Formerly Number of Months US Attendance in School

This element is no longer collected through CEDARS.

Deprecated as of 2014-2015.

N/A

N/A

N/A


B34

Number of Months Non US Attendance in School

Number of months the student received formal education outside the US in his/her native language (equivalent to grades K–12) prior to enrolling in this district.

[S_WA_STU_X]NumMonthsNon
USASch

[S_WA_REN_X]NumMonthsNon
USASch

Con

Numeric

3

B35

Military Parent or Guardian

Indicates whether or not the students 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 of the CEDARS Data Manual document for valid values.

[S_WA_STU_X]MilitaryFamilyIndicator

[S_WA_REN_X]MilitaryFamilyIndicator

Yes

Character

1

B36Preferred 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
B37Preferred First Name
May be left blank only when student has no 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.
[Students]First_nameConVarChar60
B38Preferred 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.

Note: May be left blank only when student has no middle name.

[Students]Middle_NameCon VarChar 60

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.