Rule Applies To | ||||||||
---|---|---|---|---|---|---|---|---|
Legacy Edit # |
TEDS Rule # |
Legacy Edit Rule Text and Business Meaning |
Edit |
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. |