SIRS0492

Duplicate Student Incident Result records exist for the same student



Submission: SIRS
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, Incident Result Code

FIELDS VALIDATED:

  • 19.06 - Academic Year ID
  • 19.05 - School of Attendance
  • 19.07 - SSID
  • 19.13 - Incident ID Local
  • 19.14 - Incident Result 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 which SIRS record matches is causing the duplication with the same Academic Year ID, SSID, School of Attendance, Incident ID Local, and Incident Result Code and delete the record.

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.