Skip to main content

CALPADS error brief · SDEM

SDEM0109

Invalid Staff Ethnicity Missing Indicator and Staff Hispanic Ethnicity Indicator Combination
Severity Fatal
Error type Input Validation
Record type SDEM

Official CALPADS rule

What CALPADS is rejecting

Staff Ethnicity Missing Indicator must accurately reflect what is populated in the Staff Hispanic Ethnicity Indicator

Focus fields

Fields validated

7.18 Staff Hispanic Ethnicity Indicator 7.19 Staff Ethnicity Missing Indicator

Recommended correction path

Suggested resolution

What this error actually means

CALPADS treats Hispanic/Latino ethnicity as a separate question from race. “Missing” describes the absence of a response; it is not a third ethnicity answer and must not contradict a populated Y/N value.

Valid, invalid, and unsafe responses

SituationValue or conditionInterpretation
ConsistentHispanic indicator populated; missing indicator shows not missingA response is being reported.
ConsistentHispanic indicator blank; missing indicator uses the applicable missing conditionNo ethnicity response is present.
ConflictingHispanic indicator populated and also marked missingThe two fields tell different stories.
Wrong practiceInfer ethnicity from surname or languageUse authorized, preferably self-reported information.

Fields and records evaluated

  • 7.18 Staff Hispanic Ethnicity Indicator
  • 7.19 Staff Ethnicity Missing Indicator

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

    • Read fields 7.18 and 7.19 together.
    • Confirm whether the staff member supplied an ethnicity response.
    • Trace blank, unknown, declined, and null mappings in HR/SIS.
    • Do not infer Hispanic/Latino ethnicity from name, appearance, language, birthplace, or colleagues.
  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 response or missing-indicator mapping so both fields accurately represent the authorized staff information.

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