SOFF0502

Invalid Incident ID



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


ACTIVE DEFECTS:

None

ERROR DESCRIPTION:

The Incident ID and Academic Year Combination must match an existing SINC Incident ID and SINC Academic Year ID combination for the same Student where Statutory Offense is indicated

FIELDS VALIDATED:

  • 20.06 - Academic Year ID
  • 20.07 - SSID
  • 20.13 - Incident ID
  • 18.06 - Academic Year ID
  • 18.07 - SSID
  • 18.13 - Incident ID
  • 18.15 - Statutory Offense indicator

SUGGESTED RESOLUTION:

Understanding the Error:

The SINC Incident ID does not exist in CALPADS for the current Academic Year. The SINC record needs to be posted to link to this SOFF record.

Trigger: If SOFF Incident ID and Academic Year ID combination does not exists in SINC table for same student where Statutory Offense indicator = "Y" in ODS

Suggested Resolution:

1) Verify that the Incident ID has been created using the Student Incident (SINC) file type and has been posted to CALPADS, OR 2) Verify the Incident ID being used is the same as the Incident ID already posted to CALPADS

NOTES:

9/2022 - updated error description

UPDATE:

N/A

ADDITIONAL INFORMATION:

None



Need more help?

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