Skip to main content
Skip table of contents

F - Staff File 2019-2020

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:

  • 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 Staff

Select which staff members to include in the report:

  • The Selected [Number] Staff Only – Run the report for staff in the current selection.
  • All Staff – Run the report for all staff in the current school or district that meet the selection criteria.

Note: If running the report for a single staff member, or group of staff members, select the staff members prior to running report.

School YearChoose 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

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.
This field is required if F05 is UNK (Unknown).

[UsersCoreFields]DOB

Yes

Date

10

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.