Skip to main content

CALPADS error brief · IVR

IVR0034

Duplicate Record within File
Severity Fatal
Error type Input Validation
Record type IVR

Official CALPADS rule

What CALPADS is rejecting

Two or more records exist with the same operational key fields

Focus fields

Fields validated

2.04 - Effective Start Date 2.09 - SSID

Recommended correction path

Suggested resolution

Operational key

  • 2.09 SSID
  • 2.04 Effective Start Date

Severity: Fatal.

Compare before deleting. The rows may be identical duplicates, conflicting changes, or different students sharing the wrong SSID. Retain one row only after establishing the correct student and complete demographic state effective that date.

Minimal correction path

  1. 1

    Group by SSID and start date

    Preserve every duplicate row.

  2. 2

    Compare all fields

    Identify identical, conflicting, or wrong-student values.

  3. 3

    Build one correct record

    Fix source joins or transaction generation.

  4. 4

    Resubmit and verify

    Audit other duplicates from the same process.

Official IVR0034 page