F - Staff File 2020-2021
Introduction
The Staff file includes one record for each staff member teaching a course or assigned to a homeroom for the current school year in grade levels PK–12. There should be one record for each teaching staff member per district. If a staff member serves more than one school, then that information is captured in the Staff Schedule File G.
The ability to exclude a course from CEDARS reports is provided in the Staff (F) and Staff Schedule (G) files. 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 Member Selection
The report selects records from the [Users] tables based on the following criteria:
- The staff member must teach a section during the current school year.
- The section must be taught at a school that is not excluded from state reporting.
- The course associated with the section 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:
The All Schools option is only available when running the report from the District Office. |
Current Selection Staff | Select which staff members to include in the report:
If you are running the report for a single staff member, or a group of staff members, select the staff members 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 |
---|---|---|---|---|---|---|
F01 | School Year | The four-digit year in which the school year ends. | [Terms]LastDay | Yes | Char | 4 |
F02 | 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 |
F03 | Staff ID | The staff ID assigned by the district. | [Users]TeacherNumber | Yes | VarChar | 20 |
F04 | Staff Type Code | The type of staff member. | [S_WA_SSF_X]StaffTypeCode | Yes | VarChar | 8 |
F05 | Certification Number | The staff member's State Certification Number. Rule: Must be a valid WA State Certification number, a Z number, or a temporary permit. This value must be reported for all educators who teach classes issuing Washington State Credit. | [S_WA_USR_X]TeacherCredentialID | Con | Char | 7 |
F06 | Legal Last Name | The staff member's last name, as maintained by the district or as listed on the certification record. Rule: Report this value if data element F05 is not equal to UNK. | [Users]Last_Name | Yes | VarChar | 60 |
F07 | Legal First Name | The staff member's first name, as maintained by the district or as listed on the certification record. Rule: Report this value if the staff member has a first name and data element F05 is not equal to UNK. | [Users]First_Name | Con | VarChar | 60 |
F08 | Legal Middle Name | The staff member's middle name, as maintained by the district, or as listed on the certification record. Rule: May be left blank only when the staff member has no middle name. | [Users]Middle_Name | Con | VarChar | 60 |
F09 | Birth Date | The staff member's date of birth; reported in the format MM/DD/YYYY. | [UsersCoreFields]DOB | Yes | Date | 10 |