Skip to main content

CALPADS error brief · FRMT

FRMT0009

Invalid column count for file type
Severity Fatal
Error type Input Validation
Record type FRMT

Official CALPADS rule

What CALPADS is rejecting

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

Focus fields

Fields validated

20.01 Record Type Code 20.02 Transaction Type Code 20.03 Local Record ID 20.04 Reporting LEA 20.05 School of Attendance 20.06 Academic Year ID 20.07 SSID 20.08 Local Student ID 20.09 Student Legal First Name 20.10 Student Legal Last Name 20.11 Student Date of Birth 20.12 Student Gender Code 20.13 Incident ID Local 20.14 Student Offense Code 20.15 Weapon Category Code

Recommended correction path

Suggested resolution

CALPADS SOFF correction guide · Fatal input validation

FRMT0009: Invalid column count for file type

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

Official CALPADS rule

Severity: Fatal   Type: Input Validation

Fields validated:

  • 20.01 Record Type Code
  • 20.02 Transaction Type Code
  • 20.03 Local Record ID
  • 20.04 Reporting LEA
  • 20.05 School of Attendance
  • 20.06 Academic Year ID
  • 20.07 SSID
  • 20.08 Local Student ID
  • 20.09 Student Legal First Name
  • 20.10 Student Legal Last Name
  • 20.11 Student Date of Birth
  • 20.12 Student Gender Code
  • 20.13 Incident ID Local
  • 20.14 Student Offense Code
  • 20.15 Weapon Category Code

Recommended correction path

  1. 1

    Preserve the rejected evidence

    Record the submission ID, row number, file name, export time, delimiter, and exact rejected SOFF row. Keep an untouched copy for comparison.

  2. 2

    Locate the field precisely

    Compare the row with the current 15-field SOFF layout and the complete validated-field list below. Check length, position, delimiter, blank placeholders, encoding, and hidden characters.

  3. 3

    Compare SIS and extract mappings

    Trace the value from the discipline module through local code translations into the SOFF extract. Confirm the extract uses the current CALPADS layout.

  4. 4

    Correct the source or generator

    Repair the authoritative value, translation table, or report definition. Do not hand-edit only the upload file when the next extract would reproduce the defect.

  5. 5

    Regenerate and regression-check

    Create a scoped incident extract, compare SINC, SIRS, and SOFF keys, upload it, and check other records produced by the same mapping.

Where this correction sits in the 2026–27 calendar

Capture throughout the yearKeep incident IDs, offenses, results, statutory-offense decisions, weapon details, and special-education safeguards aligned while evidence is fresh.
EOY 1 submission window opens; Student Incidents are part of the consolidated EOY 1 collection.
CDE’s recommended date for reaching zero EOY 1 errors.
EOY 1 amendment window closes; required SELPA approval must be complete.

Dates are from the current CDE CALPADS 2026–27 calendar. Verify the official calendar before acting because dates can change.

Before closing the ticket

  • Confirm the corrected SOFF record under the intended student and Incident ID Local in CALPADS.
  • Reconcile the related SINC parent and every applicable SIRS/SOFF child record.
  • Document whether the defect arose in source evidence, coding, translation, enrollment, configuration, or extract logic.
  • Check other incidents affected by the same local rule before EOY 1 certification.

Official references and practical support

SIS, discipline, and extract support

Begin with your vendor’s current California/CALPADS documentation. Incident models, local offense codes, weapon mappings, and SINC/SIRS/SOFF extract paths vary by product and configuration. Inclusion is not an endorsement; some resources require customer access.