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

What this error actually means

CALPADS interprets them as one student-section relationship even if the SIS produced separate rows.

Valid versus invalid student-section records

PatternSCSE conditionInterpretation
Valid patternOne row per complete primary keyThe SCSE value and prerequisite relationships agree.
Invalid patternRepeated row or conflicting values with same keyCALPADS rejects the structure, identity, organization, or relationship.
Diagnostic cautionPreserve distinct real sections with distinct supported identifiers.Correct the first unsupported source fact.

Fields and prerequisites evaluated

  • 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

The Fall 2 dependency chain

Student identity and SENR ownership → local schedule → SDEM/SASS educator → CRSE section → SCSE membership → Reports 3.6 and 3.7

Registration and enrollment staff own SENR facts; counseling/scheduling staff own the student’s actual schedule; curriculum and master-schedule staff own course/section identifiers; SIS/CALPADS staff preserve those relationships in the extract.

Recommended correction path

  1. 1

    Preserve the rejected SCSE row

    Capture Reporting LEA, school, year, masked SSID, Local Course ID, Course Section ID, term, birth date, and the submission detail.

  2. 2

    Confirm identity and enrollment

    Match the student to the current SSID and verify qualifying SENR ownership at the applicable school and dates.

  3. 3

    Confirm the CRSE prerequisite

    Locate the accepted section with matching school, year, term, Local Course ID, and Course Section ID.

  4. 4

    Compare the actual local schedule

    Determine whether the student truly belongs in this section. Check drops, transfers, concurrent enrollment, rollover schedules, and duplicate joins.

  5. 5

    Correct the owning source

    Repair the supported enrollment, schedule, identifier, school/year configuration, crosswalk, or Version 18 export behavior. Avoid a one-off file edit.

  6. 6

    Resubmit and reconcile

    Confirm IVR0116 clears, review Report 3.6 Course Section Enrollment by Content Area and Report 3.7 Course Section Enrollment details, and audit other students generated by the same configuration.

Official IVR0116 guidance · CALPADS Course Data guidance · Report 3.6 · Report 3.7 · Current specifications and code sets