Skip to main content

CALPADS error brief · IVR

IVR0116

Duplicate Effective Start Date in file
Severity Fatal
Error type Input Validation
Record type IVR

Official CALPADS rule

What CALPADS is rejecting

Only one record for an SSID may exist in the file with the same Effective Start Date

Focus fields

Fields validated

2.04 - Effective Start Date

Recommended correction path

Suggested resolution

Operational key

  • 2.09 SSID
  • 2.04 Effective Start Date

Severity: Fatal.

Do not simply keep the first row. Later duplicate rows may contain the correct name, address, or demographic change. Compare every field and produce one supported record.

Minimal correction path

  1. 1

    Group duplicate rows

    Use SSID plus Effective Start Date.

  2. 2

    Compare all values

    Resolve identity and demographic conflicts.

  3. 3

    Repair the extract

    Correct duplicate joins or transaction creation.

  4. 4

    Resubmit and audit peers

    Confirm IVR0116 clears.

Official IVR0116 page