G - Staff Schedule File 2019-2020

Introduction

The Staff Schedule file includes one record for each section or homeroom taught by a staff member during the current school year for grade levels PK–12. Only include courses currently taught during the term effective at the time of submission.

The ability to exclude a course from CEDARS reports is provided in the Staff (F) and Staff Schedule (G) files. It is recommended to use this feature in order to exclude elementary and middle school courses. The field Exclude this course from CEDARS reporting is available on the Courses page. If Yes is selected, all sections/staff for that course are not reported in CEDARS. Staff members who teach different courses are reported as long as those courses are not marked to be excluded.

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.

Staff Selection

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

The term for the section must begin on or after the first day of the selected year.
The term for the section must end on or before the last day of the selected year.
The school where the section is taught must not be excluded from state reporting.
The course associated with the section must not be excluded from state reporting.
Teachers other than the Lead Teacher must be assigned a role which has a Reference Code of "WA" entered on the co-teaching Roles Type page (Start Page > System Administrator > Roles Administration > Co-Teaching Roles)

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.

Item	Data Element	Description	[Table]FieldName	Reqd	Field Type	Length
G01	School Year	The four–digit year in which the school year ends.	[Terms]LastDay	Yes	Char	4
G02	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
G03	Location ID	The Location ID for the school. The school number is reported.	[Schools]School_Number	Yes	VarChar	4
G04	Staff ID	The staff ID assigned by the district.	[SectionTeacher]SectionId [SectionTeacher]TeacherId [Teachers]TeacherNumber	Yes	VarChar	20
G05	Course ID	The unique course number assigned by the district.	[Sections]Course_Number	Yes	VarChar	20
G06	Section ID	The unique section number for an individual class.	[Sections]Section_Number	Yes	VarChar	20
G07	Term	The term during which the section is taught by the teacher.	[Terms]Abbreviation [Sections]Term	Yes	VarChar	12
G08	Instruction Start Date	The date the Teacher began instructing this course, during this term, at this school.	[SectionTeacher]start_date [Terms]FirstDay	Yes	Date	10
G09	Instruction End Date	The date the Teacher stopped instructing this course. If the Teacher remained in the course for the full duration of the term, or if the Teacher is still in this course, NULL should be in this field.	[SectionTeacher]end_date [Terms]LastDay	Con	Date	10
G10	Teacher Indicator	The type of role the teacher is filling in this course. Valid Values: P – Primary A – Alternate T – Team Primary U – Team Alternate V – Team Substitute W – Team – Long Term Substitute S – Substitute L – Long Term Substitute J – Job Share - Primary B – Job Share - Alternate C – Job Share - Substitute D – Job Share – Long Term Substitute I – Special Education Co-Teaching Model E – ELL/ESL Co-Teaching Model F - LAP Co-Teaching Model	[roleproperty]Value (Co-Teaching module Alt Code 1)	Yes	Char	1
G11	Term Start Date	The date the Term for this course/session began. This date may be before the students are in attendance.	[Terms]firstday	Yes	Date	10
G12	Term End Date	The date the Term for this course/session ends.	[Terms]lastday	Yes	Date	10

Back to Top