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

If two or more records exist in the file based on the file type's primary key fields.

Focus fields

Fields validated

26.04 Reporting LEA 26.05 Academic Year ID 26.07 Local Student ID 26.08 LEA Education Program Code

Recommended correction path

Suggested resolution

LEAP validation

Severity: Fatal   Type: Input Validation

Fields validated

  • 26.04 Reporting LEA
  • 26.05 Academic Year ID
  • 26.07 Local Student ID
  • 26.08 LEA Education Program Code

Keep three different facts separate

Program enrollmentMaintain the required signed registration evidence for the expanded-learning program.
Eligible participationCombine eligible attendance sources and count each calendar date only once.
LEAP reportingSubmit code 194 and the annual distinct-day count for the correct student, LEA, and year.

Concrete diagnostic checks

  • Group source rows by Reporting LEA, Academic Year ID, Local Student ID, and Program Code.
  • Combine ELO-P, ASES, 21st CCLC, and ASSETS dates before counting.
  • Deduplicate the calendar date so one student-day is never counted twice.

Recommended correction path

  1. 1

    Preserve the rejected evidence

    Record the submission ID, row number, exact nine-field row, source file, export time, and rejected value before changing anything.

  2. 2

    Confirm the intended student, LEA, and year

    Match SSID and Local Student ID, confirm Reporting LEA, and place enrollment and participation inside the correct academic year.

  3. 3

    Trace the expanded-learning evidence

    Connect signed registration, eligible program, dated attendance, source vendor, and any deduplication or aggregation process.

  4. 4

    Apply the rule-specific checks

    Group source rows by Reporting LEA, Academic Year ID, Local Student ID, and Program Code. Combine ELO-P, ASES, 21st CCLC, and ASSETS dates before counting. Deduplicate the calendar date so one student-day is never counted twice.

  5. 5

    Correct the owning source

    Produce one authoritative row per primary key with one reconciled distinct-day total; repair the aggregation logic rather than deleting an arbitrary duplicate.

  6. 6

    Regenerate, resubmit, and reconcile

    Confirm acceptance, then reconcile CALPADS Reports 19.1 and 19.2 with the registration roster and distinct-date evidence. Check every record affected by the same system rule.

Official references