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.

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

30090-0084

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.

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

 

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.

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

Except for Texas School For the Blind and Visually Impaired (227905), Texas School for the Deaf (227906), and the Texas Juvenile Justice Department (227622), each district’s data submission must contain one 040 record for each staff person.

F

1

X

X

 

X

For each LEA's data submission (except for Texas School for the Blind and Visually Impaired, Texas School for the Deaf, and Texas Juvenile Justice Department), staff data must be reported for each staff person.

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

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 "1995", 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 "1996" (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.

04059

10020-0028

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

F

3

 

X

 

X

For each LEA's data submission, staff data must be reported for each teacher.

04060

30040-0042

The Texas School For the Blind and Visually Impaired (227905), the Texas School for the Deaf (227906), and the Texas Juvenile Justice Department (227622) must not submit a 040 record.

F

1

X

X

 

X

The Texas School for the Blind and Visually Impaired, the Texas School for the Deaf, and the Texas Juvenile Justice Department must not report staff data in a submission 1.