Skip to main content
Skip table of contents

E - Student Schedule File 2023-2024

Introduction

The Student Schedule file includes one record for each course enrollment for students in grade levels PK-12. All courses scheduled for the student during the current school year are included in the extract.

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 course enrollment for students who meet the following criteria:

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

Course Enrollment Selection

The report selects records from the [CC] tables based on the following criteria:

  • The student's course Entry Date must be on or before the last day of the current school year.
  • The student's course Exit Date must be on or after the first day of the current school year.
  • The course must be taught at a school that is not excluded from state reporting.
  • The course 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 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

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.

The records are ordered by student number.

Item

Data Element

Description

[Table]FieldName

Reqd

Field Type

Length

E01

School Year

The four-digit year in which the school year ends.

[Terms]LastDay

Yes

Char

4

E02

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

E03

District Student ID

The locally assigned student identifier.

[Students]Student_Number

Yes

VarChar

50

E04

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

E05

Location ID

The Location ID for the school. The school number is reported.

[Schools]School_Number

Yes

VarChar

4

E06

Course ID

The course ID used by the district or school to represent the unique course number.

[Courses]Course_Number

Yes

VarChar

20

E07

Section ID

Section number used for the identification of a unique occurrence of a class/staff/location. The section ID is intended to uniquely identify each class/period of students that occur. It is not intended to broadly identify a course(s) offered.

[Sections]Section_Number

Yes

VarChar

20

E08

Term

The term during which the course is taken by the student.

[Terms]Abbreviation

Yes

VarChar

12

E09

ALE Course Type

Identifies how the instruction for the course reported in Element E06 – Course ID was provided.

Valid Values:

  • N – No, Course was not taught through ALE
  • O – Online
  • R – Remote
  • T – Site-Based – written student learning plan requires regular weekly in-person instructional contact time
  • U – Site-Based –written student learning plan requires less than weekly in-person instructional contact time

[S_WA_CRS_X]ALEFunded

[S_WA_SEC_X]ALEFunded

Yes

VarChar

1

E10Approved Online ProviderIdentifies the online provider offering the course reported in Element E06 – Course ID.

[S_WA_CRS_X]ApprovedOnlineProvider

[S_WA_SEC_X]ApprovedOnlineProvider

ConVarChar2
E11Approved Online ProgramIdentifies the online program offering the course reported in Element E06 – Course ID.

[S_WA_CRS_X]ApprovedOnlineProgram

[S_WA_SEC_X]ApprovedOnlineProgram

ConVarChar3
E12Letter Grade

The letter grade awarded for the course.

[StoredGrades]Grade

Yes

VarChar

2

E13Credits Attempted

The number of credits the student could have earned for the course.

Valid range: 00.00 to 99.99

[StoredGrades]PotentialCrHrs

Yes

Numeric

4,2

E14Credits Earned

The number of credits awarded to the student upon completion of the course.

Valid range: 00.00 to 99.99

[StoredGrades]EarnedCrHrs

Yes

Numeric

4,2

E15Industry Recognized Certifications Earned

Indicates which, if any, state or nationally industry-recognized certification(s) a student earned as a result of taking the CTE course when recognized industry certifications are available for that CTE course as identified in Element D17 – Industry Recognized Certifications Offered.

Defaults to "1 - No Industry Certification Offered" for CTE course enrollments where the CTE Course does not offer a certification (CEDARS D17 = 1).

Default to "2 - No Industry Certification Earned" for CTE course enrollments where the CTE Course offers a certification, but one was not earned by the student.

Refer to Appendix AK of the CEDARS Appendices 23 - 24 document for the complete list of certifications available. http://www.k12.wa.us/CEDARS/Manuals.aspx.

[S_WA_CC_X]IndustryCertEarnedCondVarchar40
E16Student Work-Based Learning Activities

The work-based learning (WBL) activities a student participated in as a result of taking the CTE Course are reported in Element D10 – Classification of Instructional Program (CIP) Code Number. All CTE courses have the expectation that WBL activities are embedded in the curriculum.

Rules: This field is required when the corresponding course record Element D10 –Classification of Instructional Program (CIP) Code Number is not null, else optional. This field will default to 10 if the 'corresponding course record Element D10 – Classification of Instructional Program (CIP) Code Number is not null' and the cc field is null.


CEDARS considers a course record between File D and File E to be corresponding when:

• D01 and E01 have the same school year

AND

• D02 and E02 have the same Serving County District Code

AND

• D03 and E05 have the same Location ID

AND

• D04 and E06 have the same course Course ID

Note: More than one valid value may be used (separated by a comma) to identify all of the WBL the student participated in for this CTE course. If E16 is 10, no other valid value may be used.

[S_WA_CC_X]StudentWorkBasedLearningActivitiesCondVarchar40
JavaScript errors detected

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

If this problem persists, please contact our support.