Skip to main content

CALPADS error brief · GERR

GERR0002

Value Not Found in Reference Set
Severity Fatal
Error type Input Validation
Record type GERR

Official CALPADS rule

What CALPADS is rejecting

The value provided for the field is not a valid value from the CALPADS Code Sets

Focus fields

Fields validated

8.01 Record Type Code 8.02 Transaction Type Code 8.03 Local Record ID 8.04 Reporting LEA 8.05 School of Assignment 8.06 Academic Year ID 8.07 SEID 8.08 Local Staff ID 8.09 Staff Legal First Name 8.10 Staff Legal Last Name 8.11 Staff Birth Date 8.12 Staff Gender Code 8.13 Staff Job Classification Code 8.14 Staff Job Classification FTE Percentage 8.15 Non Classroom Based Job Assignment Code 1 8.16 Non Classroom Based Job Assignment Code 2 8.17 Non Classroom Based Job Assignment Code 3 8.18 Non Classroom Based Job Assignment Code 4 8.19 Non Classroom Based Job Assignment Code 5 8.20 Non Classroom Based Job Assignment Code 6 8.21 Non Classroom Based Job Assignment Code 7

Recommended correction path

Suggested resolution

CALPADS SASS correction guide · Fatal input validation

GERR0002: Value Not Found in Reference Set

The value provided for the field is not a valid value from the CALPADS Code Sets

Official CALPADS rule

Severity: Fatal   Type: Input Validation

Fields validated:

  • 8.01 Record Type Code
  • 8.02 Transaction Type Code
  • 8.03 Local Record ID
  • 8.04 Reporting LEA
  • 8.05 School of Assignment
  • 8.06 Academic Year ID
  • 8.07 SEID
  • 8.08 Local Staff ID
  • 8.09 Staff Legal First Name
  • 8.10 Staff Legal Last Name
  • 8.11 Staff Birth Date
  • 8.12 Staff Gender Code
  • 8.13 Staff Job Classification Code
  • 8.14 Staff Job Classification FTE Percentage
  • 8.15 Non Classroom Based Job Assignment Code 1
  • 8.16 Non Classroom Based Job Assignment Code 2
  • 8.17 Non Classroom Based Job Assignment Code 3
  • 8.18 Non Classroom Based Job Assignment Code 4
  • 8.19 Non Classroom Based Job Assignment Code 5
  • 8.20 Non Classroom Based Job Assignment Code 6
  • 8.21 Non Classroom Based Job Assignment Code 7

SDLA Flowchart: debug the hierarchy from the top

1 · HR, personnel, credentialing, and local systemsConfirm the staff member, employment evidence, SEID, position, site, job classification, FTE, and assignment details in the systems responsible for those facts.
2 · SDEM staff identity and employment history Prerequisite gateThe correct SDEM record must exist and process successfully under the same Reporting LEA and SEID before a dependent assignment can be trusted.
3 · SASS staff assignment — current debugging levelValidate the same SEID plus Academic Year ID, School of Assignment, Staff Job Classification Code, FTE percentage, and any required nonclassroom assignment codes.
4 · CRSE teaching assignmentsFor classroom staff, course sections must connect to a qualifying SASS assignment for the same person, school, and academic year.
5 · SCSE enrollment and Fall 2 reviewOnly after upstream staff and course records are sound should the team reconcile student-section records, reports, and certification results.

One person does not always mean one assignment record

SDEMEstablishes the staff member’s identity and employment history.
SASSOne or more records may describe assignments by school and job classification.
CRSEEach applicable course section connects to the appropriate staff assignment.
SCSEEach student-course enrollment connects downstream to the section.

Illustrative principle: a principal who also teaches may require more than one SASS job classification. Do not create duplicate SASS rows with the same primary-key combination.

Recommended correction path

  1. 1

    Clear the SDEM prerequisite gate

    Confirm the accepted staff identity and employment coverage before changing assignment codes.

  2. 2

    Identify the exact rejected value

    Use the submission detail to locate the field, submitted code, academic year, school, and SEID.

  3. 3

    Check current code sets and combinations

    Verify the code is active for the academic year and permitted with the related job classification and assignment fields.

  4. 4

    Inspect local crosswalks

    Compare HR and SIS values with the translation used by the SASS extract.

  5. 5

    Correct the source or mapping

    Update the authoritative position or assignment record, or the crosswalk that translated it.

  6. 6

    Retest the affected population

    Regenerate SASS, review related CRSE records, and scan other staff using the same mapping.

2026–27 Fall 2 working calendar

Before Census DayReconcile SDEM identities, employment coverage, SASS assignments, school mappings, classifications, FTE, and course dependencies.
Fall 2 Census Day and opening of the official submission window.
CDE’s recommended date for reaching zero Fall 2 errors.
Certification deadline. Fall 2 has no amendment window.

Verify the official CDE reporting calendar before acting because dates can change.

Before closing the correction

  • Confirm the accepted SDEM identity and employment history under the intended Reporting LEA and SEID.
  • Confirm the accepted SASS record under the intended academic year, school, and job classification.
  • Reconcile applicable CRSE records and Fall 2 staff reports after the upstream correction.
  • Check other staff records created by the same HR, SIS, integration, or extract rule.

Official references and practical support