Skip to main content
Skip table of contents

G - Staff Schedule File 2020-2021

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.

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

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

JavaScript errors detected

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

If this problem persists, please contact our support.