FRMT0004

What this error actually means

Labels that make sense to a person—such as “12 years”—are not numeric data. The extract must send only the numeric value allowed by the field definition.

Valid versus invalid

Fields validated

• 7.30 Staff Service Years LEA and other numeric SDEM fields

Recommended correction path

1. 1

   Open the rejected submission detail

   Locate the exact physical row, field number, submitted value, Reporting LEA, SEID, Academic Year, and effective dates.

2. 2

   Read the raw exported value

   Do not rely only on the formatted HR or SIS screen. Inspect spaces, delimiters, zero padding, dates, and local code translations.

3. 3

   Test this rule

   • Inspect the rejected flat-file field.
   • Remove labels, commas, currency signs, and spreadsheet formatting.
   • Confirm whether decimals are permitted for this exact field.
   • Trace the transformation back to HR/SIS so it does not recur.
4. 4

   Confirm correction authority

   HR/personnel staff own authoritative employment and demographic facts; technical staff own mappings and export behavior; the CALPADS operator verifies the submitted representation. Protect confidential personnel data throughout the review.

5. 5

   Correct the responsible source

   Export only the supported numeric representation. Preserve the evidence-supported service-year value rather than stripping characters from an otherwise incorrect calculation.

6. 6

   Resubmit and reconcile downstream records

   Confirm the row posts under the intended SEID and Reporting LEA. Review Staff Profile Report 4.4 and relevant Reports 4.1–4.5; then check whether the same mapping affected other staff, SASS assignments, or CRSE sections.