400 Context Edits

   

Rule Applies To

Legacy

Edit #

TEDS Rule #

Legacy Edit Rule Text and Business Meaning

Edit
Type

Sub

ESC

District

Campus

Charter

40002

42400-0002

CAMPUS-ID-OF-ENROLLMENT must match an entry registered with the TEA as an active instructional campus in the reporting district ending in "001" - "698".

F

3

 

X

X

X

A student’s attendance campus id of enrollment must be registered with the TEA as an active instructional campus in the reporting LEA and must end in "001" - "698".

40003

42400-0040

For each instance of STUDENT-ID, GRADE-LEVEL-CODE should be found in the grade range registered with the TEA for the campus shown in CAMPUS-ID-OF-ENROLLMENT, unless there is at least one matching 405 record.

SW

3

 

X

X

X

Student attendance generally should be in a grade level found in the grade range for the campus id reported as registered with the TEA, unless the student has special education attendance in an instructional setting other than "mainstream".

40004

42400-0059

For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT should not be greater than "040".

W

3

 

X

X

X

Each particular campus id of enrollment, instructional track, and reporting period should have less than 40 days of instruction.

40005

42400-0048

For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT should not be less than "024".

W

3

 

X

X

X

Each particular campus id of enrollment, instructional track, and reporting period generally should have at least 24 days of instruction.

40007

42400-0005

The last character of TOTAL-DAYS-ABSENT must be either "0" or "5".

F

3

 

X

X

X

A student’s total days absent must be reported as either full or half days.

40009

42400-0006

The last character of TOTAL-INELIGIBLE-DAYS-PRESENT must be either "0" or "5".

F

3

 

X

X

X

A student’s total ineligible days present must be reported as either full or half days.

40010

42400-0033

For a particular CAMPUS-ID-OF-ENROLLMENT, if there are any students whose sum of TOTAL-ELIGIBLE-DAYS-PRESENT and TOTAL-DAYS-ABSENT for all reporting periods is greater than "1800", (180 days), then a message showing the total number of students in this category will be issued asking for verification.

W

3

 

X

X

X

Students should generally not be reported with more than 180 days of enrollment.

40011

42400-0012

For each instance of STUDENT-ID, TOTAL-ELIGIBLE-DAYS-PRESENT must not be greater than NUMBER-DAYS-TAUGHT less TOTAL-DAYS-ABSENT less TOTAL-INELIGIBLE-DAYS-PRESENT.

F

3

 

X

X

X

A student cannot be reported with more attendance than there are days taught in a reporting period.

40012

42400-0007

The last character of TOTAL-ELIGIBLE-DAYS-PRESENT must be either "0" or "5".

F

3

 

X

X

X

A student’s total eligible days present must be reported as either full or half days.

40013

42400-0013

For each instance of STUDENT-ID, TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT.

F

3

 

X

X

X

A student’s total bilingual/ESL eligible days present must not be more than total eligible days present.

40014

42401-0001

The last character of TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT must be either "0" or "5".

F

3

 

X

X

X

A student’s total bilingual/ESL eligible days present must be reported as either full or half days.

40015

42400-0014

For each instance of STUDENT-ID, TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT.

F

3

 

X

X

X

A student’s total Pregnancy Related Services eligible days present must not be more than total eligible days present.

40016

42401-0002

The last character of TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT must be either "0" or "5".

F

3

 

X

X

X

A student’s total Pregnancy Related Services eligible days present must be reported as either full or half days.

40017

42400-0015

For each instance of STUDENT-ID, TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT.

F

3

 

X

X

X

A student’s total special education mainstream eligible days present must not be more than total eligible days present.

40018

42400-0034

For each instance of STUDENT-ID, the sum of TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT plus all instances of ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING (from all matching 405 records where INSTRUCTIONAL-SETTING-CODE is not "00") must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT.

F

3

 

X

X

X

A student cannot be reported with more special education attendance than they are reported with regular attendance.

40020

42401-0003

The last character of TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT must be either "0" or "5".

F

3

 

X

X

X

A student’s total special education mainstream eligible days present must be reported as either full or half days.

40026

42401-0008

For a particular STUDENT-ID where TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT is not "0000", SEX-CODE must be "F" on the 101 record with a matching STUDENT-ID.

F

3

 

X

X

X

Pregnancy related services total eligible days present may only be reported for female students.

40027

42400-0047

