Skip to main content

CALPADS error brief · IVR

IVR0116

Duplicates within File based on Primary Key
Severity Fatal
Error type Input Validation
Record type IVR

Official CALPADS rule

What CALPADS is rejecting

Two or more records exist with the same primary key fields.

Focus fields

Fields validated

3.05 - School of Attendance 3.07 - SSID 3.13 - Education Program Code 3.15 - Education Program Membership Start Date 3.17 - Education Service Academic Year 3.18 - Education Service Code

Recommended correction path

Suggested resolution

Primary-key fields

  • 3.05 School of Attendance
  • 3.07 SSID
  • 3.13 Education Program Code
  • 3.15 Membership Start Date
  • 3.17 Service Academic Year
  • 3.18 Education Service Code

The service fields distinguish Title I Part A Basic Targeted records; for other programs they are normally blank.

Duplicate rows are not always duplicate facts. They may represent one record emitted twice, two source records collapsed to the same key, or distinct services whose key fields were lost.

Duplicate diagnosis

RowsLikely causeCorrection
Identical in every fieldDuplicate extraction/joinRemove duplication and repair generator.
Same key, different End DateMultiple versions emittedSelect the supported current transaction.
Same key, different non-key detailSource records collapsedDetermine whether key dates/services are missing or one row is invalid.
Title I services collapsed3.17/3.18 missing or mis-mappedRestore correct academic year and service codes.

Recommended correction path

  1. 1

    Group the file by full key

    Preserve every duplicate row and difference.

  2. 2

    Verify the underlying program events

    Determine whether one or multiple factual memberships/services exist.

  3. 3

    Correct the source or key

    Remove duplicate generation or restore the supported distinguishing values.

  4. 4

    Validate the entire file

    Confirm every operational key is unique before resubmission.

Official IVR0116 page