IVR0116

Duplicates within File based on Primary Key



Submission: WBLR
Status: Active
Severity: Fatal
Input Validation: X
Data Discrepancy: N/A


ACTIVE DEFECTS:

None

ERROR DESCRIPTION:

Two or more records exist with the same primary key 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

SUGGESTED RESOLUTION:

Understanding the Error:

Two or more records in the file contain the same data for School of Attendance, Academic Year ID, SSID, Work-Based Learning Type Code, Internship ID, and State Course Code - Embedded Work-Based Learning.

Things to check for in file submission: Verify that the fields listed in the Fields Validated column are correct in the submitted file.

Suggested Resolution:

1) Delete one of the duplicate records and resubmit the file. OR 2) If file produced from local SIS, contact vendor/technical resource to determine reason for duplicate record and to determine how to resolve the problem.

NOTES:

n/a

UPDATE:

n/a

ADDITIONAL INFORMATION:

None



Need more help?

Let's start the conversation by filling out the CALPADS Service Request Form.