For a particular REPORTING-PERIOD-INDICATOR-CODE, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and GRADE-LEVEL-CODE, the sum of TOTAL-DAYS-ABSENT should not be "0".

SW

3

 

X

X

X

Generally at least one student will be reported with an absence(s) in a particular campus id of enrollment, instructional track, reporting period, and grade level.

40029

42401-0004

For each instance of STUDENT-ID where GRADE-LEVEL-CODE is "EE", TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT must be "0000".

F

3

 

X

X

X

Students in grade "EE" must not be reported with Bilingual/ESL program attendance.

40030

42401-0009

For each instance of STUDENT-ID where GRADE-LEVEL-CODE is "EE", "PK", "KG", "01", "02", or "03", TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT should be "0000".

SW

3

 

X

X

X

Students in grade level "EE"-"03" should not be reported with pregnancy related services attendance.

40031

42400-0016

For each instance of STUDENT-ID, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT, TOTAL-INELIGIBLE-DAYS-PRESENT, and TOTAL-DAYS-ABSENT must be greater than 0.

F

3

 

X

X

X

For students reported with attendance, at least one of the fields total eligible days present, total ineligible days present, or total days absent must be greater than 0.

40032

42400-0044

For a particular STUDENT-ID, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT for all reporting periods should not be greater than "1800", (180 days).

SW

3

 

X

X

X

A sum of all total eligible days present for a particular student, across all reporting periods, generally should not be greater than 180 days.

40033

42400-0046

For a particular STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-DAYS-ABSENT should not be greater than "0400" (40 days).

W

3

 

X

X

X

For a student in a particular reporting period, the sum of their total eligible days present and total ineligible days present and total days absent generally should not be more than 40 days.

40036

42400-0003

The first six characters of CAMPUS-ID-OF-ENROLLMENT must not be a district registered with the TEA as an ESC.

F

3

 

X

X

X

A student’s campus id of enrollment must not be an ESC.

40037

 

CAMPUS-ID-OF-ENROLLMENT must match CAMPUS-ID on an 020 record.

F

3

 

X

X

X

A student’s campus id of enrollment on a 400 record must match a campus id on a 020 record.

40038

42400-0017

For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE and REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT must be identical on all records.

F

3

 

X

X

X

Number days taught must be the same on all attendance records with the same campus id of enrollment, instructional track, and reporting period.

40040

42400-0045

For a particular STUDENT-ID, TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-DAYS-ABSENT should not be greater than "2000" (200 days).

SW

3

 

X

X

X

The sum of all total eligible days present, total ineligible days present, and total days absent for a particular student, across all reporting periods, should not be more than 200 days.

40041

42400-0050

For a particular CAMPUS-ID-OF-ENROLLMENT that has students in all six reporting periods, the sum of TOTAL-DAYS-ABSENT should be greater than 0. A special warning message showing the total number of students with no absences will be issued asking for verification.

SW

3

 

X

X

X

For each campus id of enrollment, where students are reported in all six reporting periods, there should generally not be perfect attendance reported for that campus.

40043

42400-0043

If age is less than 5 and GRADE-LEVEL-CODE is always greater than or equal to "KG", then TOTAL-ELIGIBLE-DAYS-PRESENT should be "0000".

SW

3

 

X

X

X

Students who are less than 5 years of age on September 1 and are reported in grade "KG" or higher are generally not eligible for attendance.

40047

41163-0044

If PRIMARY-DISABILITY-CODE is "00", then MULTIPLY-DISABLED-INDICATOR-CODE must be "0".

F

3

 

X

X

X

To be reported as multiply disabled, a student must be reported with a primary disability.

40048

41163-0045

If MULTIPLY-DISABLED-INDICATOR-CODE is "1", then PRIMARY-DISABILITY-CODE must not be "00".

F

3

 

X

X

X

A primary disability must be reported if a student is reported as multiply disabled.

40049

42400-0037

If TOTAL-ELIGIBLE-DAYS-PRESENT is greater than "0000" and PRIMARY-DISABILITY-CODE is not "00", then there should be at least one 405 record with a matching STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, and REPORTING-PERIOD-INDICATOR-CODE or at least one 400 record with a matching STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, and REPORTING-PERIOD-INDICATOR-CODE where TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT is not "0000".

SW

3

 

X

X

X

If a student is reported with eligible attendance and a primary disability, then that student should be reported with special education attendance in the same campus id of enrollment and reporting period.

