Skip to main content

CALPADS error brief · SDEM

SDEM0221

Staff Service Years must be one or greater even if the Staff member has less than one year of total service
Severity Fatal
Error type Input Validation
Record type SDEM

Official CALPADS rule

What CALPADS is rejecting

Staff Service Years LEA (7.30) and Staff Service Years Total (7.31) must be equal to one or more

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

CALPADS uses a minimum reported value of 1 for a staff member in the first year of service. Zero does not mean “less than one year” under this rule.

Valid, invalid, and unsafe responses

SituationValue or conditionInterpretation
First yearLEA 1; Total 1Use the CALPADS minimum for less than one completed year.
Returning experienced employeeLEA 1; Total greater than 1First LEA year with prior service.
InvalidLEA 0 and/or Total 0Zero is not accepted.
Invalid shortcutBlank values inserted as 1 without confirming staff inclusionFirst verify the person and reporting requirement.

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 staff member belongs in SDEM for the reporting context.
    • Identify first-year versus experienced service.
    • Check whether HR stores completed years as zero and requires a CALPADS crosswalk.
    • Ensure LEA years still do not exceed total years.
  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

    Map a genuine first partial year to 1 as CALPADS requires, or correct the supported service-year calculation for experienced staff.

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