CALPADS error brief · SDEM
SDEM0689F2
Official CALPADS rule
What CALPADS is rejecting
Focus fields
Fields validated
SASS Data SDEM DataRecommended correction path
Suggested resolution
Fall 2 certification rule
Severity: Fatal Type: Certification Data Discrepancy
Staff Demographics was reported for a SEID that has no Staff Assignments.
Records or fields compared
- SASS Data
- SDEM Data
The individual record may already have passed transactional validation. An active SDEM employment record has no corresponding SASS assignment. Certification evaluates the assembled snapshot and its cross-record relationships.
What the certification snapshot is testing
| Question | Meaning | Operational response |
|---|---|---|
| What passed? | The source record was structurally acceptable. | Do not assume acceptance proves that all companion records exist. |
| What was expected? | An active SDEM employment record has no corresponding SASS assignment. | Compare the complete Fall 2 snapshot, not only the last uploaded file. |
| Who owns the evidence? | HR employment history and assignment records | Reconcile CALPADS with the authoritative source before editing. |
| What action is appropriate? | Add the supported SASS assignment or close/correct an SDEM record that should not be active | Add, correct, close, or remove only records supported by evidence. |
High-value checks
Recommended correction path
- 1
Preserve the certification evidence
Capture the revision, school, reporting year, affected identifiers, and current detail-report rows.
- 2
Verify the expected population
Determine whether the apparent gap is real, a legitimate zero, an exemption, or an incorrect source record.
- 3
Trace the complete relationship
Compare the shared identifiers, effective dates, Census Day status, and related file families.
- 4
Return to the authoritative source
Use hr employment history and assignment records; protect staff and student information while reconciling.
- 5
Apply the supported correction
Add the supported SASS assignment or close/correct an SDEM record that should not be active. Repair repeatable SIS, HR, SEDS, or scheduling mappings when applicable.
- 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
This validation will find the most recent SDEM record for an LEA based on the Effective Start Date overlapping Census Day in the current AY and then will look to see if it is open (Employment End Date is null or > Census Day) and will trigger if no corresponding (same LEA and AY) SASS record exists. The oldest SDEM Effective Date the validation will look at is 7/1/2023 and will not trigger for older records than this. If it does trigger, please try these actions to help resolve the validation: Verify that the SDEM data is valid for the SEID. If the SDEM data is valid, determine if a SASS record was submitted that corresponds (same LEA & AY) with the SDEM record. If none of the above eliminate the error, either submit a SASS record or remove or close the SDEM record.
Official references and final review
- Official CALPADS SDEM0689F2 troubleshooting page
- Review the applicable Fall 2 certification detail and summary reports after the revised snapshot is generated.
- CALPADS Fall 2 reports