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

21.05 - School of Attendance 21.07 - Academic Year ID 21.08 - SSID 21.09 - Work-Based Learning Type Code 21.10 - Internship ID 21.12 - State Course Code - Embedded Work-Based Learning

Recommended correction path

Suggested resolution

CALPADS WBLR correction guide · EOY 1 · Version 18

IVR0116: Duplicates within File based on Primary Key

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

Keep completion, timing, and evidence together

Program evidenceIdentify the completed activity, type, dates, employer or course connection, hours, evaluation, sponsorship, and supervision.
Grade and year gateInclude completed activities for students in grades 9–12. Report grades 9–11 summer activity in the subsequent academic year; exclude activity after graduation.
WBLR replacement fileBuild the complete school-and-year population before upload because replacement processing supersedes the prior population for that operational key.
EOY 1 reconciliationConfirm accepted records and reconcile participant evidence, course connections, internships, and certification reports.

Version 18 conditional-field matrix

FieldInternship 10Student-led Enterprise 15 / Simulated 20Other types
21.10 Internship IDRequiredBlankBlank
21.11 External hoursRequiredRequiredBlank
21.12 Embedded state courseNot required by this pairRequiredBlank
21.13 Employer evaluationRequiredBlankBlank
21.14 LEA sponsoredRequired Y/NBlankBlank
21.15 Certificated supervisorRequired Y/NBlankBlank

Blank is not zero or N. Zero and N are reportable values only where the field applies and the evidence supports them.

Concrete diagnostic checks

  • Group rows by school, year, SSID, WBLR type, Internship ID, and embedded state course code.
  • Determine whether the rows are true duplicates or distinct supported activities.
  • Produce one authoritative row per primary key; repair aggregation rather than deleting an arbitrary row.

Recommended correction path

  1. 1

    Preserve the rejected evidence

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

  2. 2

    Confirm the student, school, and reporting year

    Match the current SSID, qualifying SENR enrollment, School of Attendance, grade level, activity dates, and Academic Year ID.

  3. 3

    Verify the completed activity

    Have the work-based learning owner confirm the activity type and retain the employer, course, hours, evaluation, sponsorship, and supervision evidence that applies.

  4. 4

    Apply the rule-specific checks

    Group rows by school, year, SSID, WBLR type, Internship ID, and embedded state course code. Determine whether the rows are true duplicates or distinct supported activities. Produce one authoritative row per primary key; repair aggregation rather than deleting an arbitrary row.

  5. 5

    Correct the owning source

    Produce one authoritative row per primary key; repair aggregation rather than deleting an arbitrary row.

  6. 6

    Regenerate the complete replacement population

    Rebuild the WBLR file for the school and academic year, compare record counts and primary keys with the approved source roster, upload, and confirm acceptance.

  7. 7

    Reconcile EOY 1

    Review the applicable CALPADS WBLR and EOY 1 outputs, then inspect every row affected by the same SIS, program, or extract rule.

2026–27 EOY 1 operating window

Prepare and reconcileBuild the completed-activity roster and validate source evidence before the window opens.
EOY submission window opens.
CDE recommended date for reaching zero errors.
EOY certification deadline; verify the current official calendar before acting.

Before closing the correction

  • Confirm the accepted record in CALPADS.
  • Reconcile the complete school-and-year population after replacement processing.
  • Retain the program, employer, course, hours, evaluation, sponsorship, and supervision evidence that applies.
  • Repair repeatable SIS or extract defects across the affected population.

Official references