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

What this error actually means

LEA service is a subset of total service. If someone has 12 years at this LEA, the total cannot be 8; the values may have been reversed, derived on different dates, or calculated under inconsistent local rules.

Valid, invalid, and unsafe responses

SituationValue or conditionInterpretation
ValidLEA 5; Total 12Five years here are included within twelve overall.
ValidLEA 12; Total 12All reported service occurred at this LEA.
InvalidLEA 12; Total 8The subset exceeds the total.
InvestigateLEA and total refreshed on different datesUse one consistent reporting basis.

Fields and records evaluated

  • 7.30 Staff Service Years LEA
  • 7.31 Staff Service Years Total

Recommended correction path

  1. 1

    Preserve the rejected evidence

    Capture the submission, row, field values, Reporting LEA, masked SEID, effective dates, and related SASS/CRSE identifiers before editing.

  2. 2

    Confirm the person and business key

    Use authorized evidence to match the educator, Reporting LEA, SEID, and effective period. Do not include SSNs in ordinary working notes.

  3. 3

    Test the exact rule

    • Confirm the definitions used by the current CFS.
    • Compare HR service-credit records and prior-employer evidence.
    • Check whether fields 7.30 and 7.31 were reversed.
    • Verify both values were calculated for the same reporting point.
  4. 4

    Find the first divergence

    Determine whether the problem began in authorized personnel evidence, HR/SIS entry, a local crosswalk, an integration, file generation, or CALPADS history.

  5. 5

    Make the supported correction

    Correct the source calculation or mapping so LEA service is no greater than total service, without discarding valid prior service.

  6. 6

    Regenerate and reconcile

    Confirm the accepted SDEM history under the intended Reporting LEA and SEID. Review Report 4.4 and applicable Reports 4.1–4.5, then inspect other staff affected by the same mapping or workflow.

Official SDEM0113 guidance · CALPADS Staff Demographics guidance · Report 4.4 Staff Profile List · Current specifications and code sets