Skip to main content

CALPADS error brief · IVR

IVR0067

Invalid Effective End Date - Academic Year combination
Severity Fatal
Error type Input Validation
Record type IVR

Official CALPADS rule

What CALPADS is rejecting

Effective End Date must be within Academic Year specified

Focus fields

Fields validated

7.05 Effective End Date 7.07 Academic Year ID

Recommended correction path

Suggested resolution

What this error actually means

This validates the end of the SDEM version, not necessarily the end of employment. A prior/future-year value can indicate a wrong reporting year, copied record, or field-mapping error.

Valid versus invalid

ExampleSubmitted value or conditionInterpretation
ValidEffective end lies within the record’s Academic YearThe interval belongs to one reporting year.
InvalidEnd date lies in another Academic YearCorrect year/date relationship.
Common confusionLong-term employment end date used as 7.057.29 is Staff Employment End Date; 7.05 ends this SDEM version.

Fields validated

  • 7.05 Effective End Date and 7.07 Academic Year ID

Recommended correction path

  1. 1

    Open the rejected submission detail

    Locate the exact physical row, field number, submitted value, Reporting LEA, SEID, Academic Year, and effective dates.

  2. 2

    Read the raw exported value

    Do not rely only on the formatted HR or SIS screen. Inspect spaces, delimiters, zero padding, dates, and local code translations.

  3. 3

    Test this rule

    • Verify 7.07 first.
    • Determine why this SDEM version ended.
    • Compare 7.05 with 7.29 rather than treating them as synonyms.
    • Inspect the next SDEM effective-start record if one should follow.
  4. 4

    Confirm correction authority

    HR/personnel staff own authoritative employment and demographic facts; technical staff own mappings and export behavior; the CALPADS operator verifies the submitted representation. Protect confidential personnel data throughout the review.

  5. 5

    Correct the responsible source

    Correct the SDEM effective end date, academic year, or field mapping supported by the record history.

  6. 6

    Resubmit and reconcile downstream records

    Confirm the row posts under the intended SEID and Reporting LEA. Review Staff Profile Report 4.4 and relevant Reports 4.1–4.5; then check whether the same mapping affected other staff, SASS assignments, or CRSE sections.

Official IVR0067 guidance · CALPADS Staff Demographics guidance · Fall 2 Reporting Roadmap · Report 4.4 Staff Profile List · Current CALPADS specifications and code sets