Skip to main content

CALPADS error brief · FRMT

FRMT0004

Invalid characters for numeric field
Severity Fatal
Error type Input Validation
Record type FRMT

Official CALPADS rule

What CALPADS is rejecting

Data for a numeric field must be a number or a decimal point.

Focus fields

Fields validated

8.14 Staff Job Classification FTE Percentage

Recommended correction path

Suggested resolution

What this error actually means

Labels and display symbols are not numeric data. Values such as “50%,” “.5 FTE,” or comma-formatted numbers reject even when a person understands them.

Valid, invalid, and unsafe responses

SituationValue or conditionInterpretation
Valid50 or 50.0Fifty percent in required numeric form.
Invalid50%Percent sign is not submitted.
Invalid.5 FTEContains text and may confuse fraction with percentage.
Invalid1,00Unsupported locale punctuation.

Fields and records evaluated

  • 8.14 Staff Job Classification FTE Percentage

Recommended correction path

  1. 1

    Preserve the rejected row

    Capture submission ID, row, Reporting LEA, School, Academic Year, masked SEID, Job Classification, FTE, and assignment-code positions.

  2. 2

    Confirm identity and organization

    Match accepted SDEM history, authorized HR evidence, official organization codes, and the actual assignment before editing.

  3. 3

    Test the exact rule

    • Inspect the literal field 8.14.
    • Confirm the source stores a fraction or percentage.
    • Remove display formatting through the export mapping.
    • Then verify the value is at least 1 and less than 200 as applicable.
  4. 4

    Find the first divergence

    Trace HR, position control, SIS scheduling, code crosswalks, joins, spreadsheet handling, file generation, and upload context.

  5. 5

    Make the supported correction

    Export the evidence-supported numeric percentage without labels or symbols.

  6. 6

    Regenerate and reconcile

    Confirm acceptance, review Reports 4.4 and 4.5, reconcile CRSE dependencies, and audit other staff produced by the same mapping.

Official FRMT0004 guidance · CALPADS Staff Assignment guidance · Report 4.4 Staff Profile List · Current specifications and code sets