Skip to main content

CALPADS error brief · FRMT

FRMT0002

Wrong date format
Severity Fatal
Error type Input Validation
Record type FRMT

Official CALPADS rule

What CALPADS is rejecting

Date format does not match CALPADS File Specifications (CFS)

Focus fields

Fields validated

8.11 Staff Birth Date

Recommended correction path

Suggested resolution

CALPADS SASS correction guide · Fatal input validation

FRMT0002: Wrong date format

Date format does not match CALPADS File Specifications (CFS)

Official CALPADS rule

Severity: Fatal   Type: Input Validation

Fields validated:

  • 8.11 Staff Birth Date

SDLA Flowchart: debug the hierarchy from the top

1 · HR, personnel, credentialing, and local systemsConfirm the staff member, employment evidence, SEID, position, site, job classification, FTE, and assignment details in the systems responsible for those facts.
2 · SDEM staff identity and employment history Prerequisite gateThe correct SDEM record must exist and process successfully under the same Reporting LEA and SEID before a dependent assignment can be trusted.
3 · SASS staff assignment — current debugging levelValidate the same SEID plus Academic Year ID, School of Assignment, Staff Job Classification Code, FTE percentage, and any required nonclassroom assignment codes.
4 · CRSE teaching assignmentsFor classroom staff, course sections must connect to a qualifying SASS assignment for the same person, school, and academic year.
5 · SCSE enrollment and Fall 2 reviewOnly after upstream staff and course records are sound should the team reconcile student-section records, reports, and certification results.

One person does not always mean one assignment record

SDEMEstablishes the staff member’s identity and employment history.
SASSOne or more records may describe assignments by school and job classification.
CRSEEach applicable course section connects to the appropriate staff assignment.
SCSEEach student-course enrollment connects downstream to the section.

Illustrative principle: a principal who also teaches may require more than one SASS job classification. Do not create duplicate SASS rows with the same primary-key combination.

Recommended correction path

  1. 1

    Preserve the rejected row

    Capture the submission ID, row number, export time, and exact SASS row before editing.

  2. 2

    Clear the prerequisite identity check

    Confirm that the row belongs to an accepted SDEM identity under the same Reporting LEA and SEID.

  3. 3

    Locate the structural defect

    Compare the complete 21-field SASS layout, field lengths, data types, date formats, delimiters, and column count with the current specifications.

  4. 4

    Trace the export path

    Determine whether HR, the SIS, an integration, or a report definition transformed the value or shifted the columns.

  5. 5

    Correct the repeatable source

    Repair the source value, mapping, or export definition rather than hand-editing only one upload row.

  6. 6

    Regenerate and regression-check

    Upload a scoped file, confirm SASS acceptance, and inspect other rows created by the same export rule.

2026–27 Fall 2 working calendar

Before Census DayReconcile SDEM identities, employment coverage, SASS assignments, school mappings, classifications, FTE, and course dependencies.
Fall 2 Census Day and opening of the official submission window.
CDE’s recommended date for reaching zero Fall 2 errors.
Certification deadline. Fall 2 has no amendment window.

Verify the official CDE reporting calendar before acting because dates can change.

Before closing the correction

  • Confirm the accepted SDEM identity and employment history under the intended Reporting LEA and SEID.
  • Confirm the accepted SASS record under the intended academic year, school, and job classification.
  • Reconcile applicable CRSE records and Fall 2 staff reports after the upstream correction.
  • Check other staff records created by the same HR, SIS, integration, or extract rule.

Official references and practical support