E - Student Schedule File 2019-2020

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

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.

Note: 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
E10	Approved Online Provider	Identifies the online provider offering the course reported in Element E06 – Course ID.	[S_WA_CRS_X]ApprovedOnlineProvider [S_WA_SEC_X]ApprovedOnlineProvider	Con	VarChar	2
E11	Approved Online Program	Identifies the online program offering the course reported in Element E06 – Course ID.	[S_WA_CRS_X]ApprovedOnlineProgram [S_WA_SEC_X]ApprovedOnlineProgram	Con	VarChar	3
E12	Letter Grade	The letter grade awarded for the course.	[StoredGrades]Grade	Yes	VarChar	2
E13	Credits 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
E14	Credits 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

Back to Top