Skip to main content

CALPADS error brief · IVR

IVR0066

Effective End Date less than Effective Start Date
Severity Fatal
Error type Input Validation
Record type IVR

Official CALPADS rule

What CALPADS is rejecting

Effective End Date must be greater than or equal to Effective Start Date

Focus fields

Fields validated

7.04 Effective Start Date 7.05 Effective End Date

Recommended correction path

Suggested resolution

What this error actually means

The two fields define the effective interval for this demographic version. They do not necessarily represent hiring and separation; those are Staff Employment Start and End Dates.

Valid versus invalid

ExampleSubmitted value or conditionInterpretation
ValidStart 20260801; end 20261015End follows start.
Valid when supportedStart and end on the same dateZero-length/same-day interval is chronologically permitted by this rule.
InvalidStart 20261015; end 20260801End precedes start.
Common mapping errorEmployment End Date exported into 7.05Effective and employment timelines have been confused.

Fields validated

  • 7.04 Effective Start Date and 7.05 Effective End Date

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

    • Compare all eight digits of 7.04 and 7.05.
    • Confirm the year and month were not transposed.
    • Distinguish SDEM effective dates from fields 7.28 and 7.29.
    • Review adjacent SDEM versions for gaps, overlaps, or reversal.
  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 inaccurate boundary or mapping. Do not alter a valid employment date to repair an SDEM-versioning error.

  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 IVR0066 guidance · CALPADS Staff Demographics guidance · Fall 2 Reporting Roadmap · Report 4.4 Staff Profile List · Current CALPADS specifications and code sets