Tagged with: STAFF

FRMT0001

Field length does not match Calpads File Specifications

FRMT0002

Date format does not match Calpads File Specifications.

Specifically, the staff member's birth date must by an 8 digit number following the CCYYMMDD format.

A staff member born on March 21, 1968, for example, would be correct if it was 19680321.

FRMT0004

Data for a numeric field must be a number or a decimal point.

FRMT0004

Data for a numeric field must be a number or a decimal point.

GERR0001

A required field for the submitted Record Type is missing

GERR0001

A required field for the submitted Record Type is missing

GERR0002

The value provided for the field is not a valid value from the CALPADS Code Sets

GERR0002

The value provided for the field is not a valid value from the CALPADS Code Sets

GERR0007

Code submitted outside the effective date range

GERR0007

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

The value provided for the field is not a valid CALPADS Transaction Type Code

GERR0008

The value provided for the field is not a valid CALPADS Transaction Type Code

SASS0001

Reporting LEA must equal institution identifier of submitter User ID

SASS0006

Academic Year ID must be a valid academic school year combination and no more than one year in the future

SASS0009

Field must only contain Alphabetic letters, numbers, periods, hyphens and apostrophes.

Any other ascii code characters will be rejected.  Check for hidden characters.

SASS0033

Record Type Code must equal SASS

SASS0106

The educator's SEID # must be a valid SEID #.

SASS0118

Staff Job Classification FTE Percentage must be greater than or equal to 1

SASS0119

Staff Job Classification FTE Percentage must be Less Than 200%.

SASS0120

If Staff Job Classification Code = 10 or 11 OR 25, then one or more of the Non Classroom Based Job Assignment Codes must be populated

SASS0163

If Staff Job Classification Code = 26 then School of Assignment must be a charter school (CDS)

SASS0197

Staff Gender Code and Staff Date of Birth Year must equal existing ODS Staff Gender Code and Staff Date of Birth Year in the latest SDEM record

SASS0198

School of Assignment must not be an NPS school

SASS0219

Staff Job Classification Code and Non Classroom Based Job Assignment Code must be a valid combination as defined in the CALPADS Valid Code Combinations document

SASS0256

Only one Staff Assignment (SASS) record may exist in the file with the same Academic Year ID, SEID, School of Assignment, and Job Classification Code

SASS0257

If any Nonclassroom Based or Support Assignment is "Employee on Leave", then all other Nonclassroom Based or Support Assignment fields must be blank.

SDEM0006

Academic Year ID must be a valid academic school year combination and no more than one year in the future

SDEM0009

Field must only contain Alphabetic letters, numbers, periods, hyphens and apostrophes.

Any other ascii code characters will be rejected.  Check for hidden characters.

SDEM0011

If Staff Alias First Name is populated Then Staff Alias Last Name must be populated

SDEM0033

Record Type Code must equal SDEM.

SDEM0064

Effective Start Date must be within Academic Year specified

SDEM0106

SEID must be a valid SEID in the CCTC file

SDEM0107

Staff Age must be greater than or equal to 18 and less than 95.

SDEM0109

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

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 must be greater than Staff Birth Date plus 18 years

SDEM0112

Staff Employment Start Date must be less than or equal to current date plus six months

SDEM0113

Staff Service Years LEA must be less or equal to Staff Service Years Total

SDEM0114

Staff Employment End Date must be greater than or equal to Staff Employment Start Date

SDEM0115

Staff Service Years LEA Total must be less than or equal to Staff Age minus 17

SDEM0116

Two or more records exist in the submission with the same Effective Start Date

SDEM0196

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 must be open during the effective date period.

SDEM0218

All associated Staff Assignment and Course Section records must be deleted before deleting the last remaining Staff Demographic record

SDEM0221

Staff Service Years LEA (7.30) and Staff Service Years Total (7.31) must be equal to one or more