043 Context Edits

   

Rule Applies To

Legacy

Edit #

TEDS Rule #

Legacy Edit Rule Text and Business Meaning

Edit
Type

Sub

ESC

District

Campus

Charter

04301

 

Former Edit Deleted

SW

1, 3

X

X

 

X

04302

30040-0023

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

SW

1, 3

X

X

 

X

The birth year for a staff person should be between "1942 and "1994".

04303

30040-0008

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

F

1, 3

X

X

 

X

The birth year for a staff person must not be greater than "2001".

04304

 

The last four characters of DATE-OF-BIRTH must not be less than "1918".

F

1, 3

X

X

 

X

The birth year for a staff person must not be less than "1918".

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.

04310

 

Former Edit Deleted

           

04311

 

Former Edit Deleted

           

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.