How do I manage CALPADS Fall 2 data in Illuminate? (Step 2 of 3 – Staff)

Complete Staff Data Entry within Illuminate

By now, you should have a list of all of the staff members that are to be reported through CALPADS. If not, please return to the article in Step 1 here. If so, let’s continue!

Staff Fall 2 data can be broadly categorized into two types:

  1. Core Staff Demographics (All staff)
    • Staff Ethnicity/Race (All staff)
  2. Staff Assignments (All staff)

Staff  Demographics and Ethnicity/Race

Staff Step 1: Core Staff Demographics fields must be completed for all staff members and include the following that are reported to CALPADS:

  • Legal Name(s), Date of Birth, Gender
  • State ID (SEID for certificated staff members):
    • This number is issued by the CTC (  Each school should have access to the database that will allow the school to lookup the SEID number using the staff member’s Social Security Number.  The web address to lookup this number is and you can request a User ID and Password by sending an e-mail to the CTC Information Services Unit at
    • If the staff member is not certificated, but is filling a position that requires a certificate, the SEID number 9999999999 may be used in order to report the staff member as a teacher on the course and section enrollment reports (CRSE and SCSE).
  • Federal Ethnicity (Hispanic / Not Hispanic indicator)
  • Race Code(s)
  • Highest Degree Code (Staff Education Level)
  • Employment Status (Position Status) and Hire Date
    • End of employment date is also required for any staff member who has left and was reported to CALPADS in the past year.
  • Total Years of Service in the LEA/District and Total Years of Educational Service – Update annually.

Staff Step 1a: To update this required information one staff record at a time, navigate to the User Management Screen and select the staff record that requires updates by selecting the “Actions” button and “Edit User”.

Staff step 1b:  Select “Additional Information” and enter the required fields as shown in the screenshot below.

CALPADS Job Classifications (All Staff) and Staff Assignments (Admin and Pupil Services Only)

Within the staff record in Illuminate, there is an additional screen specifically for a CALPADS staff assignments and Job Classifications.

*Note: Credentials for 2016-17 are no longer required by CALPADS to properly report the course section enrollments.

Staff Step 2a:  Job Classification screen (ALL STAFF)

  • Job Classifications for the staff member:
    • Required for each role the staff member fills
      • Options include: Administrator, Pupil Services, Teacher, Non-certificated Administrator, Charter School Non-certificated Teacher or Itinerant Teacher
  • Site Affiliation:
    • Required for proper Illuminate reporting
  • Full Time Equivalency (FTE) for the Job Classification (Ex. 100, 80, or 20%)
  • Start Date: Required if staff member is new or a new role has been added to an established staff record.
    • CALPADS allows for open, continuous records and expects the records to be closed only if the job classification has changed or employment has ended.
      • For example:  A Non-Certificated Teacher at a charter school  (Code 26) earns a full CA Credential, then the Code 26 may be closed by providing an end date and a new Code 12 – Teacher – job classification shall be opened.

Staff Step 2b:  Staff Assignment screen – Required for Administrators (Certificated and Non-Certificated) and  Pupil Services codes only. 

  • Staff Assignment – choose a Non-Classroom Based Job Assignments from the drop down menu for Codes 10, 11, and/or 25 only.
  • Site Affiliation – Required.
  • Assignment Start and End Dates are not required unless new staff records are created or updates are made to a staff member’s responsibilities.
    • Example 1: If an Administrator is listed as the Principal of the school and this continues for more than one year, there is no need to provide an end date to the Staff Assignment of Principal once it has been created.
    • Example 2:  A Vice Principal has been given additional responsibilities after his/her first year such as Administrator of Staff Development in addition to the Vice Principal code, a new staff assignment would be added to the staff record with an appropriate start date.
    • 5 is the maximum number of Non-Classroom based job assignments that may be reported for each staff member

Once a complete demographic record has been established with a State ID, and the job classifications/staff assignments are updated, a troubleshooting report may be run by navigating to Reports > State Reporting screen in Illuminate.

Select both the SDEM (Staff Demographics) report and the SASS (Staff Assignment Report) for each school site to validate the number of records being reported to CALPADS. The Validation Logs will easily identify staff records with incomplete information, so be sure to utilize that functionality within Illuminate for each report you run.

Final notes:

  • Staff demographics and assignment records will only be exported/reported if a proper State ID is entered.
    • The 9999999999 SEID number will not report anywhere other than on the Course/Section Enrollment Reports.
    • Missing State IDs (SEID numbers) will not be found via validation logs.  Use the SDEM report to compare to your file in Step 1: Preparation to ensure all expected staff are exporting onto your report.

Good luck!

Next step:  Course Section Enrollment (CRSE) and Student Course Section Enrollment Reports (SCSE).

Updated on January 3, 2019

Was this article helpful?

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Knowledge For Schools by Measure Education