SDEM - Staff Demographics
FRMT0004 Invalid Characters For Numeric Field
Data for a numeric field must be a number or a decimal point.
FRMT0009 Invalid column count for file type
Format for invalid column (fields) count based on file type
GERR0001 Required Field Missing
A required field for the submitted Record Type is missing
GERR0002 Value Not Found In Reference Set
The value provided for the field is not a valid value from the CALPADS Code Sets
GERR0007 Code Submitted Outside The Effective Date Range
Code submitted outside the effective date range.
(e.g. you've entered a school entry date that exists BEFORE the student's birth date)
GERR0008 Invalid Transaction Type
The value provided for the field is not a valid CALPADS Transaction Type Code
IVR0106 Invalid SEID
SEID must be a valid SEID in the CCTC file
IVR0613 Effective Start Date greater than Current Date plus six months
Effective Start Date must be less than or equal to current date plus six months
SDEM0006 Invalid Academic Year
Academic Year ID must be a valid academic school year combination and no more than one year in the future
SDEM0009 Invalid Characters In Field
Field must only contain Alphabetic letters, numbers, periods, hyphens and apostrophes.
These letters and characters are valid:
a b c d e f g h i j k l m n o p q r s t y v w x y z
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
1 2 3 4 5 7 8 9 0 . - '
Any other ascii code characters will be rejected. Check for hidden characters.
SDEM0011 Missing Alias Last Name
If Staff Alias First Name is populated Then Staff Alias Last Name must be populated
SDEM0033 Invalid Record Type
Record Type Code must equal SDEM.
SDEM0064 Invalid Effective Start Date - Academic Year Combination
Effective Start Date must be within Academic Year specified
SDEM0106 Invalid SEID
SEID must be a valid SEID in the CCTC file
SDEM0107 Invalid Staff Age
Staff Age must be greater than or equal to 18 and less than 95.
SDEM0109 Invalid Staff Ethnicity Missing Indicator And Staff Hispanic Ethnicity Indicator Combination
If Staff Hispanic Ethnicity Indicator is populated, then staff Ethnicity Missing Indicator must be equal to N or blank; ELSE, Staff Ethnicity Missing Indicator must equal Y AND Staff Hispanic Ethnicity Indicator must be NULL
SDEM0110 Invalid Staff Race Missing Indicator And Staff Race Code Combination
If one or more of the Staff Race Codes are populated, then Staff Race Missing Indicator must be equal to N or blank; ELSE, Staff Race Missing Indicator must be equal to Y AND all Staff Race Code values must be NULL.
SDEM0111 Staff Employment Start Date Less Than Birth Date Plus 18
Staff Employment Start Date must be greater than Staff Birth Date plus 18 years
SDEM0112 Staff Employment Start Date Greater Than Current Date Plus Six Months
Staff Employment Start Date must be less than or equal to current date plus six months
SDEM0113 Staff Service Years LEA Greater Than Staff Service Years Total
Staff Service Years LEA must be less or equal to Staff Service Years Total
SDEM0114 Staff Employment End Date Less Than Staff Employment Start Date
Staff Employment End Date must be greater than or equal to Staff Employment Start Date
SDEM0115 Staff Service Years LEA Total Greater Than Staff Age Minus 17
Staff Service Years LEA Total must be less than or equal to Staff Age minus 17
SDEM0116 Duplicate Effective Start Date In The File
Two or more records exist in the submission with the same Effective Start Date
SDEM0196 Mismatch Of SEID Demographics For Staff Information Update
Staff Gender Code and Staff Date of Birth Year must equal existing ODS Staff Gender Code and Staff Date of Birth Year Or Staff Legal First Name and Staff Legal Last Name must equal existing ODS Staff Legal First Name and Staff Legal Last Name in the latest SDEM record
SDEM0200 Reporting LEA Not Open During Effective Period
Reporting LEA must be open during the effective date period.
SDEM0218 SDEM - Staff Demographics
All associated Staff Assignment and Course Section records must be deleted before deleting the last remaining Staff Demographic record
SDEM0221 Staff Service Years Must Be One Or Greater Even If The Staff Member Has Less Than One Year Of Total Service
Staff Service Years LEA (7.30) and Staff Service Years Total (7.31) must be equal to one or more