Skip to main content

CALPADS error brief ยท SDEM

SDEM0115F2

Staff Service Years LEA Greater than Staff Age minus 17
Severity Warning
Error type CDD
Record type SDEM

Official CALPADS rule

What CALPADS is rejecting

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

Focus fields

Fields validated

7.16 Staff Birth Date 7.30 Staff Service Years LEA

Recommended correction path

Suggested resolution

Fall 2 certification rule

Severity: Fatal   Type: Certification Data Discrepancy

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

Records or fields compared

  • 7.16 Staff Birth Date
  • 7.30 Staff Service Years LEA

The individual record may already have passed transactional validation. Reported LEA service years exceed the person's possible service since age 17. Certification evaluates the assembled snapshot and its cross-record relationships.

What the certification snapshot is testing

QuestionMeaning Operational response
What passed?The source record was structurally acceptable.Do not assume acceptance proves that all companion records exist.
What was expected?Reported LEA service years exceed the person's possible service since age 17.Compare the complete Fall 2 snapshot, not only the last uploaded file.
Who owns the evidence?HR service-credit and identity recordsReconcile CALPADS with the authoritative source before editing.
What action is appropriate?Correct Staff Service Years LEA or the underlying birth-date historyAdd, correct, close, or remove only records supported by evidence.

High-value checks

1 โ€” PopulationRecalculate completed qualifying years under the current definition
2 โ€” RelationshipCheck decimal, total-career and LEA-only mapping
3 โ€” VerificationAvoid commentary or assumptions about the person's age

Recommended correction path

  1. 1

    Preserve the certification evidence

    Capture the revision, school, reporting year, affected identifiers, and current detail-report rows.

  2. 2

    Verify the expected population

    Determine whether the apparent gap is real, a legitimate zero, an exemption, or an incorrect source record.

  3. 3

    Trace the complete relationship

    Compare the shared identifiers, effective dates, Census Day status, and related file families.

  4. 4

    Return to the authoritative source

    Use hr service-credit and identity records; protect staff and student information while reconciling.

  5. 5

    Apply the supported correction

    Correct Staff Service Years LEA or the underlying birth-date history. Repair repeatable SIS, HR, SEDS, or scheduling mappings when applicable.

  6. 6

    Repost, regenerate, and compare

    Wait for processing, regenerate the certification snapshot, and confirm both the error and downstream counts are corrected.

Retained official CALPADS guidance

Verify Staff Service Years LEA and Staff Birth Date in the submission against validation described in the Error Description column and correct appropriately.

Official references and final review