SOFF - Student Offense

SOFF errors involve offenses associated with a reported student incident. These validations check offense codes, weapon or substance information, and relationships to the correct incident and student. Confirm that each offense accurately describes the event and is linked to the corresponding SINC and SIRS records without duplication or conflicting values.

FRMT0001 Wrong field length

Field length must match CALPADS File Specifications (CFS)

FRMT0009 Invalid column count for file type

Format for invalid column (fields) count based on file type

GERR0001 Required Field Missing

A required field for the submitted Records Type is missing

GERR0002 Value Not Found in Reference Set

The value provided for the field is not a valid value from the CALPADS Code Sets

GERR0005 - SINC/SIRS/SOFF LEA does not have ownership of student enrollment to make the update

Student must be enrolled in the School of Attendance during the Academic Year specified

GERR0007 Code submitted outside the Effective Date Range

Code must be submitted with an Academic Year ID that overlaps, on at least one day, the CALPADS effective date range for the code.

IVR0001 Invalid Submitter

The Reporting LEA of the submitter must equal the Reporting LEA in the record, or the Reporting SELPA of the submitter must have a relationship with the Reporting LEA in the record.

IVR0002 Invalid Reporting School

School must be a valid code in CDS and have an active CALPADS reporting relationship with the Reporting LEA

IVR0006 Invalid Academic Year

Academic Year ID must be a valid academic school year combination and no more than one year in the future

IVR0007 Invalid SSID

SSID must be a valid CALPADS SSID in the ODS

IVR0009 Invalid Characters in Field

Field must only contain Alphabetic letters, numbers, periods, hyphens apostrophes, forward slashes, spaces. Alphabetic characters with accents, tildes, or umlauts are allowed. Valid characters are based on the UTF-8 character set standards.

IVR0116 Duplicates within File based on Primary Key

Two or more records exist with the same primary key fields.

SOFF0091 Invalid Student Offense Code and Weapon Category Combination

Student Offense Code and Weapon Category Code must be a valid combination

SOFF0095 Missing Weapon Category Code

If Student Offense Code = '100', '101', '103', '104', or '105' Then Weapon Category Code must be populated

SOFF0502 Invalid Incident ID

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

SOFF0510 Missing Removal to Interim Alternative Setting Reason Code

If student has an Active SPED Plan at the same Reporting LEA AND Student Offense Code in ('100', '103', '105', '200', '400', '401', '500',' 503', '505', '600') then associated SINC Removal to Interim Alternative Setting Reason Code should be populated