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

What this error actually means

This is a representation error. CALPADS evaluates the literal file value, not the familiar date shown in HR or SIS. After format is repaired, identity and chronological accuracy still matter.

Valid, invalid, and unsafe responses

SituationValue or conditionInterpretation
Valid format19850609Eight digits: year, month, day.
Invalid06/09/1985Slashes and month-first order.
Invalid1985-06-09Hyphens create ten characters.
Invalid date19850230Correct shape but impossible calendar date.

Fields and records evaluated

  • 8.11 Staff Birth Date

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 8.11 in the raw SASS row.
    • Verify the staff identity and authorized birth-date evidence.
    • Prevent spreadsheet locale conversion and timestamps.
    • Check whether SDEM and SASS describe the same educator.
  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

    Format the verified birth date as CCYYMMDD through the source/export; do not change the underlying date merely to pass formatting.

  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 FRMT0002 guidance · CALPADS Staff Assignment guidance · Report 4.4 Staff Profile List · Current specifications and code sets