Skip to main content
Skip table of contents

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
Table

eSchoolPlus
Column

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
field_number = 1

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).

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.