IVR0116

Duplicates within File based on Primary Key



Submission: CRSE
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:

  • 9.05 School of Course Delivery
  • 9.06 Academic Year ID
  • 9.08 CRS-Local Course ID
  • 9.14 Course Section ID
  • 9.15 Academic Term Code
  • 9.16 SEID

SUGGESTED RESOLUTION:

Understanding the Error:

The Course Section file submitted file submitted contains two or more records that CALPADS interprets as the same record. Both records have the same values provided in the validated fields.

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:

Remove one of the duplicate records.

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.