STAFF DEMOGRAPHICS

 

The Staff page can be accessed on the navigation tree under School Info. There are multiple tabs for the Staff Data page.




Aeries Field Name
Aeries Table.Field
CALPAD
S FldNum
CALPADS Name

Comment

Staff ID
STF.ID
07.09
Local Staff ID
This should be the ID used in your district's HR system.
Last Name
STF.LN
07.12
Staff Legal Last Name

First Name
STF.FN
07.10
Staff Legal First Name

Middle Name
STF.MN
07.11
Staff Legal Middle Name

Sex
STF.SX
07.17
Staff Gender Code

Birth Date
STF.BD
07.16
Staff Birth Date

Hire Date
STF.HD
07.28
Staff Employment Start Date
This should be the start of the most recent employment for this employee.
Leave Date
STF.LD
07.29
Staff Employment End Date
Any record with a Leave Date before July 1st of the current school year will not be extracted.
Education Level
STF.EL
07.26
Staff Highest Degree Code
CALPADS Code Set: Degree
Ethnicity
STF.ETH
07.18
Staff Hispanic Ethnicity Indicator
We recommend creating an additional code for "Declined to State/Unknown". This code, along with blank values will be translated to a value in the "Missing Indicator" field when extracted to CALPADS.
Ethnicity
STF.ETH
07.19
Staff Ethnicity Missing Indicator
Race 1 – 5
STF.RC1 - STF.RC5
07.20 – 07.24
Staff Race 1 Code
– Staff Race 5 Code
We recommend creating an additional code for "Declined to State/Unknown". This code, along with blank values will be translated to a value in the "Missing Indicator" field when extracted to CALPADS.

STF.RC#
07.25
Staff Race Missing Indicator
Position Status
STF.PS
07.27
Staff Employment Status Code
CALPADS Code Set: Employment Status Category. Must be populated in order for SDEM and SASS records to be extracted.
Total Years in This District
STF.TYD
07.30
Staff Service Years LEA
On the Staff page an Update Totals button is available: Staff Update Years
Total Years of Education Service
STF.TYS
07.31
Staff Service Years Total
On the Staff page an Update Totals button is available: Staff Update Years
Previous Last Name
STF.LNP
07.15
Staff Alias Last Name

Previous First Name
STF.FNP
07.13
Staff Alias First Name

Previous Middle Name
STF.MNP
07.14
Staff Alias Middle Name

State Educator ID
STF.SID
07.08
SEID
Must be populated in order for SDEM and SASS records to be extracted.


To access Staff Job Assignments, click the mouse Job Assignments tab on the Staff form.



Aeries Field Name
Aeries Table.Field

CALPADS

FldNum

CALPADS Name

Comment

Job Classification
STJ.JC
08.13
Staff Job Classification Code
CALPADS Code Set: Educational Service Job Classification. Must be populated in order for SDEM and SASS records to be extracted.
10 – Administrator 11 – Pupil Services 12 – Teacher
25 – Non-Certificated Administrator 27 – Itinerant Teacher
FTE
STJ.FTE
08.14
Staff Job Classification FTE Percentage
The percentage of time spent on each job classification in relation to a full- time position (100%).
Non Classroom Based Job Assignment Code 1 – Code 7
STJ.NC1 STJ.NC2 STJ.NC3 STJ.NC4 STJ.NC5 STJ.NC6 STJ.NC7
08.15
08.16
08.17
08.18
08.19
08.20
08.21
Non Classroom Based Job Assignment Code 1 – Code 7
CALPADS Code Set: Non Classroom Based or Support Assignment. If Staff Job Classification Code = 10 – Administrator or 11 – Pupil Services, Then one or more of the Non Classroom Based Job Assignment Codes must be populated
Staff Job Assignment Start and End Date
STJ.SD STJ.ED


The SDEM and SASS files will evaluate the date fields if populated. If not populated, record is considered as “current” if fields are blank.