Report 4.4: Staff Profile - List

(Updated as of 01/14/2022)

Description:Reports demographics, employment status, and FTE by job classification for each SEID active as of Fall 2 Report Period.

Security Roles: Fall 2 Reports

Data As Of:

  • If ODS version, user defined

  • If Snapshot version, Census Day (First Wednesday in October)


Basic selection criteria:

  • SEID: Element 8.07 (SEID) must exist in CTC SEID table

  • Staff Demographics (SDEM) data are selected from the most recent SDEM record with:

    • Effective Start Date on or before Census Day of the reporting year and Record Effective End Date (if exists) on or after Census Day and
    • Employment Start Date on or before Census Day of the reporting year and Employment End Date (if exists) after Census Day
  • Not included are staff where SASS Field 8.15 – 8.21 - Support Assignment Codes equal to 6018 (Employee on Leave)

Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed

  • Academic Year
  • LEA
  • Status – (Snapshot)
  • School Type
  • School
  • Gender
  • Ethnicity/Race
  • Local ID
  • SEID
  • Non-Classroom Based Job Assignment
  • Employment Status
  • Job Classifications
  • User Comments


Report Logic


Report 4.4:  Staff Profile - List

Column Rules
1 School code is derived from user ID permission and Expected Schools table
2 School Name is determined by #1 and the Expected Schools Table
3 SASS Field 8.07 SEID
4 SDEM Field 7.12 – Staff Legal Last Name and SDEM Field 7.10 – Staff Legal First Name and SDEM Field 7.11 Staff Legal Middle Name
5 SASS Field 8.08 - Local Staff ID
6 SDEM Field 7.17 – Staff Gender Code
7 SDEM Field 7.16 – Staff Birth Date
8 Ethnicity/Race used from SDEM and derived using the Ethnicity/Race (Federal Definition) business rules
9 SDEM Field 7.26 – Staff Highest Degree Code
10 SDEM Field 7.28 – Staff Employment Start Date
11 SDEM Field 7.29 – Staff Employment End Date
12 SDEM Field 7.27 - Employment Status
13 SDEM Field 7.30 – Staff Years in LEA
14 SDEM Field 7.31 – Staff Total Years of Service
15 SASS Field 8.14 - Staff Job Classification FTE Percentage if SASS Field 8.13 – Staff Job Classification Code = 12 (Teacher)
16 SASS Field 8.14 - Staff Job Classification FTE Percentage if SASS Field 8.13 – Staff Job Classification Code = 10 (Administrator)
17 SASS Field 8.14 - Staff Job Classification FTE Percentage if SASS Field 8.13 – Staff Job Classification Code = 11 (Pupil Services)
18 SASS Field 8.14 - Staff Job Classification FTE Percentage if SASS Field 8.13 – Staff Job Classification Code = 26 (Charter School Non-certificated Teacher)
19 SASS Field 8.14 - Staff Job Classification FTE Percentage if SASS Field 8.13 – Staff Job Classification Code = 25 (Non-certificated Administrator)
20 SASS Field 8.14 - Staff Job Classification FTE Percentage if SASS Field 8.13 – Staff Job Classification Code = 27 (Itinerant or Pull-out/Push-In Teacher)

Glossary References:

Full Time Equivalent