B - District Student File 2020-2021

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.

The All Schools option is only available when running the report from the District Office.

Current Selection Students

Scheduling

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

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

[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

B16

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

B17

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

B18

Student Primary Language Code

The first learned language spoken by the student.

[Students]PrimaryLanguage

Yes

Numeric

3

B19

Language Spoken at Home

[S_WA_STU_X]LanguageAtHome

Yes

Numeric

3

B20

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

B21

Zip Code

The student’s residential zip code plus four.

[Students]Zip

No

VarChar

9

B22

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

B23

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

B24

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

B25

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

B26

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

B27

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

B28

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

B29

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.

[StoredGrades]GPA_Points

[StoredGrades]PotentialCrHrs

[StoredGrades]Grade_Level = 7, 8, 9, 10, 11, or 12

[StoredGrades]StoreCode = S1 or S2

Con

Numeric

4,3

B30

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

B31

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

B32

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

B33

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

B34

Number of Months Non US Attendance in School

The number of months the student received formal education outside the US in his/her 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

B35

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 of the CEDARS Data Manual document for valid values.

[S_WA_STU_X]MilitaryFamilyIndicator

[S_WA_REN_X]MilitaryFamilyIndicator

Yes

Character

1

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 be left blank only when the student has no middle name.

[S_WA_STU_Grad_Req_X]ASVABTestStatus

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.