Staff File (F)
The following table shows the CEDARS field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Staff File (F) State file.
Field # | Field Name | Required? | eSchoolPlus Table | eSchoolPlus Column | Where to find data in eSchoolPlus |
|---|---|---|---|---|---|
F01 | School Year | Yes | prompts | School Year | From the School Year prompt on page |
F02 | Serving County District Code | Yes | reg_district | state_code_equiv | Administration > General Setup > District > District (cannot be updated through the software) |
F03 | Staff ID | Yes | reg_staff | staff_id | Administration > Registration Setup > Building > Staff: Staff ID field |
F04 | Type Code | Yes | reg_staff_user | field_values where screen_number='420' and field_numbers='1' & '2' | Administration > Registration Setup > Building > Staff > District-Defined panel > WA Staff Information page: Type Code and Certify Type fields |
F05 | Staff Certification Number | Conditional. Requires the State Certification number assigned to this staff member’s certificate. | reg_staff | state_id | Administration > Registration Setup > Building > Staff: Staff State ID field |
F06 | Staff Last Name | Yes | reg_staff | last_name | Administration > Registration Setup > Building > Staff: Last Name field |
F07 | Staff First Name | Conditional. Requires the legal middle name of the staff member as maintained by the district or the name listed on the State Certification. May be left blank only when the staff member has no middle name. | reg_staff | first_name | Administration > Registration Setup > Building > Staff: First Name field |
F08 | Staff Middle Name | Conditional. Requires the legal middle name of the staff member as maintained by the district or the name listed on the State Certification. May be left blank only when the staff member has no middle name. | reg_staff | middle_name | Administration > Registration Setup > Building > Staff: Middle Name field |
F09 | Birth Date | Yes | reg_staff | birthdate | Administration > Registration Setup > Building > Staff: Birth Date field |