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. | ||||||||
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. |