IVR0116
Duplicates within File based on Primary Key
Submission: SASS
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:
- 8.05 School of Assignment
- 8.06 Academic Year ID
- 8.07 SEID
- 8.13 Staff Job Classification Code
SUGGESTED RESOLUTION:
Understanding the Error:
The Staff Assignment file submitted contains two records that CALPADS interprets as the same record. Both records have the same School of Assignment, Academic Year ID, SEID, and Staff Job Classification Code. These are the fields that CALPADS uses to uniquely identify a record in the ODS. Therefore, there can't be two records with the same unique identifiers.
Things to check for in 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:
1/2023 - updated field validated and suggested resolution.
ADDITIONAL INFORMATION:
None
Need more help?
Let's start the conversation by filling out the CALPADS Service Request Form.