Staff Assignments File Layout
The following table shows the CALPADS field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Staff Assigments State file.
NOTE: In the CALPADS Staff Assignment file, there can only be one record per Job Class per building for a staff member, so if a staff member has more than one Job Assignment per Job Class, the FTE values will be totaled.
Field # | Field Name | Required? | eSchoolPlus | eSchoolPlus | Where to Find in eSchoolPlus |
|---|---|---|---|---|---|
8.01 | Record Type Code | Y |
|
| Not found in eSchoolPlus. This will always be SASS for this file. |
8.02 | Transaction Type Code | N |
|
| Not found in eSchoolPlus. This field tells CALPADS if the data being sent is an update, deletion or new record. |
8.03 | Local Record ID | N |
|
| Not being sent in files created in eSchoolPlus. |
8.04 | Reporting LEA | Y | reg_staff_bldgs | building | First 7 characters of State Equivalency Code for the building on the Staff Building record being reported for the staff member. The Building State Equivalency Code is found by going to Administration > Registration Setup > Building > Building Definition > Preferences panel. |
8.05 | School of Assignment | Y | reg_user_staff | page_number = 205 | Administration > Registration Setup > Building > Staff—District-Defined panel > CA Staff Assignments, School of Assignment field. Last 7 characters of State Equivalency Code for the building in the field. |
8.06 | Academic Year ID | Y |
|
| From the School Year prompt on CALPADS extract/download page. |
8.07 | SEID | Y | reg_staff | staff_state_id | Administration > Registration Setup > Building > Staff—Staff State ID field. |
8.08 | Local Staff ID | Y | reg_staff | staff_id | Administration > Registration Setup > Building > Staff—Staff ID field. |
8.09 | Staff Legal First Name | Y | reg_staff | First_Name | Administration > Registration Setup > Building > Staff—First Name field. |
8.10 | Staff Legal Last Name | Y | reg_staff | Last_Name | Administration > Registration Setup > Building > Staff—Last Name field. |
8.11 | Staff Birth Date | Y | reg_staff | birthdate | Administration > Registration Setup > Building > Staff—Birth Date field. |
8.12 | Staff Gender Code | Y | reg_staff | gender | Administration > Registration Setup > Building > Staff—Gender field. |
8.13 | Staff Job Classification Code | Y | reg_user_staff | page_number = 205; field_number = 2 | Administration > Registration Setup > Building > Staff—District-Defined panel > CA Staff Assignments, Job Class field. |
8.14 | Staff Job Classification FTE Percentage | Y | reg_user_staff | page_number = 205 ; field_number = 3 | Administration > Registration Setup > Building > Staff—District-Defined panel > CA Staff Assignments, FTE field |
8.15 | Non Classroom Based Job Assignment Code 1 | If Staff Job Classification Code = 10 or 11 Then Y; Else N | reg_user_staff | page_number = 205; field_number = 4 | Administration > Registration Setup > Building > Staff—District-Defined panel > CA Staff Assignments, Job Assignment field |
8.16 | Non Classroom Based Job Assignment Code 2 | N | reg_user_staff | page_number = 205 | Administration > Registration Setup > Building > Staff—District-Defined panel > CA Staff Assignments, Job Assignment field |
8.17 | Non Classroom Based Job Assignment Code 3 | N | reg_user_staff | page_number = 205 | Administration > Registration Setup > Building > Staff—District-Defined panel > CA Staff Assignments, Job Assignment field |
8.18 | Non Classroom Based Job Assignment Code 4 | N | reg_user_staff | page_number = 205 | Administration > Registration Setup > Building > Staff—District-Defined panel > CA Staff Assignments, Job Assignment field |
8.19 | Non Classroom Based Job Assignment Code 5 | N | reg_user_staff | page_number = 205 | Administration > Registration Setup > Building > Staff—District-Defined panel > CA Staff Assignments, Job Assignment field |
8.20 | Non Classroom Based Job Assignment Code 6 | N | reg_user_staff | page_number = 205 | Administration > Registration Setup > Building > Staff—District-Defined panel > CA Staff Assignments, Job Assignment field |
8.21 | Non Classroom Based Job Assignment Code 7 | N | reg_user_staff | page_number = 205 | Administration > Registration Setup > Building > Staff—District-Defined panel > CA Staff Assignments, Job Assignment field |
| Sequence_id | Y | Derived field { concatenate 8.05 + Staff_id + Assignment 1(if exists)) |
| Not seen in eSchoolPlus. We will calculate this field by adding the value of field 8.05, Staff ID and field 8.15 (if it exists). |