Skip to main content

CALPADS error brief · GERR

GERR0007

Code submitted outside the effective date range
Severity Fatal
Error type Input Validation
Record type GERR

Official CALPADS rule

What CALPADS is rejecting

Code submitted outside the effective date range

Focus fields

Fields validated

7.01 Record Type Code 7.02 Transaction Type Code 7.03 Local Record ID 7.04 Effective Start Date 7.05 Effective End Date 7.06 Reporting LEA 7.07 Academic Year ID 7.08 SEID 7.09 Local Staff ID 7.10 Staff Legal First Name 7.11 Staff Legal Middle Name 7.12 Staff Legal Last Name 7.13 Staff Alias First Name 7.14 Staff Alias Middle Name 7.15 Staff Alias Last Name 7.16 Staff Birth Date 7.17 Staff Gender Code 7.18 Staff Hispanic Ethnicity Indicator 7.19 Staff Ethnicity Missing Indicator 7.20 Staff Race 1 Code 7.21 Staff Race 2 Code 7.22 Staff Race 3 Code 7.23 Staff Race 4 Code 7.24 Staff Race 5 Code 7.25 Staff Race Missing Indicator 7.26 Staff Highest Degree Code 7.27 Staff Employment Status Code 7.28 Staff Employment Start Date 7.29 Staff Employment End Date 7.30 Staff Service Years LEA 7.31 Staff Service Years Total

Recommended correction path

Suggested resolution

CALPADS SDEM correction guide · Fatal input validation

GERR0007: Code submitted outside the effective date range

Code submitted outside the effective date range

Official CALPADS rule

Severity: Fatal   Type: Input Validation

Fields validated:

  • 7.01 Record Type Code
  • 7.02 Transaction Type Code
  • 7.03 Local Record ID
  • 7.04 Effective Start Date
  • 7.05 Effective End Date
  • 7.06 Reporting LEA
  • 7.07 Academic Year ID
  • 7.08 SEID
  • 7.09 Local Staff ID
  • 7.10 Staff Legal First Name
  • 7.11 Staff Legal Middle Name
  • 7.12 Staff Legal Last Name
  • 7.13 Staff Alias First Name
  • 7.14 Staff Alias Middle Name
  • 7.15 Staff Alias Last Name
  • 7.16 Staff Birth Date
  • 7.17 Staff Gender Code
  • 7.18 Staff Hispanic Ethnicity Indicator
  • 7.19 Staff Ethnicity Missing Indicator
  • 7.20 Staff Race 1 Code
  • 7.21 Staff Race 2 Code
  • 7.22 Staff Race 3 Code
  • 7.23 Staff Race 4 Code
  • 7.24 Staff Race 5 Code
  • 7.25 Staff Race Missing Indicator
  • 7.26 Staff Highest Degree Code
  • 7.27 Staff Employment Status Code
  • 7.28 Staff Employment Start Date
  • 7.29 Staff Employment End Date
  • 7.30 Staff Service Years LEA
  • 7.31 Staff Service Years Total

SDLA Flowchart: follow the staff data from source to certification

1 · Authoritative personnel evidenceHR, personnel, payroll, credentialing, and staff-provided records establish the supported facts.
2 · Local reconciliationResolve identity, SEID, employment dates, demographics, service history, and ownership across the systems that hold them.
3 · SIS or integration extractTranslate local values into the current 31-field SDEM layout, CALPADS code sets, and effective-date rules.
4 · CALPADS SDEM historyPost the supported staff demographic record and inspect the accepted effective-dated history under the correct SEID and LEA.
5 · Downstream review and Fall 2 certificationReconcile SASS and CRSE dependencies, Reports 4.1–4.5, Census Day inclusion, and certification totals.

Recommended correction path

  1. 1

    Identify the rejected code

    Use the submission detail to locate the precise field and submitted value.

  2. 2

    Compare current code sets

    Check the code value, effective dates, academic year, and allowed combinations.

  3. 3

    Inspect local mappings

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

  4. 4

    Correct the source or mapping

    Update the authoritative record or crosswalk—not only the upload file.

  5. 5

    Retest the affected population

    Regenerate SDEM and scan other staff records using the same code.

2026–27 Fall 2 calendar

Before Census DayReconcile HR/personnel, SEIDs, SDEM histories, SASS assignments, course records, and local mappings.
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 calendar before acting because dates can change.

Before closing the correction

  • Confirm the accepted SDEM history under the intended SEID and Reporting LEA.
  • Compare CALPADS Report 4.4 with authorized HR/personnel evidence.
  • Reconcile related SASS and CRSE records and Fall 2 Reports 4.1–4.5.
  • Check other staff affected by the same source, mapping, or interface rule.

Official references and practical support