SOFF0212
Duplicate Student Offense records exist for the same student
Submission: SOFF
Status: Inactive
Severity: Fatal
Input Validation: N/A
Data Discrepancy: X
ACTIVE DEFECTS:
None
ERROR DESCRIPTION:
The following combination of fields may not be duplicated in more than one record: Academic Year ID, School of Attendance, SSID, Incident ID Local, Student Offense Code
FIELDS VALIDATED:
- 20.06 - Academic Year ID
- 20.05 - School of Attendance
- 20.07 - SSID
- 20.13 - Incident ID Local
- 20.14 - Student Offense Code
SUGGESTED RESOLUTION:
Understanding the Error:
A student may be reported only once in a Reporting Year and School for the same incident and offense.
Things to check for:
Check the values of the validated fields. Two or more records contain identical values in these fields.
Suggested Resolution:
Identify if a posted SOFF record matches one or more SOFF records in the ODS with the same Academic Year ID, SSID, School of Attendance, Disciplinary Incident ID Local, and Student Offense Code. Delete the duplicate.
NOTES:
6/2022 - Disabled
UPDATE:
N/A
ADDITIONAL INFORMATION:
None
Need more help?
Let's start the conversation by filling out the CALPADS Service Request Form.