040 Context Edits

   

Rule Applies To

Legacy

Edit #

TEDS Rule #

Legacy Edit Rule Text and Business Meaning

Edit
Type

Sub

ESC

District

Campus

Charter

04019

30040-0018

TOTAL-YEARS-PROF-EXPERIENCE should be less than "41".

W

1, 3

X

X

 

X

An employee should have less than 41 total years of professional experience.

04026

 

Former Edit Deleted

           

04033

30040-0014

If there is a value reported for TOTAL-YEARS-PROF-EXPERIENCE and also a value reported for YEARS-EXPERIENCE-IN-DISTRICT, then TOTAL-YEARS-PROF-EXPERIENCE must be greater than or equal to YEARS-EXPERIENCE-IN-DISTRICT.

F

1, 3

X

X

 

X

An employee’s total years of professional experience must be equal to or more than an employee’s years of experience in the district.

04034

30040-0025

If ROLE-ID is "003"-"005", "008", "011"-"013", "018"-"020", "023", "026"-"028", "040"-"042", "054", "060"-"065", "079", or "087", then HIGHEST-DEGREE-LEVEL-CODE should not be "0".

SW

1, 3

X

X

 

X

For a staff person the highest level of education completed should be at least a bachelor’s degree or higher if they serve as one of the following role ids: "003"-"005", "008", "011"-"013", "018"-"020", "023", "026"-"028", "040"-"042", "054", "060"-"065", "079", or "087". These roles generally require that the staff person have a bachelor’s degree at a minimum.

04036

30040-0003

Each character of STAFF-ID must not be the same number.

F

1, 3

X

X

 

X

The Social Security number for a staff person must not be made up of all the same numbers.

04037

30040-0004

The first three characters of STAFF-ID must not be "000" or "666".

F

1, 3

X

X

 

X

The Social Security number for a staff person must not have "000" or "666" as the first three characters.

04038

 

The fourth and fifth characters of STAFF-ID must not be "00".

F

1, 3

X

X

 

X

The Social Security number for a staff person must not have "00" as the fourth and fifth characters.

04039

 

The last four characters of STAFF-ID must not be "0000".

F

1, 3

X

X

 

X

The Social Security number for a staff person must not have "0000" as the last four characters.

04040

30040-0024

FIRST-NAME, LAST-NAME, SEX-CODE, and DATE-OF-BIRTH should not be identical on records reported with two or more different STAFF-IDs.

SW

1, 3

X

X

 

X

Two different staff persons should not be reported with the same first name, last name, sex code, and date of birth.

04041

30040-0022

FIRST-NAME, MIDDLE-NAME, and/or LAST-NAME should not end with " JR", " SR", " I", " II", " III", " IV", " V", " VI" , " VII", " VIII", " IX", or " X".

SW

1, 3

X

X

 

X

For a staff person, the first name, middle name, and/or last name should not end with a space and then characters that would suggest a generation indicator.

04042

 

Former Edit Deleted

           

04043

 

Former Edit Deleted

           

04048

 

The first character of STAFF-ID must be "0"-"8".

F

1, 3

X

X

 

X

The Social Security number for a staff person must have "0"-"8" as the first character.

04049

30040-0006

FIRST-NAME, MIDDLE-NAME, or LAST-NAME must only contain the following characters: A-Z, apostrophe, hyphen, or the space character.

F

1, 3

X

X

 

X

For a staff person, first name, middle name, and last name must only contain the following characters: capital letters A-Z, apostrophe, hyphen, and the space character.

04050

30040-0005

STAFF-ID must be 9 numeric characters.

F

1, 3

X

X

 

X

The Social Security number for a staff person must be nine numeric characters.

04051

 

Former Edit Deleted

           

04052

 

The value of DISTRICT-ID in this record must match the value of DISTRICT-ID on the district's 010 record.

F

1, 3

X

X

 

X

The district id on the 040 record must match the district id on the 010 record.

04053

10020-0009

Each district’s data submission must contain one 040 record for each staff person.

F

1, 3

X

X

 

X

Each district that employees staff must report one 040 record for each staff person employed.

04054

30040-0015

If STAFF-ID matches a STUDENT-ID on a 100 record, then FIRST-NAME, LAST-NAME, and DATE-OF-BIRTH must match FIRST-NAME, LAST-NAME, and DATE-OF-BIRTH on the corresponding 100 record.

F

1, 3

 

X

X

X

If a staff person is at the same time a student (matching Social Security numbers), then the first name, last name, and date of birth must match the student record for the same person.

04055

30040-0002

Each district’s data submission must contain at least one 305 record with a matching STAFF-ID for each staff person submitted on an 040 record.

F

3

X

X

 

X

For submission 3, each teacher (role ids 047 and 087) reported with an 040 staff record must also be reported with a 305 teacher class assignment record.

04056

30040-0016

If the last four characters of DATE-OF-BIRTH are greater than "1994", then TOTAL-YEARS-PROF-EXPERIENCE must be 0 (Staff person is 18 years of age or younger).

F

1, 3

X

X

X

X

If a staff person is 18 years of age or younger then total years of professional experience must be 0.

04057

30040-0017

If TOTAL-YEARS-PROF-EXPERIENCE is greater than 0, then the last four characters of DATE-OF-BIRTH must be less than "1995" (Staff person must be at least 19 years of age or older).

F

1, 3

X

X

X

X

If a staff person has years of professional experience greater than zero, then the staff person must be at least 19 years of age.

04058

 

Former edit deleted.