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

10.05 School of Course Delivery 10.06 Academic Year ID 10.07 SSID 10.13 CRS-Local Course ID 10.14 Course Section ID 10.15 Academic Term Code 10.20 Current CALPADS field definition

Recommended correction path

Suggested resolution

CALPADS SCSE correction guide - Fatal input validation

IVR0116: Duplicates within File based on Primary Key

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

Official Version 17.23 rule

Severity: Fatal   Type: Input Validation

Fields validated:

  • 10.05 School of Course Delivery
  • 10.06 Academic Year ID
  • 10.07 SSID
  • 10.13 CRS-Local Course ID
  • 10.14 Course Section ID
  • 10.15 Academic Term Code
  • 10.20 Current CALPADS field definition

SDLA Flowchart: validate the reporting chain from the top

1 - Local enrollment and instructional realityConfirm the student, school, dates, schedule, course, and section.
2 - SENR enrollment ownershipThe accepted enrollment must support the SSID, school, and applicable dates.
3 - SDEM, SASS, and CRSE prerequisitesConfirm the educator assignment and course section in the same context.
4 - SCSE student-to-section relationshipConnect the SSID to the intended section with matching identifiers.
5 - Fall 2 reports and certificationReconcile schedules, course counts, assignments, and services.

Recommended correction path

  1. 1

    Preserve all competing rows

    Do not delete until the source relationships are compared.

  2. 2

    Compare the complete primary key

    Match School of Course Delivery, Academic Year ID, SSID, CRS-Local Course ID, Course Section ID, and Academic Term Code.

  3. 3

    Confirm the student's real schedule

    Ask counseling or scheduling staff whether one or multiple relationships are intended.

  4. 4

    Find the duplication mechanism

    Inspect repeated extracts, duplicate schedule rows, concurrent enrollment logic, and section identifiers.

  5. 5

    Correct the authoritative source

    Repair the SIS value, school-year configuration, schedule, crosswalk, or extract rule rather than hand-editing only one upload row.

  6. 6

    Reprocess and reconcile

    Confirm SCSE acceptance and inspect other students produced by the same configuration.

2026-27 Fall 2 calendar

Before Census DayReconcile enrollment, schedules, CRSE sections, and SCSE connections.
Census Day and opening.
Recommended zero-error date.
Certification; no amendment window.

Before closing the correction

  • Confirm enrollment ownership and the accepted CRSE section.
  • Confirm the SCSE row represents the student's actual schedule.
  • Review other records produced by the same configuration.

Official references and practical support