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:
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:
If you are running the report for a single student, or a group of students, select the students before running the report.
|
School Year | Choose 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:
| [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 |