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

7.04 Effective Start Date 7.05 Effective End Date 7.16 Staff Birth Date 7.28 Staff Employment Start Date 7.29 Staff Employment End Date

Recommended correction path

Suggested resolution

CALPADS SDEM 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:

  • 7.04 Effective Start Date
  • 7.05 Effective End Date
  • 7.16 Staff Birth Date
  • 7.28 Staff Employment Start Date
  • 7.29 Staff Employment End Date

SDLA Flowchart: follow the staff data from source to certification

1 · Authoritative personnel evidenceHR, personnel, payroll, credentialing, and staff-provided records establish the supported facts.
2 · Local reconciliationResolve identity, SEID, employment dates, demographics, service history, and ownership across the systems that hold them.
3 · SIS or integration extractTranslate local values into the current 31-field SDEM layout, CALPADS code sets, and effective-date rules.
4 · CALPADS SDEM historyPost the supported staff demographic record and inspect the accepted effective-dated history under the correct SEID and LEA.
5 · Downstream review and Fall 2 certificationReconcile SASS and CRSE dependencies, Reports 4.1–4.5, Census Day inclusion, and certification totals.

Recommended correction path

  1. 1

    Preserve the rejected row

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

  2. 2

    Locate the field defect

    Compare the complete field list with the current file layout, length, type, date, delimiter, and character rules.

  3. 3

    Trace the export path

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

  4. 4

    Correct the authoritative source

    Repair the source value or mapping so the next extract does not reproduce the defect.

  5. 5

    Regenerate and regression-check

    Upload a scoped extract and inspect other rows created by the same rule.

2026–27 Fall 2 calendar

Before Census DayReconcile HR/personnel, SEIDs, SDEM histories, SASS assignments, course records, and local mappings.
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 calendar before acting because dates can change.

Before closing the correction

  • Confirm the accepted SDEM history under the intended SEID and Reporting LEA.
  • Compare CALPADS Report 4.4 with authorized HR/personnel evidence.
  • Reconcile related SASS and CRSE records and Fall 2 Reports 4.1–4.5.
  • Check other staff affected by the same source, mapping, or interface rule.

Official references and practical support