043 Context Edits

   

Rule Applies To

Legacy

Edit #

TEDS Rule #

Legacy Edit Rule Text and Business Meaning

Edit
Type

Sub

ESC

District

Campus

Charter

04302

30040-0023

The last four characters of DATE-OF-BIRTH should not be less than "1940" or greater than "1999".

SW

1, 3

X

X

 

X

A staff person should be between 16 and 75 years old.

04303

30040-0008

The last four characters of DATE-OF-BIRTH must not be less than "1917" or greater than "2001".

F

1, 3

X

X

 

X

A staff person must be between 14 and 98 years old.

04305

30040-0007

DATE-OF-BIRTH must be a valid date.

F

1, 3

X

X

 

X

Only a valid date must be reported as the date of birth for a staff person.

04306

 

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 043 record must match the district id on the 010 record.

04307

 

The value of STAFF-ID on this record must match the value of STAFF-ID on some 040 record.

F

1, 3

X

X

 

X

The Social Security number reported for a staff person on the 043 record must match a Social Security number reported on the 040 record.

04308

 

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

F

1, 3

X

X

 

X

For every 040 staff record a 043 staff record with a matching Social Security number must be reported.

04309

30040-0009

AMERICAN-INDIAN-ALASKA-NATIVE-CODE, ASIAN-CODE, BLACK-AFRICAN AMERICAN-CODE, NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODE, and WHITE-CODE must not all be 0.

F

1, 3

X

X

 

X

A staff person must be reported with at least one race code.

04312

30040-0038

TX-UNIQUE-STAFF-ID must match an entry in the TSDS Unique ID system.

F

1, 3

X

X

X

X

The TX unique staff id number reported must match a TX unique staff id number in the TSDS Unique ID system.

04313

30040-0039

If TX-UNIQUE-STAFF-ID matches a Unique Id in the TSDS Unique ID system, but NONE of the four major demographics (FIRST-NAME, LAST-NAME, DATE-OF-BIRTH, and STAFF-ID) match the major demographics for that entry in the TSDS Unique ID system, then a fatal error will be issued.

F

1, 3

X

X

X

X

If the TX unique staff id reported matches a TX unique staff id in the TSDS Unique ID system and none of the major demographics (first name, last name, date of birth, and Social Security number) match, the EDIT+ system will not load the data for that staff person.

04314

30040-0040

For this TX-UNIQUE-STAFF-ID, at least one of the following race and ethnicity fields must have a value of “1” in the TSDS Unique ID system: AMERICAN-INDIAN-ALASKA-NATIVE-CODE, ASIAN-CODE, BLACK-AFRICAN AMERICAN-CODE, NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODE, WHITE-CODE, or HISPANIC-LATINO-CODE.

F

1, 3

X

X

X

X

Before PEIMS data can be processed for this staff person, the TSDS Unique ID system must be updated with their most recent race and ethnicity data.

04315

30040-0041

For this TX-UNIQUE-STAFF-ID, SEX-CODE must be “M” or “F” in the TSDS Unique ID system.

F

1, 3

X

X

X

X

Before PEIMS data can be processed for this staff person, the TSDS Unique ID system must be updated with a valid value for sex/gender.

04316

30040-0047

TX-UNIQUE-STAFF-ID must not match TX-UNIQUE-STAFF-ID for any other 043 record reported for this LEA.

F

1, 3

X

X

X

X

A particular Texas unique staff id may only be used for one staff person at an LEA.