STAFF DEMOGRAPHICS
The Staff page can be accessed on the navigation tree under School Info. There are several collapsible menus for the Staff Data page.
| Aeries Field Name | Aeries Table.Field | CALPADS 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 Last Name | |
| First Name | STF.FN | 07.10 | Staff First Name | |
| Middle Name | STF.MN | 07.11 | Staff Middle Name | |
| Sex | STF.GN | 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, SASS and CRSE 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, SASS and CRSE 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, SASS and CRSE 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. |