40050

42400-0038

There should be at least one record where MULTIPLY-DISABLED-INDICATOR-CODE is not "0".

W

3

 

X

X

X

Generally, at least one student in a LEA should be reported as multiply disabled.

40052

42400-0023

For a particular STUDENT-ID, if September 1 age is 26 or greater, then all instances of TOTAL-ELIGIBLE-DAYS-PRESENT must be "0000".

F

3

 

X

X

X

A student's eligibility for attendance funding ends when they are age 26 on September 1.

40053

42401-0010

For each instance of STUDENT-ID where TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT is greater than "0000", PRIMARY-DISABILITY-CODE must not be "00".

F

3

 

X

X

X

A student who is reported with mainstream eligible days present greater than 0 must also be reported with a primary disability that is not "00".

40054

42401-0012

For each instance of STUDENT-ID, if TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT is "0000", and there is not a matching 405 record, then PRIMARY-DISABILITY-CODE should be "00".

SW

3

 

X

X

X

A primary disability should not be reported for a student unless there is special education attendance reported.

40055

42400-0035

For a particular STUDENT-ID, the sum of all instances of TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT must be greater than or equal to "0005".

F

3

 

X

X

X

Each student must be reported with at least a half day of attendance between total eligible days present and total ineligible days present.

40056

42400-0039

If CAMPUS-ID-OF-ENROLLMENT is a campus registered with the TEA as a JJAEP or a DAEP, then there should be a 425 record with a matching STUDENT-ID.

SW

3

 

X

X

X

If a student's attendance is reported with a campus id of enrollment that is a JJAEP or a DAEP, then the student should also have a disciplinary action reported.

40058

42400-0001

For a particular STUDENT-ID, there must be a 101 record with a matching STUDENT-ID.

F

3

 

X

X

X

For each 400 attendance record reported, there must be a 101 student demographic record reported for the student.

40059

42400-0036

For a particular STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, REPORTING-PERIOD-INDICATOR-CODE, and INSTRUCTIONAL-TRACK-INDICATOR-CODE, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-DAYS-ABSENT must not be greater than NUMBER-DAYS-TAUGHT.

F

3

 

X

X

X

For a student, and particular campus id of enrollment, instructional track, and reporting period, there cannot be more attendance reported than there are days taught in the reporting period.

40060

 

The value of DISTRICT-ID in this record must match the value of DISTRICT-ID on the district's 010 record.

F

3

 

X

X

X

The district id on the 400 record must match the district id on the 010 record.

40061

42405-0005

For a particular STUDENT-ID, if September 1 age is greater than 21, then no 405 record can be reported.

F

3

 

X

X

X

Special education attendance must not be reported for students over 21 years old on September 1.

40062

42401-0011

For a particular STUDENT-ID, if September 1 age is greater than 21, then TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT must not be greater than 0.

F

3

 

X

X

X

Students age 22 and older on September 1 must not report more total eligible days present than reported for special education mainstream attendance.

40063

42400-0031

If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then NUMBER-DAYS-TAUGHT must not be greater than "045" for reporting periods 1–5 for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE

F

3

 

X

X

X

Except for JJAEP campuses, a campus may not have number days taught greater than 45 in a reporting period for the first five reporting periods.

40064

42400-0032

If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then NUMBER-DAYS-TAUGHT must not be greater than "090" for reporting period 6 for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE.

F

3

 

X

X

X

Except for JJAEP campuses, a campus may not have number days taught greater than 90 in the sixth reporting period.

40065

42400-0011

REPORTING-PERIOD-INDICATOR-CODE must be "1" – "6".

F

3

 

X

X

X

For a student reported with attendance in submission 3, the reporting period must be "1" - "6".

40067

42400-0026

If GRADE-LEVEL-CODE is "PK" and TOTAL-INELIGIBLE-DAYS-PRESENT is greater than 0, then PRIMARY-PK-FUNDING-SOURCE-CODE should not be blank.

SW

3

 

X

X

X

A pre-kindergarten student who is reported with ineligible days present should also be reported with a primary PK funding source code.

40068

42400-0028

If GRADE-LEVEL-CODE is "PK" and PK-PROGRAM-TYPE-CODE is "01" or "03", then PRIMARY-PK-FUNDING-SOURCE-CODE should be blank.

SW

3

 

X

X

X

The primary PK funding source code should be blank for an eligible pre-kindergarten student who participates in a half day PK program or is a half day PK program and also receives special education services.

