Skip to main content

CALPADS error brief · SDEM

SDEM0113

Staff Service Years LEA Greater than Staff Service Years Total
Severity Fatal
Error type Input Validation
Record type SDEM

Official CALPADS rule

What CALPADS is rejecting

Staff Service Years LEA must be less or equal to Staff Service Years Total

Focus fields

Fields validated

7.30 Staff Service Years LEA 7.31 Staff Service Years Total

Recommended correction path

Suggested resolution

CALPADS SDEM correction guide · Fatal input validation

SDEM0113: Staff Service Years LEA Greater than Staff Service Years Total

Staff Service Years LEA must be less or equal to Staff Service Years Total

Official CALPADS rule

Severity: Fatal   Type: Input Validation

Fields validated:

  • 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

    Assemble employment evidence

    Use the HR personnel record, employment dates, and verified service history.

  2. 2

    Recalculate the relationship

    Compare LEA years, total years, birth date, and employment dates using the CALPADS rule.

  3. 3

    Resolve definition differences

    Ask HR/personnel and CALPADS staff to distinguish credited service, local tenure, and CALPADS reporting conventions.

  4. 4

    Correct the authoritative value

    Update the responsible source or mapping rather than forcing a plausible number into the extract.

  5. 5

    Verify staff and population

    Post SDEM, review Report 4.4, and check others affected by the same calculation.

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