Skip to main content

CALPADS error brief · SDEM

SDEM0258

Staff Service Years Total Greater than Staff Age minus 17
Severity Fatal
Error type Input Validation
Record type SDEM

Official CALPADS rule

What CALPADS is rejecting

Staff Service Years Total must be less than or equal to Staff Age minus 17

Focus fields

Fields validated

7.16 Staff Birth Date 7.31 Staff Service Years Total

Recommended correction path

Suggested resolution

What this error actually means

CALPADS uses age minus 17 as a reasonableness ceiling. The error does not establish which field is wrong: birth date, total service years, identity, or the calculation may be incorrect.

Valid, invalid, and unsafe responses

SituationValue or conditionInterpretation
Age 40Maximum under this rule = 23 total years40 − 17 = 23.
Valid exampleAge 40; Total service 18Within the ceiling.
Invalid exampleAge 40; Total service 26Exceeds the ceiling.
Unsafe correctionReduce service years automatically to 23Verify both age and actual service history first.

Fields and records evaluated

  • 7.16 Staff Birth Date
  • 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 row belongs to the intended employee and SEID.
    • Verify birth date through authorized HR evidence.
    • Reconcile total service across current and prior employers.
    • Check spreadsheet formulas, rounding, copied totals, and swapped LEA/total fields.
  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 evidence-supported birth date, identity, or service-year total. Do not force the value down to the mathematical ceiling without historical support.

  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 SDEM0258 guidance · CALPADS Staff Demographics guidance · Report 4.4 Staff Profile List · Current specifications and code sets