40069

42400-0029

If GRADE-LEVEL-CODE is "PK" and PK-PROGRAM-TYPE-CODE IS "02", "04", or "05" then PRIMARY-PK-FUNDING-SOURCE-CODE must not be blank.

F

3

 

X

X

X

The primary PK funding source code is only reported for pre-kindergarten students when a student is funded for half-day but attends full-day, or the PK student is ineligible for funding.

40070

42400-0030

If GRADE-LEVEL-CODE is "PK" and SECONDARY-PK-FUNDING-SOURCE-CODE is not blank then PRIMARY-PK-FUNDING-SOURCE-CODE must not be blank.

F

3

 

X

X

X

For a pre-kindergarten student, a primary PK funding source code must be reported if a secondary PK funding source code is reported.

40071

42400-0021

If GRADE-LEVEL-CODE is NOT "PK", then PK-PROGRAM-TYPE-CODE, PRIMARY-PK-FUNDING-SOURCE-CODE, and SECONDARY-PK-FUNDING-SOURCE-CODE must be blank.

F

3

 

X

X

X

The PK program type code, primary PK funding source code, and secondary PK funding source code must be blank if a student is not reported in grade level PK.

40072

42400-0027

If GRADE-LEVEL-CODE is "PK", then PK-PROGRAM-TYPE-CODE must not be blank or "00".

F

3

 

X

X

X

A "PK" student must be reported with a PK program type code other than "00".

40073

42400-0060

If DISTRICT-ID is "019907", "101912", or "221801", then there must be at least one 400 STUDENT – BASIC ATTENDANCE record where CAMPUS-ID-OF-ENROLLMENT is "019907005", "101912100", "221801022" respectively.

F

3

 

X

 

X

The Texas Virtual School Network Online Schools program requires that the approved campuses report attendance data as instructed in the Student Attendance Accounting Handbook.

40074

42401-0005

For a particular STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT is greater than "0000", then LEP-INDICATOR-CODE must be "1".

F

3

 

X

X

X

Only LEP students can be reported with bilingual or ESL attendance.

40075

42401-0006

For a particular STUDENT-ID and CAMPUS-ID-OF-ENROLLMENT, if the sum of all TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT is "0000", then LEP-INDICATOR-CODE should not be "1" on any of these 400 records.

SW

3

 

X

X

X

A student who is reported without bilingual or ESL attendance should not be reported as LEP unless the parent has refused the bilingual or ESL services for the student.

40077

42400-0064

If DISTRICT-ID matches the Texas School for the Deaf (227906) or the Texas School for the Blind and Visually Impaired (227905), then the sum of TOTAL-INELIGIBLE-DAYS-PRESENT and TOTAL-DAYS-ABSENT must be greater than "0000".

F

3

 

X

   

Students enrolled in the TSD and TSBVI must be reported with total ineligible days present plus total days absent greater than zero (0).

40078

42400-0065

If DISTRICT-ID matches the Texas School for the Deaf (227906), or the Texas School for the Blind and Visually Impaired (227905), then TOTAL-ELIGIBLE-DAYS-PRESENT, TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT, TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT, and TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT must all be "0000".

F

3

 

X

   

Students enrolled in the TSD and TSBVI must not be reported with total eligible days present, total eligible pregnancy related services days present, or total eligible special education mainstream days present greater than zero (0).

40079

42401-0013

If DISTRICT-ID matches the Texas Juvenile Justice Department (227622), then TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT, TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT, and TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT must all be "0000".

F

3

 

X

   

Students enrolled in the TJJD must not be reported with total eligible bilingual/ESL days present, total eligible pregnancy related services days present, or total eligible special education mainstream days present greater than zero (0).

40080

42400-0066

If GRADE-LEVEL-CODE is "PK" and TOTAL-ELIGIBLE-DAYS-PRESENT is greater than "0000", then either LEP-INDICATOR-CODE should be "1", ECONOMIC-DISADVANTAGE-CODE should not be "00", MILITARY-CONNECTED-STUDENT-CODE should be "4", FOSTER-CARE-INDICATOR-CODE should be "1" or "2", or HOMELESS-STATUS-CODE should not be "0".

SW

3

 

X

X

X

A student that is reported with eligible attendance in grade level "PK" should be reported as one or more of the following: LEP, economically disadvantaged, military connected, a current or former foster care child, or homeless.