The following extensions are included in InterchangeStudentAttendanceExtension:


BasicReportingPeriodAttendanceExtension

SpecialProgramsReportingPeriodAttendanceExtension

StudentTruancyExtension


Submissions:

(3) = Summer PEIMS (Submission 3)

(4) = Extended PEIMS (Submission 4)


* Aeries Table.Fields that have an asterisk must be mapped on Texas State Reporting > Code Translations.


  • (4) This interchange is only extracted for schools offering ADSY.
  • (4) See Referential Integrity for Attendance in PEIMS Submission 4
  • 42400-0067: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE reported on the StudentAttendanceExtension, there must be a Calendar ReportingPeriodExtension with a matching CAMPUS-ID, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • 42405-0003: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT reported on the StudentAttendanceExtension, there must be Special Education Attendance with matching CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • (4) 42405-0031: For each special education attendance data item, there must be a matching attendance data item.
  • 42505-0003: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT, there must be Flexible Attendance with matching CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • 42400-000A: The combination of the following fields must be unique for each Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE.
  • (4) 42400-000C: For Attendance the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT, GRADE-LEVEL-CODE, TOTAL-DAYS-ABSENT, TOTAL-ELIGIBLE-DAYS-PRESENT, RS-TOTAL-ELIGIBLE-DAYS-PRESENT, and RA-TOTAL-ELIGIBLE-DAYS-PRESENT.


BasicReportingPeriodAttendanceExtension

SubmissionElement ID
(Code Table)
Data ElementAeries Table.FieldAeries PageLabel
(3) (4) E1523

TX-UNIQUE-STUDENT-IDSTU.CIDDemographics > Student Data 2Unique ID
<BasicReportingPeriodAttendanceExtension>
<TX-StudentReference>
<StudentIdentity>
<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>
</StudentIdentity>
</TX-StudentReference>
</BasicReportingPeriodAttendanceExtension>

where UUUUUUUUUU = STU.CID
(3) (4)E0782

CAMPUS-ID-OF-ENROLLMENTLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus
<BasicReportingPeriodAttendanceExtension>
<TX-CampusIdOfEnrollment>CCCDDDSSS</TX-CampusIdOfEnrollment>
</BasicReportingPeriodAttendanceExtension>

where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
Rules (FATAL):
  • 42400-0031: If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 1-5, then NUMBER-DAYS-TAUGHT must not be greater than 45.
  • 42400-0032: If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 6, then NUMBER-DAYS-TAUGHT must not be greater than 90.
  • 40100-0196: If NEW-TECH-INDICATOR-CODE is 1, then the student must be reported with at least some Attendance or Flexible Attendance in a CAMPUS-ID-OF-ENROLLMENT that has entered into an agreement with the New Tech Network to operate a New Tech Network campus.

Special Warnings:

  • 10020-0017: For each campus registered with TEA as an active regular, JJAEP, or alternative instructional campus, there should be Attendance and/or Flexible Attendance reported with a matching CAMPUS-ID-OF-ENROLLMENT.
  • 42400-0039: If CAMPUS-ID-OF-ENROLLMENT is a campus registered with TEA as a JJAEP or a DAEP, then there should be a DisciplineAction with a matching TX-UNIQUE-STUDENT-ID.
(3) (4)E1085 (C188)

ATTENDANCE-EVENT-INDICATOR01-Regular
<BasicReportingPeriodAttendanceExtension>
<TX-AttendanceEventIndicator>XX</TX-AttendanceEventIndicator>
</BasicReportingPeriodAttendanceExtension>

where XX = 01
For BasicReportingPeriodAttendanceExtension, the AttendanceEventIndicator is always 01.
Rules (FATAL):
  • 42400-0077: For Submission 4, ATTENDANCE-EVENT-INDICATOR must be 01 (Regular).
(3) (4)E0975

INSTRUCTIONAL-TRACK-INDICATOR-CODEARS.TRStudent Attendance Details Report
ATT.TRAttendanceTrack Code

<BasicReportingPeriodAttendanceExtension>

<TX-InstructionalTrack>XX</TX-InstructionalTrack>

</BasicReportingPeriodAttendanceExtension>


where XX = ARS.TR, which is populated by the ATT.TR value at the end of each Reporting Period the report was run for.
Alpha tracks are automatically converted to two-digit numeric codes (i.e., A = 01, B = 02, etc.)
(3) (4) E0934 (C130)

REPORTING-PERIOD-INDICATOR-CODEARS.RPStudent Attendance Details Report

<BasicReportingPeriodAttendanceExtension>

<TX-ReportingPeriod>P</TX-ReportingPeriod>

</BasicReportingPeriodAttendanceExtension>


where P = ARS.RP
ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected. The reporting periods that have been recomputed are included.
Rules (FATAL):
  • (4) 10200-0061/42400-0075: For Submission 4, REPORTING-PERIOD-INDICATOR-CODE must be 9.
  • (4) 40110-0222: If ADDITIONAL-DAYS-PROGRAM-PARTICIPATION-INDICATOR-CODE is 1, the student must be reported with Attendance for REPORTING-PERIOD-INDICATOR-CODE 9.
  • (4) 42400-0076/42401-0018: If REPORTING-PERIOD-INDICATOR-CODE is 9, the student should be reported with ADDITIONAL-DAYS-PROGRAM-PARTICIPATION-INDICATOR-CODE 1.
  • (3) 42400-0031: If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 1-5, then NUMBER-DAYS-TAUGHT must not be greater than 45.
  • (3) 42400-0032: If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 6, then NUMBER-DAYS-TAUGHT must not be greater than 90.
  • (3) 40100-0069: If AS-OF-STATUS-CODE is I (i.e., not enrolled on final day of school year) and if the student has attendance where REPORTING-PERIOD-INDICATOR-CODE is 6, then NUMBER-DAYS-TAUGHT on the student’s attendance must be greater than TOTAL-DAYS-ABSENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-ELIGIBLE-DAYS-PRESENT.
  • (3) 42400-0011: REPORTING-PERIOD-INDICATOR-CODE must be 1-6.

Special Warnings:

  • (3) 40100-0075: If AS-OF-STATUS-CODE is H, the student should report Attendance or Flexible Attendance for REPORTING-PERIOD-INDICATOR-CODE 6.
  • (3) 40110-0176: For each grade 09-12 student reporting Attendance or Flexible Attendance in a REPORTING-PERIOD-INDICATOR-CODE greater than 2 who is not in Special Education, a StudentSectionAssociation should be reported with a matching TX-UNIQUE-STUDENT-ID.
(3) (4) E0935

NUMBER-DAYS-TAUGHTARP.DTAttendance Reporting PeriodsTotal Days

<BasicReportingPeriodAttendanceExtension>

<TX-NumberDaysTaught>nn</TX-NumberDaysTaught>

</BasicReportingPeriodAttendanceExtension>


where nn = ARP.DT
Rules (FATAL):
  • 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 Attendance.
  • (3) 42400-0031: If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 1-5, then NUMBER-DAYS-TAUGHT must not be greater than 45.
  • (3) 42400-0032: If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 6, then NUMBER-DAYS-TAUGHT must not be greater than 90.
  • (3) 42400-0036: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, REPORTING-PERIOD-INDICATOR-CODE, and INSTRUCTIONAL-TRACK-INDICATOR-CODE, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-DAYS-ABSENT must not be greater than NUMBER-DAYS-TAUGHT.
  • 42400-0069: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, the NUMBER-DAYS-TAUGHT must be identical on all Attendance and Flexible Attendance.
  • (3) 40100-0069: If AS-OF-STATUS-CODE is I (i.e., not enrolled on final day of school year) and if the student has attendance where REPORTING-PERIOD-INDICATOR-CODE is 6, then NUMBER-DAYS-TAUGHT on the student’s attendance must be greater than TOTAL-DAYS-ABSENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-ELIGIBLE-DAYS-PRESENT.
(3) (4) E0017 (C050)

GRADE-LEVEL-CODEARS.GRStudent Attendance Details Report
ATT.GRAttendanceGrade

<BasicReportingPeriodAttendanceExtension>

<TX-GradeLevel>XX</TX-GradeLevel>

</BasicReportingPeriodAttendanceExtension>


where XXX = ARS.GR, which is populated by the ATT.GR value at the end of each Reporting Period the report was run for.
Rule (FATAL):
  • (3) 40100-0122: If MILITARY-CONNECTED-STUDENT-CODE is 4:
    • the student must be reported with Attendance or Flexible Attendance where GRADE-LEVEL-CODE is PK, or
    • the student's RESIDENTIAL-FACILITY-INDICATOR must be TRUE, or
    • the student must be reported with discipline or restraint event data where NON-MEMBERSHIP-DISCIPLINE-RESTRAINT-INDICATOR-CODE is 1
Special Warnings:
  • (3) 40110-0175: For each active regular instructional campus where there is reported Attendance or Flexible Attendance (if applicable) for any GRADE-LEVEL-CODE 09-12, at least 50% of the students reporting attendance in GRADE-LEVEL-CODE 09-12 must have at least one StudentSectionAssociation with a COURSE-COMPLETION-INDICATOR of 1.
  • (3) 42400-0040: For each Attendance data item, GRADE-LEVEL-CODE should be found in the grade range registered with TEA for the campus reported in CAMPUS-ID-OF-ENROLLMENT, unless there is matching Special Education Attendance (Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Regular - SpecialEd").
  • (3) 43415-0052: For a CourseTranscript, if DUAL-CREDIT-INDICATOR-CODE is 1, then there should be Attendance and/or Flexible Attendance for that student where GRADE-LEVEL-CODE is 09-12.
  • (3) 43415-0006: For a particular TX-UNIQUE-STUDENT-ID reporting a CourseTranscript, there must be Attendance and/or Flexible Attendance where GRADE-LEVEL-CODE is 03-12.
(3) (4)E0036
 
TOTAL-DAYS-ABSENTARS.ABSStudent Attendance Details Report
ATT.ALAttendanceAll Day Code

<BasicReportingPeriodAttendanceExtension>

<TX-TotalDaysAbsent>xx.x</TX-TotalDaysAbsent>

</BasicReportingPeriodAttendanceExtension>


where xx.x = ARS.ABS, which is populated according to ATT.AL values at the end of each Reporting Period the report was run for.
Rules (FATAL):
  • (3) 40100-0069: If AS-OF-STATUS-CODE is I (i.e., not enrolled on final day of school year) and if the student has attendance where REPORTING-PERIOD-INDICATOR-CODE is 6, then NUMBER-DAYS-TAUGHT on the student’s attendance must be greater than TOTAL-DAYS-ABSENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-ELIGIBLE-DAYS-PRESENT.
  • 42400-0005: The last character of TOTAL-DAYS-ABSENT must be either 0 or 5.

Special Warnings:

  • (3) 42400-0045: For a particular TX-UNIQUE-STUDENT-ID, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-DAYS-ABSENT should not be greater than 200.0.
  • (30 42400-0047: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE, the sum of TOTAL-DAYS-ABSENT should not be 0.
  • (3) 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.
(3)E0936

TOTAL-INELIGIBLE-DAYS-PRESENTARS.INIPStudent Attendance Details Report
ATT.CDAttendance EnrollmentEnt/Lv
ATT.PRAttendance EnrollmentElig
DAY.DTCalendarschool days
ATT.ALAttendanceAll Day Code

<BasicReportingPeriodAttendanceExtension>

<TX-TotalIneligibleDaysPresent>xx.x</TX-TotalIneligibleDaysPresent>

</BasicReportingPeriodAttendanceExtension>


where xx.x = ARS.INIP, which is based on ATT.CD dates, compared to calendar school days, minus any All Day Absences (ATT.AL) within the Reporting Period 
  • ARS.INIP is calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • Eligibility/Ineligibility is determined according to ATT.PR.
  • ARS.INIP is in-person attendance only.
Rules (FATAL):
  • 42400-0016: For each Attendance data item, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT, RS-TOTAL-ELIGIBLE-DAYS-PRESENT, RA-TOTAL-ELIGIBLE-DAYS-PRESENT, TOTAL-INELIGIBLE-DAYS-PRESENT, and TOTAL-DAYS-ABSENT must be greater than 0.
  • 42400-0035: For a particular TX-UNIQUE-STUDENT-ID, the sum of all instances of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT must be greater than or equal to 0.5.
  • 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 0.
  • 40100-0069: If AS-OF-STATUS-CODE is I (i.e., not enrolled on final day of school year) and if the student has attendance where REPORTING-PERIOD-INDICATOR-CODE is 6, then NUMBER-DAYS-TAUGHT on the student’s attendance must be greater than TOTAL-DAYS-ABSENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-ELIGIBLE-DAYS-PRESENT.
  • 42400-0006: The last character of TOTAL-INELIGIBLE-DAYS-PRESENT must be either 0 or 5.

Special Warnings:

  • 42400-0026: If GRADE-LEVEL-CODE is PK and TOTAL-INELIGIBLE-DAYS-PRESENT is greater than 0, then PRIMARY-PK-FUNDING-SOURCE should not be blank.
  • 42400-0045: For a particular TX-UNIQUE-STUDENT-ID, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-DAYS-ABSENT should not be greater than 200.0.
  • If the first three characters of DISTRICT-ID are 014, 015, 020, 021, 031, 043, 057, 061, 071, 079, 084, 101, 108, 123, 126, 152, 161, 170, 178, 220, 221, 227, 240, 243, or 246, and if DISCIPLINARY-ACTION-REASON-CODE is 11, 12, 14, 16-19, 29-32, 36, 37, 46-48", or "57", then the sum of all instances of TOTAL-INELIGIBLE-DAYS-PRESENT for this TX-UNIQUE-STUDENT-ID should be greater than 0.
(3) (4) E0937

TOTAL-ELIGIBLE-DAYS-PRESENTARS.ELIPStudent Attendance Details Report
ARS.FA
ATT.CDAttendance EnrollmentEnt/Lv
ATT.PRAttendance EnrollmentElig
ATT.FAAttendance EnrollmentFlex-Att
DAY.DTCalendarschool days
ATT.ALAttendanceAll Day Code

<BasicReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</BasicReportingPeriodAttendanceExtension>


where xx.x = ARS.ELIP, which is based on ATT.CD dates, compared to calendar school days, minus any All Day Absences (ATT.AL) within the Reporting Period
  • ARS.ELIP is calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • Eligibility/Ineligibility is determined according to ATT.PR.
  • ARS.ELIP is in-person attendance only.
  • ARS.FA indicates if student is enrolled in the Flexible Attendance program (ATT.FA <> null)
Rules (FATAL):
  • (4) 42400-0007: The last character of TOTAL-ELIGIBLE-DAYS-PRESENT must be either 0 or 5.
  • (3) 42400-0013: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE, the sum of all TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT (matching Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Regular - Bilingual/ESL") must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT.
  • (3) 42400-0014: For each Attendance data item, TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT (matching Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Regular - PRS") must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT.
  • (3) 42400-0015: For each Attendance data item, TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT (matching Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Regular - SpecialEd Mainstream") must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT.
  • (3) 42400-0016: For each Attendance data item, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT, RS-TOTAL-ELIGIBLE-DAYS-PRESENT, RA-TOTAL-ELIGIBLE-DAYS-PRESENT, TOTAL-INELIGIBLE-DAYS-PRESENT, and TOTAL-DAYS-ABSENT must be greater than 0.
  • (3) 42400-0023: Except for the Excel Center (for Adults) (227827), for a particular TX-UNIQUE-STUDENT-ID, if September 1 age is 26 or greater, then TOTAL-ELIGIBLE-DAYS-PRESENT must be 0.0.
  • (3) 42400-0034: For each Attendance data item, the sum of TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT plus all ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING (from all matching Special Education Attendance where INSTRUCTIONAL-SETTING-CODE is not 00) must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT.
  • (3) 42400-0035: For a particular TX-UNIQUE-STUDENT-ID, the sum of all instances of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT must be greater than or equal to 0.5.
  • (3) 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 0.
  • (3) 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 must be 0.0 or blank.
  • (3) 42400-0070: For the Excel Center (for Adults) (227827), for a particular TX-UNIQUE-STUDENT-ID, if September 1 age is 51 or greater, then TOTAL-ELIGIBLE-DAYS-PRESENT must be 0.0.
  • (3) 42400-0071: If GRADE-LEVEL-CODE is PK, and TOTAL-ELIGIBLE-DAYS-PRESENT is greater than 0, and either:
    • EMERGENT-BILINGUAL-INDICATOR-CODE is 1, or
    • ECONOMIC-DISADVANTAGE-CODE is a value other than 00, or
    • MILITARY-CONNECTED-STUDENT-CODE is 4, or
    • FOSTER-CARE-INDICATOR-CODE is a value other than 0, or
    • HOMELESS-STATUS-CODE is a value other than 0, or
    • STAR-OF-TEXAS-INDICATOR-CODE is 1
then PK-ELIGIBLE-PREVIOUS-YEAR-INDICATOR-CODE must be 0.
  • (3) 42400-0072: If TOTAL-ELIGIBLE-DAYS-PRESENT is greater than 0, and PK-PROGRAM-TYPE-CODE is 02, then PRIMARY-PK-FUNDING-SOURCE must be 2, 4, or 5, unless DISTRICT-ID is 015805, 015904, 015905, 015907, 015910, 015911, 015912, 015915, or 015917.
  • 42405-0012: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE, the sum of all instances of ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING (where INSTRUCTIONAL-SETTING-CODE is not 00) must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT on the matching Attendance.
  • 42405-0013: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE, the sum of all instances of ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING (where INSTRUCTIONAL-SETTING-CODE is 00) must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT on the matching Attendance.
  • (3) 42410-0016: For each CTE Attendance data item, the sum of ELIGIBLE-DAYS-PRESENT-V1, ELIGIBLE-DAYS-PRESENT-V2, ELIGIBLE-DAYS-PRESENT-V3, ELIGIBLE-DAYS-PRESENT-V4, ELIGIBLE-DAYS-PRESENT-V5, and ELIGIBLE-DAYS-PRESENT-V6 must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT on the matching Attendance.
  • (3) 40100-0069: If AS-OF-STATUS-CODE is I (i.e., not enrolled on final day of school year) and if the student has attendance where REPORTING-PERIOD-INDICATOR-CODE is 6, then NUMBER-DAYS-TAUGHT on the student’s attendance must be greater than TOTAL-DAYS-ABSENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-ELIGIBLE-DAYS-PRESENT.
  • (3) 42400-0007: The last character of TOTAL-ELIGIBLE-DAYS-PRESENT must be either 0 or 5.
  • (3) 42400-0012: For each Attendance data item, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT must not be greater than NUMBER-DAYS-TAUGHT less TOTAL-DAYS-ABSENT less TOTAL-INELIGIBLE-DAYS-PRESENT.

Special Warnings:

  • (3) 42400-0043: If September 1 age is less than 5 and GRADE-LEVEL-CODE is always greater than or equal to KG, then the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT should be 0.0.
  • (3) 42400-0044: For a particular TX-UNIQUE-STUDENT-ID, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT for all reporting periods should not be greater than 180.0.
  • (3) 42400-0045: For a particular TX-UNIQUE-STUDENT-ID, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-DAYS-ABSENT should not be greater than 200.0.
  • (3) If GRADE-LEVEL-CODE is PK and TOTAL-ELIGIBLE-DAYS-PRESENT is greater than 0, then either:
    • EMERGENT-BILINGUAL-INDICATOR-CODE should be 1, or
    • ECONOMIC-DISADVANTAGE-CODE should be 01, 02, or 99, or
    • MILITARY-CONNECTED-STUDENT-CODE should be 4, or
    • FOSTER-CARE-INDICATOR-CODE should be 1 or 2, or
    • HOMELESS-STATUS-CODE should be a value other than 0, or 
    • STAR-OF-TEXAS-INDICATOR-CODE should be 1, or
    • PK-ELIGIBLE-PREVIOUS-YEAR-INDICATOR-CODE should be 1
  • (3) 42410-0018: For a particular TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, the sum of all instances of ELIGIBLE-DAYS-PRESENT-V1, ELIGIBLE-DAYS-PRESENT-V2, ELIGIBLE-DAYS-PRESENT-V3, ELIGIBLE-DAYS-PRESENT-V4, ELIGIBLE-DAYS-PRESENT-V5, and ELIGIBLE-DAYS-PRESENT-V6 plus the sum of Special Education Attendance ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING where INSTRUCTIONAL-SETTING-CODE is 01, 02, and/or 30 should not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT on the matching Attendance.
(3) (4)E1678

RS-TOTAL-ELIGIBLE-DAYS-PRESENTARS.ELRS (RS not currently extracted)
(3) (4)E1679

RA-TOTAL-ELIGIBLE-DAYS-PRESENTARS.ELRAStudent Attendance Details Report
ATT.CDAttendance EnrollmentEnt/Lv
DAY.DTCalendarschool days
ATT.ALAttendanceAll Day Code
ATT.PR
Attendance EnrollmentElig
PGM.CD = RA, orSpecial ProgramsProgram Code
SPR.CD = RA, orSchool ProgramsProgram Type
ATT.AL = RA codeAttendanceAll Day Code

<BasicReportingPeriodAttendanceExtension>

<TX-RATotalEligibleDaysPresent>xx.x</TX-RATotalEligibleDaysPresent>

</BasicReportingPeriodAttendanceExtension>


where xx.x = ARS.ELRA , which is based on ATT.CD dates compared to calendar school days, minus any All Day Absences (ATT.AL) within the Reporting Period
  • ARS.ELRA is calculated when the Student Attendance Details Report is run with the option to Recompute selected.
  • Eligibility/Ineligibility is determined according to ATT.PR.
  • Remote Asynchronous (RA) attendance is determined according to PGM.CD or SPR.CD or ATT.AL for the particular dates. District, school, and student programs are extracted.
Rules (FATAL):
  • (3) 42400-0016: For each Attendance data item, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT, RS-TOTAL-ELIGIBLE-DAYS-PRESENT, RA-TOTAL-ELIGIBLE-DAYS-PRESENT, TOTAL-INELIGIBLE-DAYS-PRESENT, and TOTAL-DAYS-ABSENT must be greater than 0.
  • (3) 42400-0023: Except for the Excel Center (for Adults) (227827), for a particular TX-UNIQUE-STUDENT-ID, if September 1 age is 26 or greater, then RA-TOTAL-ELIGIBLE-DAYS-PRESENT must be 0.0.
  • (3) 42400-0035: For a particular TX-UNIQUE-STUDENT-ID, the sum of all instances of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT must be greater than or equal to 0.5.
  • (3) 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 RA-TOTAL-ELIGIBLE-DAYS-PRESENT must be 0.0 or blank.
  • (3) 42400-0070: For the Excel Center (for Adults) (227827), for a particular TX-UNIQUE-STUDENT-ID, if September 1 age is 51 or greater, then RA-TOTAL-ELIGIBLE-DAYS-PRESENT must be 0.0.
  • 42400-0080: If GRADE-LEVEL-CODE is KG-05, then the last character of RA-TOTAL-ELIGIBLE-DAYS-PRESENT must be 0.
  • (3) 42400-0081: If GRADE-LEVEL-CODE is 06-12, then the last character of RA-TOTAL-ELIGIBLE-DAYS-PRESENT must be either 0 or 5.
  • (3) 42400-0012: For each Attendance data item, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT must not be greater than NUMBER-DAYS-TAUGHT less TOTAL-DAYS-ABSENT less TOTAL-INELIGIBLE-DAYS-PRESENT.

Special Warnings:

  • (3) 42400-0043: If September 1 age is less than 5 and GRADE-LEVEL-CODE is always greater than or equal to KG, then the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT should be 0.0.
  • (3) 42400-0044: For a particular TX-UNIQUE-STUDENT-ID, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT for all reporting periods should not be greater than 180.0.
  • (3) 42400-0045: For a particular TX-UNIQUE-STUDENT-ID, the sum of TOTAL-ELIGIBLE-DAYS-PRESENT plus RS-TOTAL-ELIGIBLE-DAYS-PRESENT plus RA-TOTAL-ELIGIBLE-DAYS-PRESENT plus TOTAL-INELIGIBLE-DAYS-PRESENT plus TOTAL-DAYS-ABSENT should not be greater than 200.0.
(3)E1079 (C186)

PRIMARY-PK-FUNDING-SOURCEECD.FT1Early Childhood DevelopmentPrimary Funding Type
<BasicReportingPeriodAttendanceExtension>
<TX-PrimaryPKFundingSource>X</TX-PrimaryPKFundingSource>
</BasicReportingPeriodAttendanceExtension>

where X = ECD.FT1; omitted if blank or null
Rules (FATAL):
  • 42400-0021: If GRADE-LEVEL-CODE is NOT PK, then PRIMARY-PK-FUNDING-SOURCE must be blank.
  • 42400-0029: If GRADE-LEVEL-CODE is PK and PK-PROGRAM-TYPE-CODE is 02, 04, or 05, then PRIMARY-PK-FUNDING-SOURCE must not be blank.
  • 42400-0030: If GRADE-LEVEL-CODE is PK and SECONDARY-PK-FUNDING-SOURCE is not blank, then PRIMARY-PK-FUNDING-SOURCE must not be blank, and PRIMARY-PK-FUNDING-SOURCE must not be the same as SECONDARY-PK-FUNDING-SOURCE.
  • 42400-0072: If TOTAL-ELIGIBLE-DAYS-PRESENT is greater than 0, and PK-PROGRAM-TYPE-CODE is 02, then PRIMARY-PK-FUNDING-SOURCE must be 2, 4, or 5, unless DISTRICT-ID is 015805, 015904, 015905, 015907, 015910, 015911, 015912, 015915, or 015917.

Special Warnings:

  • 42400-0026: If GRADE-LEVEL-CODE is PK and TOTAL-INELIGIBLE-DAYS-PRESENT is greater than 0, then PRIMARY-PK-FUNDING-SOURCE should not be blank.
  • 42400-0028: If GRADE-LEVEL-CODE is PK and PK-PROGRAM-TYPE-CODE is 01 or 03, then PRIMARY-PK-FUNDING-SOURCE should be blank.
(3)E1080 (C186)

SECONDARY-PK-FUNDING-SOURCEECD.FT2Early Childhood DevelopmentSecondary Funding Type
<BasicReportingPeriodAttendanceExtension>
<TX-SecondaryPKFundingSource>X</TX-SecondaryPKFundingSource>
</BasicReportingPeriodAttendanceExtension>

where X = ECD.FT2; omitted if blank or null
Rules (FATAL):
  • 42400-0021: If GRADE-LEVEL-CODE is NOT PK, then SECONDARY-PK-FUNDING-SOURCE must be blank.
  • 42400-0030: If GRADE-LEVEL-CODE is PK and SECONDARY-PK-FUNDING-SOURCE is not blank, then PRIMARY-PK-FUNDING-SOURCE must not be blank, and PRIMARY-PK-FUNDING-SOURCE must not be the same as SECONDARY-PK-FUNDING-SOURCE.
(3)E1078 (C185)

PK-PROGRAM-TYPE-CODEECD.PTCEarly Childhood DevelopmentProgram Type
<BasicReportingPeriodAttendanceExtension>
<TX-PKProgramTypeIndicator>XX</TX-PKProgramTypeIndicator>
</BasicReportingPeriodAttendanceExtension>

where XX = ECD.PTC; omitted if blank or null
Rules (FATAL):
  • 42400-0021: If GRADE-LEVEL-CODE is NOT PK, then PK-PROGRAM-TYPE-CODE must be blank.
  • 42400-0027: If GRADE-LEVEL-CODE is PK, then PK-PROGRAM-TYPE-CODE must not be blank or 00.
  • 42400-0029: If GRADE-LEVEL-CODE is PK and PK-PROGRAM-TYPE-CODE is 02, 04, or 05, then PRIMARY-PK-FUNDING-SOURCE must not be blank.
  • 42400-0072: If TOTAL-ELIGIBLE-DAYS-PRESENT is greater than 0, and PK-PROGRAM-TYPE-CODE is 02, then PRIMARY-PK-FUNDING-SOURCE must be 2, 4, or 5, unless DISTRICT-ID is 015805, 015904, 015905, 015907, 015910, 015911, 015912, 015915, or 015917.

Special Warnings:

  • 42400-0028: If GRADE-LEVEL-CODE is PK and PK-PROGRAM-TYPE-CODE is 01 or 03, then PRIMARY-PK-FUNDING-SOURCE should be blank.
  • 42400-0073: For a particular CAMPUS-ID-OF-ENROLLMENT, if the only values for PK-PROGRAM-TYPE-CODE are 01 or 04, then this campus should be reported with PK-FULL-DAY-WAIVER-INDICATOR-CODE of 1.

Additional Rules:

  • (3) 42400-000A: The combination of the following fields must be unique for each Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE.
  • (3) 42400-000B: For Attendance the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT, GRADE-LEVEL-CODE, TOTAL-DAYS-ABSENT, TOTAL-INELIGIBLE-DAYS-PRESENT, TOTAL-ELIGIBLE-DAYS-PRESENT, RS-TOTAL-ELIGIBLE-DAYS-PRESENT, and RA-TOTAL-ELIGIBLE-DAYS-PRESENT.
  • (3) 42400-0067: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE reported on Attendance data, there must be a ReportingPeriod (Calendar sub-category) with a matching CAMPUS-ID, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • (3) 42400-0074: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE reported on Attendance data, if any students are reported with GRADE-LEVEL-CODE PK, there must be a ReportingPeriod (Calendar sub-category) with a matching CAMPUS-ID, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE with INSTRUCTIONAL-PROGRAM-TYPE 03, 04, 14, or 15.
  • (3) 42410-0001: For each CTE Attendance data item, there must be matching Attendance data item.
  • (3) 42410-0002: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT for CTE Attendance, there must be Attendance with matching CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • (3) 43415-0007: For a CourseTranscript, there must be Attendance and/or Flexible Attendance with a matching TX-UNIQUE-STUDENT-ID and CAMPUS-ID-OF-ENROLLMENT.
  • (3) 44425-0024: For each DisciplineAction, there should be Attendance and/or Flexible Attendance with matching TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT and REPORTING-PERIOD-INDICATOR-CODE.
  • 43415-0047: For each campus registered with TEA as an active instructional campus reporting Attendance or Flexible Attendance (if applicable), there should be at least one CourseTranscript.

SpecialProgramsReportingPeriodAttendanceExtension

SubmissionElement ID
(Code Table)
Data ElementAeries Table.FieldAeries PageLabel
(3) (4)E1523

TX-UNIQUE-STUDENT-IDSTU.CIDDemographics > Student Data 2Unique ID

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-StudentReference>

<StudentIdentity>

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</StudentIdentity>

</TX-StudentReference>

</SpecialProgramsReportingPeriodAttendanceExtension>


where UUUUUUUUUU = STU.CID
Rules (FATAL):
  • 42405-0001: For a particular TX-UNIQUE-STUDENT-ID reported with Special Education Attendance, there must be a student with a matching TX-UNIQUE-STUDENT-ID.
  • 42405-0005: For a particular TX-UNIQUE-STUDENT-ID, if September 1 age is greater than 21, then no Special Education Attendance can be reported.
  • 42505-0026: For a particular TX-UNIQUE-STUDENT-ID, if September 1 age is greater than 21, then no Special Education Flexible Attendance can be reported.
  • (3) 45435-0002: For each RestraintEvent, if NON-MEMBERSHIP-DISCIPLINE-RESTRAINT-INDICATOR-CODE is 0, then there must be Attendance or Flexible Attendance with a matching TX-UNIQUE-STUDENT-ID.
  • (4) 42500-0001: For a particular TX-UNIQUE-STUDENT-ID reported with Flexible Attendance, there must be a student with a matching TX-UNIQUE-STUDENT-ID.
  • (4) 42505-0001: For a particular TX-UNIQUE-STUDENT-ID reported with Special Education Flexible Attendance, there must be a student with a matching TX-UNIQUE-STUDENT-ID.
(3) (4)E0782

CAMPUS-ID-OF-ENROLLMENTLOC.CC + LOC.DC + LOC.SC
School OptionsCounty + District + Campus

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-CampusIdOfEnrollment>CCCDDDSSS</TX-CampusIdOfEnrollment>

</SpecialProgramsReportingPeriodAttendanceExtension>


where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
Rules (FATAL):
  • (3) 42405-0009: For Special Education Attendance, CAMPUS-ID-OF-ENROLLMENT must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in 001-698.
  • (3) 42410-0005: For CTE Attendance, CAMPUS-ID-OF-ENROLLMENT must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in 001-698.
  • (3) 42500-0002: For Flexible Attendance, CAMPUS-ID-OF-ENROLLMENT must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in 001-698.
  • (3) 42500-0003: For Flexible Attendance, the first six characters of CAMPUS-ID-OF-ENROLLMENT must not be an LEA registered with the TEA as an ESC.
  • 42500-0004: For Flexible Attendance, CAMPUS-ID-OF-ENROLLMENT must not be a campus registered with the TEA as a JJAEP campus.
  • (4) 42500-0005: For flexible attendance, CAMPUS-ID-OF-ENROLLMENT must not be a campus registered with the TEA as a Discipline Alternative Education Program (DAEP) campus.
  • 42500-0037: For Flexible Attendance, CAMPUS-ID-OF-ENROLLMENT must not be 019907006, 072801145, 101912100, 102904010, 220906007, 221801022, 236902008, 236902048, or 236902108.
  • (3) 42505-0006: For Special Education Flexible Attendance, CAMPUS-ID-OF-ENROLLMENT must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in 001-698.
  • (3) 42510-0005: For CTE Flexible Attendance, CAMPUS-ID-OF-ENROLLMENT must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in 001-698.

Special Warnings:

  • (3) 10020-0017: For each campus registered with TEA as an active regular, JJAEP, or alternative instructional campus, there should be Attendance and/or Flexible Attendance reported with a matching CAMPUS-ID-OF-ENROLLMENT.
  • (3) 10020-0018: Excluding Texas School for the Deaf and the Texas School for the Blind and Visually Impaired, for each campus registered with TEA as an active regular, JJAEP, or alternative instructional campus, there should be Special Education Attendance reported with a matching CAMPUS-ID-OF-ENROLLMENT.
  • (3) 10020-0019: Excluding Texas School for the Deaf and the Texas School for the Blind and Visually Impaired, for each campus registered with TEA with any grade 7-12 as an active regular, JJAEP, or alternative instructional campus, there should be career and technical education attendance reported with a matching CAMPUS-ID-OF-ENROLLMENT.
  • (4) 42500-0030: For each Flexible Attendance data item, GRADE-LEVEL-CODE should be found in the grade range registered with TEA for the campus reported in CAMPUS-ID-OF-ENROLLMENT, unless there is matching Special Education Flexible Attendance.
  • (3) 42500-0028: If CAMPUS-ID-OF-ENROLLMENT is a campus registered with TEA as a DAEP, then there should be a DisciplineAction with a matching TX-UNIQUE-STUDENT-ID.
(3) (4)E1085
(C188)

ATTENDANCE-EVENT-INDICATORARS.EI

Student Attendance Details Report

PGM.CDSpecial ProgramsProgram Code
PGM.FTFunding Type
ATT.PRAttendance Enrollment
Elig
CSE.D1Special EducationPrimary Disability
CSE.ED/CSE.XDEntry Date/End Date
CSH.INSSpecial Education > Instructional SettingsInstructional Setting
RFH.ED/RFH.LDSpecial Education > Residential FacilityEntry Date/Leave Date

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-AttendanceEventIndicator>XX</TX-AttendanceEventIndicator>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX = ARS.EI as follows:
  • 02 (Regular-Bil/ESL) if PGM.CD = 145 or 146 or 147, and ATT.PR <> 7 or 8
    NOTE:  This element is omitted when:
    • PGM.CD = 146, PGM.PP = 3, and PGM.FT = null, OR
    • Or, PGM.CD = 147, PGM.PP = H, and PGM.FT = null
  • 03 (Regular-CTE) if PGM.CD = 154 and ATT.PR <> 7 or 8 
  • 04 (Regular-PRS) if PGM.CD = 162 and ATT.PR <> 7 or 8 
  • 05 (Regular-Special Ed) if:
    • CSE record exists in current year, and
    • ATT.PR <> 7 or 8, and
    • CSH.INS <> 40, and
    • CSH.INS <> 81-89
  • 01 (Regular) or (Flex-Regular) 06 if:
    • PGM.CD <> 145, 146, 154, or 162
    • CSE record does not exist in current year
    • ATT.PR = 7 or 8
  • 07 (Flex-Bil/ESL) if PGM.CD = 145 or 146 or 147, and ATT.PR = 7 or 8
  • 08 (Flex-CTE) if PGM.CD = 154 and ATT.PR = 7 or 8 
  • 09 (Flex-PRS) if PGM.CD = 162 and ATT.PR = 7 or 8
  • 10 (Flex-Special Ed) if:
    • CSE record exists in current year, and
    • ATT.PR = 7 or 8, and
    • CSH.INS <> 40, and
    • CSH.INS <> 81-89
  • 11 (Regular-Special Ed Mainstream) if:
    • CSE record exists in current year, and
    • ATT.PR <> 7 or 8, and
    • CSH.INS = 40
  • 12 (Flex-Special Ed Mainstream) if: 
    • CSE record exists in current year, and
    • ATT.PR = 7 or 8, and
    • CSH.INS = 40
  • 13 (Regular-RF) if:
    • PGM.CD = 407 or RFH record exists in reporting period
    • CSE record exists in current year, and
    • ATT.PR <> 7 or 8, and
    • CSH.INS = 81-89
  • 14 (Flex-RF) if: 
    • PGM.CD = 407 or RFH record exists in reporting period
    • CSE record exists in current year, and
    • ATT.PR = 7 or 8, and
    • CSH.INS = 81-89
  • otherwise 01 (Regular)

Calculated when the Student Attendance Detail Report is run with the option to Recompute selected.

Rules (FATAL):
  • (4) 42401-0019: If REPORTING-PERIOD-INDICATOR-CODE is 9, then ATTENDANCE-EVENT-INDICATOR must be 01, 02, 04, 05, or 11 (i.e., regular attendance).
  • (3) 42405-0006: For each Special Education Attendance data item, if EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING is greater than 0, there must be a matching CTE Attendance data item (Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Regular - CTE").
  • 42505-0005: For each Special Education Flexible Attendance data item, if FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING is greater than 0, then there must be a matching CTE Flexible Attendance data item (Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Flexible - CTE").
  • (4) 42500-0048: For each Flexible Attendance data item, if FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE (from matching Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Flexible - Bilingual/ESL") is greater than 0, then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be greater than 0.
  • (4) 42500-0049: For each Flexible Attendance data item, if FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE (from matching Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Flexible - PRS") is greater than 0, then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be greater than 0.
(3) (4)E0975

INSTRUCTIONAL-TRACK-INDICATOR-CODEARS.TRAttendance Reporting Periods
ATT.TRAttendanceTrack Code

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-InstructionalTrack>XX</TX-InstructionalTrack>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX = ARS.TR, which is populated by the ATT.TR value at the end of each Reporting Period the report was run for.
Alpha tracks are automatically converted to two-digit numeric codes (i.e., A = 01, B = 02, etc.)
(3) (4)E0934 (C130)

REPORTING-PERIOD-INDICATOR-CODEARS.RPStudent Attendance Details Report

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-ReportingPeriod>X</TX-ReportingPeriod>

</SpecialProgramsReportingPeriodAttendanceExtension>


where X = ARS.RP
ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected. The reporting periods that have been recomputed are included.
Rules (FATAL):
  • (4) 42401-0016: For Submission 4, REPORTING-PERIOD-INDICATOR-CODE must be 7, 8, or 9.
  • (4) 42401-0019: If REPORTING-PERIOD-INDICATOR-CODE is 9, then ATTENDANCE-EVENT-INDICATOR must be 01, 02, 04, 05, or 11 (i.e., regular attendance).
  • (3) 42405-0011: For special education attendance, REPORTING-PERIOD-INDICATOR-CODE must be 1-6.
  • (3) 42410-0013: For CTE Attendance, REPORTING-PERIOD-INDICATOR-CODE must be 1-6.
  • (3) 42500-0006: For Flexible Attendance, REPORTING-PERIOD-INDICATOR-CODE must be 1-6.
  • (4) 42500-0007: For flexible attendance in Submission 4, REPORTING-PERIOD-INDICATOR-CODE must be 7 or 8.
  • (3) 42500-0013: If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 1-5, then NUMBER-DAYS-TAUGHT must not be greater than 45.
  • (3) 42500-0014: If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 6, then NUMBER-DAYS-TAUGHT must not be greater than 90.
  • (3) 42505-0010: For Special Education Flexible Attendance, REPORTING-PERIOD-INDICATOR-CODE must be 1-6.
  • (4) 42505-0011: For special education flexible attendance in Submission 4, REPORTING-PERIOD-INDICATOR-CODE must be 7 or 8.
  • (3) 42510-0008: For CTE Flexible Attendance, REPORTING-PERIOD-INDICATOR-CODE must be 1-6.
  • (4) 42510-0009: For CTE flexible attendance in Submission 4, REPORTING-PERIOD-INDICATOR-CODE must be 7 or 8.

Special Warnings:

  • (3) 40100-0075: If AS-OF-STATUS-CODE is H, the student should report Attendance or Flexible Attendance for REPORTING-PERIOD-INDICATOR-CODE 6.
  • (3) 40110-0176: For each grade 09-12 student reporting Attendance or Flexible Attendance in a REPORTING-PERIOD-INDICATOR-CODE greater than 2 who is not in Special Education, a StudentSectionAssociation should be reported with a matching TX-UNIQUE-STUDENT-ID.
(3) (4)E0935

NUMBER-DAYS-TAUGHTARS.DTStudent Attendance Details Report
ARP.DTAttendance Reporting PeriodsTotal Days

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-NumberDaysTaught>NN</TX-NumberDaysTaught>

</SpecialProgramsReportingPeriodAttendanceExtension>


where NN = ARS.DT for the particular attendance reporting period and track, which is populated by the ARP.DT value at the end of each Reporting Period the report was run for
Rules (FATAL):
  • 42400-0069: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, the NUMBER-DAYS-TAUGHT must be identical on all Attendance and Flexible Attendance.
  • 42405-0016: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT must be identical on all Special Education Attendance.
  • (3) 42410-0014: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT must be identical on all CTE Attendance.
  • (4) 42500-0010: For flexible attendance in Submission 4, NUMBER-DAYS-TAUGHT must be 30.
  • (3) 42500-0013: If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 1-5, then NUMBER-DAYS-TAUGHT must not be greater than 45.
  • (3) 42500-0014: If CAMPUS-ID-OF-ENROLLMENT is not a campus registered with the TEA as a JJAEP, then for a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 6, then NUMBER-DAYS-TAUGHT must not be greater than 90.
  • 42500-0015: FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE, and FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE must each be less than or equal to NUMBER-DAYS-TAUGHT.
  • 42500-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 Flexible Attendance.
  • (4) 42505-0014: For special education flexible attendance in Submission 4, NUMBER-DAYS-TAUGHT must be 30.
  • 42505-0016: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT must be identical on all Special Education Flexible Attendance.
  • (4) 42510-0012: For CTE flexible attendance in Submission 4, NUMBER-DAYS-TAUGHT must be 30.
  • 42510-0013: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT must be identical on all CTE Flexible Attendance.
(3) (4)E0017 (C050)

GRADE-LEVEL-CODEARS.GRStudent Attendance Details Report
ATT.GRAttendanceGrade

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-GradeLevel>XX</TX-GradeLevel>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XXX = ARS.GR, which is populated by the ATT.GR value at the end of each Reporting Period the report was run for
Rules (FATAL):
  • (3) 42410-0006: For CTE Attendance, GRADE-LEVEL-CODE must be 07-12.
  • 42510-0007: For CTE Flexible Attendance, GRADE-LEVEL-CODE must be 07-12.
  • (3) 40100-0122: If MILITARY-CONNECTED-STUDENT-CODE is 4:
    • the student must be reported with Attendance or Flexible Attendance where GRADE-LEVEL-CODE is PK, or
    • the student's RESIDENTIAL-FACILITY-INDICATOR must be TRUE, or 
    • the student must be reported with discipline or restraint event data where NON-MEMBERSHIP-DISCIPLINE-RESTRAINT-INDICATOR-CODE is 1

Special Warnings:

  • (3) 40110-0175: For each active regular instructional campus where there is reported Attendance or Flexible Attendance (if applicable) for any GRADE-LEVEL-CODE 09-12, at least 50% of the students reporting attendance in GRADE-LEVEL-CODE 09-12 must have at least one StudentSectionAssociation with a COURSE-COMPLETION-INDICATOR of 1.
  • (4) 42401-0009: For each Attendance data item, if GRADE-LEVEL-CODE is EE, PK, KG, 01, 02, or 03, then TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT should be 0.0 or blank.
  • (3) 43415-0052: For a CourseTranscript, if DUAL-CREDIT-INDICATOR-CODE is 1, then there should be Attendance and/or Flexible Attendance for that student where GRADE-LEVEL-CODE is 09-12.
  • (3) 43415-0006: For a particular TX-UNIQUE-STUDENT-ID reporting a CourseTranscript, there must be Attendance and/or Flexible Attendance where GRADE-LEVEL-CODE is 03-12.
  • 42500-0030: For each Flexible Attendance data item, GRADE-LEVEL-CODE should be found in the grade range registered with TEA for the campus reported in CAMPUS-ID-OF-ENROLLMENT, unless there is matching Special Education Flexible Attendance.
(3) (4)E1651 (C225)

BILINGUAL/ESL-FUNDING-CODEARS.BEStudent Attendance Details Report
ARS.EI = 02 
PGM.CD = 145, 146, or 147Special ProgramsProgram Code
PGM.FTFunding Type

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-BilingualESLFundingCode>XX</TX-BilingualESLFundingCode>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX = ARS.BE when ARS.EI = 02 (Bilingual/ESL)
  • ARS values are calculated when the Student Attendance Detail Report is run with the option to Recompute selected.
  • ARS.BE is populated by PGM.FT when PGM.CD = 145, 146, or 147 at the end of each Reporting Period the report was run for.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for the ARS.EI calculation.
Rule (FATAL):
  • 42500-0038: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE is greater than 0, and BILINGUAL/ESL-FUNDING-CODE is BE or D1, then EMERGENT-BILINGUAL-INDICATOR-CODE must be 1.

Special Warnings:

  • 42401-0005: For a particular TX-UNIQUE-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 0, and BILINGUAL/ESL-FUNDING-CODE is BE or D1, then EMERGENT-BILINGUAL-INDICATOR-CODE should be 1.
  • 42401-0020: If BILINGUAL/ESL-FUNDING-CODE is not blank, then either TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT should be greater than 0 or FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE should be greater than 0.
(3) (4)E1680 (C225)

RS-BILINGUAL/ESL-FUNDING-CODERS not currently extracted
(3) (4) E1681 (C225)

RA-BILINGUAL/ESL-FUNDING-CODEARS.BEStudent Attendance Details Report
ARS.EI = 02
ARS.ELRA > 0
 <SpecialProgramsReportingPeriodAttendanceExtension>
<TX-RABilingualESLFundingCode>XX</TX-RABilingualESLFundingCode>
 </SpecialProgramsReportingPeriodAttendanceExtension>

where XX = ARS.BE when ARS.EI = 02 and ARS.ELRA > 0
  • ARS values are calculated when the Student Attendance Detail Report is run with the option to Recompute selected.
  • See E1651 for ARS.BE calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
(3) (4)E0938

TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENTARS.PRSStudent Attendance Details Report
ARS.EI = 02

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>


where xx.x = ARS.PRS when ARS.EI = 02
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
Rules (FATAL):
  • 42401-0001: If TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT is not blank, then the last character of TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT must be either 0 or 5.
  • 42401-0013: If DISTRICT-ID matches the Texas Juvenile Justice Department (227622), then TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT must be 0.0 or blank.
  • (4) 42401-0027: If DISTRICT-ID matches Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), or the Texas Juvenile Justice Department (227622), then TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT must be 0.0 or blank.

Special Warnings:

  • 42401-0005: For a particular TX-UNIQUE-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 0, and BILINGUAL/ESL-FUNDING-CODE is BE or D1, then EMERGENT-BILINGUAL-INDICATOR-CODE should be 1.
  • 42401-0006: For a particular TX-UNIQUE-STUDENT-ID and CAMPUS-ID-OF-ENROLLMENT, if the sum of all TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT is 0 or TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT is not reported, then EMERGENT-BILINGUAL-INDICATOR-CODE should not be 1.
  • 42401-0020: If BILINGUAL/ESL-FUNDING-CODE is not blank, then either TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT should be greater than 0 or FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE should be greater than 0.
(3) (4)E1682

RS-TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENTRS not currently extracted
(3) (4)E1683

RA-TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENTARS.PRSStudent Attendance Details Report 
ARS.EI = 02
ARS.ELRA > 0
 <SpecialProgramsReportingPeriodAttendanceExtension>
<TX-RATotalEligibleDaysPresent>xx.x</TX-RATotalEligibleDaysPresent>
 </SpecialProgramsReportingPeriodAttendanceExtension>

where xx.x = ARS.PRS when ARS.EI = 02 and ARS.ELRA > 0
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
  • See E1679 for ARS.ELRA calculation.
  • This is only extracted when RA-TOTAL-ELIGIBLE-DAYS-PRESENT > 0.
Rules (FATAL):
  • 42401-0023: If GRADE-LEVEL-CODE is KG-05, and if RA-TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT is not blank, the last character must be 0.
  • (3) 42401-0024: If GRADE-LEVEL-CODE is 06-12, and if RA-TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT is not blank, then the last character must be either 0 or 5.
  • 42401-0027: If DISTRICT-ID matches Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), or the Texas Juvenile Justice Department (227622), then RA-TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT must be 0.0 or blank.
(3)E1652

TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENTARS.PRSStudent Attendance Details Report
ARS.EI = 13
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>
where xx.x = ARS.PRS when ARS.EI = 13
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.

Rule (FATAL):

  • 42401-0015: If TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENT is not blank, then the last character of TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENT must be either 0 or 5.
(3)E1684

RS-TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENTRS not currently extracted
(3)E1685

RA-TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENTARS.PRSStudent Attendance Details Report
ARS.EI = 13
ARS.ELRA > 0
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-RATotalEligibleDaysPresent>xx.x</TX-RATotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>
where xx.x = ARS.PRS when ARS.EI = 13 and ARS.ELRA > 0
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
  • See E1679 for ARS.ELRA calculation.
  • This is only extracted when RA-TOTAL-ELIGIBLE-DAYS-PRESENT > 0.
Rules (FATAL):
  • 42401-0023: If GRADE-LEVEL-CODE is KG-05, and if RA-TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENT is not blank, the last character must be 0.
  • 42401-0024: If GRADE-LEVEL-CODE is 06-12, and RA-TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENT is not blank, the last character must be either 0 or 5.
(3) (4)E0939

TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENTARS.PRSStudent Attendance Details Report
ARS.EI = 04
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>
where xx.x = ARS.PRS when ARS.EI = 04
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
Rules (FATAL):
  • 42401-0002: If TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT is not blank, then the last character of TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT must be either 0 or 5.
  • 42401-0008: For a particular TX-UNIQUE-STUDENT-ID, if TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT is greater than 0, then SEX-CODE must be F for the student.
  • 42401-0013: If DISTRICT-ID matches the Texas Juvenile Justice Department (227622), then TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT must be 0.0 or blank.
  • 42401-0027: If DISTRICT-ID matches Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), or the Texas Juvenile Justice Department (227622), then TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT must be 0.0 or blank.
  • (3) 40110-0077: If PREGNANCY-RELATED-SERVICES is 1, then that student must have Attendance with
    • TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT greater than 0, or
    • RA-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT greater than 0, or
    • Flexible Attendance with FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE greater than 0
  • (3) 42400-0014: For each Attendance data item, TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT (matching Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Regular - PRS") must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT.

Special Warning:

  • 42401-0009: For each Attendance data item, if GRADE-LEVEL-CODE is EE, PK, KG, 01, 02, or 03, then TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT should be 0.0 or blank.
(3) (4) E1686

RS-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENTRS not currently extracted
(3) (4)E1687

RA-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENTARS.PRSStudent Attendance Details Report 
ARS.EI = 04
ARS.ELRA > 0
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-RATotalEligibleDaysPresent>xx.x</TX-RATotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>
where xx.x = ARS.PRS when ARS.EI = 04 and ARS.ELRA > 0
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
  • See E1679 for ARS.ELRA calculation.
  • This is only extracted when RA-TOTAL-ELIGIBLE-DAYS-PRESENT > 0.
Rules (FATAL):
  • 42401-0023: If GRADE-LEVEL-CODE is KG-05, and if RA-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT is not blank, the last character must be 0.
  • (3) 42401-0024: If GRADE-LEVEL-CODE is 06-12, and RA-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT is not blank, then the last character must be either 0 or 5.
  • (3) 42401-0025: For a particular TX-UNIQUE-STUDENT-ID, if RA-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT is greater than 0, then SEX-CODE must be F for the student.
  • 42401-0027: If DISTRICT-ID matches Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), or the Texas Juvenile Justice Department (227622), then RA-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT must be 0.0 or blank.
  • (3) 40110-0077: If PREGNANCY-RELATED-SERVICES is 1, then that student must have Attendance with
    • TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT greater than 0, or
    • RA-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT greater than 0, or
    • Flexible Attendance with FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE greater than 0

Special Warning:

  • (3) 42401-0026: For each Attendance data item, if GRADE-LEVEL-CODE is EE, PK, KG, 01, 02, or 03, then RA-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT should be 0.0 or blank.
(3) (4)E0940

TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENTARS.PRSStudent Attendance Details Report
ARS.EI = 11
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>
where xx.x = ARS.PRS when ARS.EI = 11
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
Rules (FATAL):
  • 42401-0003: If TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT is not blank, then the last character of TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT must be either 0 or 5.
  • (3) 42401-0010: For each Attendance data item, if TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT is greater than 0, then Student Program SPECIAL-ED-INDICATOR-CODE must be 1.
  • (3) 42401-0011: For a particular TX-UNIQUE-STUDENT-ID, if September 1 age is greater than 21, then TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT must not be greater than 0.
  • 42401-0013: If DISTRICT-ID matches the Texas Juvenile Justice Department (227622), then TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT must be 0.0 or blank.
  • 42401-0027: If DISTRICT-ID matches Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), or the Texas Juvenile Justice Department (227622), then TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT must be 0.0 or blank.
  • (3) 42400-0015: For each Attendance data item, TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT (matching Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Regular - SpecialEd Mainstream") must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT.
(3) (4)E1688

RS-TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENTRS not currently extracted
(3) (4)E1689

RA-TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENTARS.PRSStudent Attendance Details Report
ARS.EI = 12
ARS.ELRA > 0
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-RATotalEligibleDaysPresent>xx.x</TX-RATotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension> 

where xx.x = ARS.PRS when ARS.EI = 12 and ARS.ELRA > 0
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
  • See E1679 for ARS.ELRA calculation.
  • This is only extracted when RA-TOTAL-ELIGIBLE-DAYS-PRESENT > 0.
Rules (FATAL):
  • (3) 42401-0010: For each Attendance data item, if RA-TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT is greater than 0, then Student Program SPECIAL-ED-INDICATOR-CODE must be 1.
  • (3) 42401-0011: For a particular TX-UNIQUE-STUDENT-ID, if September 1 age is greater than 21, then RA-TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT must not be greater than 0.
  • 42401-0023: If GRADE-LEVEL-CODE is KG-05, and if RA-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT is not blank, the last character must be 0.
  • (3) 42401-0024: If GRADE-LEVEL-CODE is 06-12, and if RA-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT is not blank, then the last character must be either 0 or 5.
  • 42401-0027: If DISTRICT-ID matches Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), or the Texas Juvenile Justice Department (227622), then RA-TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT must be 0.0 or blank.
(3) (4)E0944

ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTINGARS.ELIPStudent Attendance Details Report
ARS.EI = 05
CSH.INSSpecial Education > Instructional SettingsInstructional Setting
CSH.SD/CSH.EDStart Date/End Date
ARP.D1/ARP.D2Attendance Reporting PeriodsStarting Date/Ending Date
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>
where XX.X = ARS.ELIP where the student was enrolled in an instructional setting during the reporting period
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See E0937 for ARS.ELIP calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
  • If the student was not enrolled in the instructional setting for the entire reporting period, the dates are limited to those where the student was enrolled in the instructional setting.
Rules (FATAL):
  • 42405-0008: For Special Education Attendance, the last character of ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING must be either 0 or 5.
  • 42405-0012: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE, the sum of all instances of ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING (where INSTRUCTIONAL-SETTING-CODE is not 00) must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT on the matching Attendance.
  • 42405-0013: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE, the sum of all instances of ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING (where INSTRUCTIONAL-SETTING-CODE is 00) must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT on the matching Attendance.
  • 42405-0024: For Special Education Attendance, if INSTRUCTIONAL-SETTING-CODE is not blank, then ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING must not be blank.
  • 42405-0025: For Special Education Attendance, if ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING is not blank, then INSTRUCTIONAL-SETTING-CODE, EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING, and REG-DAY-SCH-PROG-DEAF-CODE must not be blank.
  • 42405-0026: For Special Education Attendance, if EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING is not blank, then ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING must not be blank.
  • 42405-0027: For Special Education Attendance, if REG-DAY-SCH-PROG-DEAF-CODE is not blank, then ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING must not be blank.
  • (3) 42405-0028: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, the sum of all instances of EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING must be less than or equal to the sum of all instances of ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING multiplied by 5.75.

Special Warning:

  • 42405-0010: For a student reported with Special Education Attendance, ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING should not be 0.0.
(3) (4)E1690

RS-ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTINGRS not currently extracted
(3) (4)E1691

RA-ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTINGARS.ELIPStudent Attendance Details Report
ARS.EI = 05
ARS.ELRA > 0
CSH.INSSpecial Education > Instructional SettingsInstructional Setting
CSH.SD/CSH.EDStart Date/End Date
ARP.D1/ARP.D2Attendance Reporting PeriodsStarting Date/Ending Date

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-RATotalEligibleDaysPresent>xx.x</TX-RATotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>
where XX.X = ARS.ELIP where the student was enrolled in an instructional setting during the reporting period and ARS.ELRA > 0 
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See E0937 for ARS.ELIP calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
  • See E1679 for ARS.ELRA calculation.
  • If the student was not enrolled in the instructional setting for the entire reporting period, the dates are limited to those where the student was enrolled in the instructional setting.
  • This is only extracted when RA-TOTAL-ELIGIBLE-DAYS-PRESENT > 0.
Rules (FATAL):
  • 42405-0034: If GRADE-LEVEL-CODE is KG-05, and if RA-ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING is not blank, then the last character must be 0.
  • (3) 42405-0035: If GRADE-LEVEL-CODE is 06-12, and if RA-ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING is not blank, then the last character must be either 0 or 5.
(3) (4)E1049

FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLEARS.PRSStudent Attendance Details Report
ARS.EI = 12
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>
where xx.x = ARS.PRS when ARS.EI = 12
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
Rules (FATAL):
  • 42401-0014: If DISTRICT-ID matches the Texas Juvenile Justice Department (227622), then FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE must be 0.0 or blank.
  • 42500-0015: FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE, and FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE must each be less than or equal to NUMBER-DAYS-TAUGHT.
  • 42500-0020: For a particular TX-UNIQUE-STUDENT-ID, if September 1 age is greater than 21, then FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE must not be greater than 0.
  • (3) 42500-0021: For each Flexible Attendance data item, if FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE is greater than 0, then StudentProgram SPECIAL-ED-INDICATOR-CODE must be 1.
  • 42500-0042: If DISTRICT-ID matches the Texas School for the Deaf (227906) or the Texas School for the Blind and Visually Impaired (227905), then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be 0, and FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE and FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE must all be 0.0.
  • 42500-0043: If FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT, or FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.
  • 42500-0054: If FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE is not blank, then the last character of FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE must be 0.
(3) (4)E1050

FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLEARS.PRSStudent Attendance Details Report
ARS.EI = 07
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>
where xx.x = ARS.PRS when ARS.EI = 07
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
Rules (FATAL):
  • 42401-0014: If DISTRICT-ID matches the Texas Juvenile Justice Department (227622), then FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELGIBLE must be 0.0 or blank.
  • 42500-0015: FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE, and FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE must each be less than or equal to NUMBER-DAYS-TAUGHT.
  • 42500-0038: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE is greater than 0, and BILINGUAL/ESL-FUNDING-CODE is BE or D1, then EMERGENT-BILINGUAL-INDICATOR-CODE must be 1.
  • 42500-0042: If DISTRICT-ID matches the Texas School for the Deaf (227906) or the Texas School for the Blind and Visually Impaired (227905), then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be 0, and FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE and FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE must all be 0.0.
  • 42500-0043: If FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT, or FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.
  • (4) 42500-0048: For each Flexible Attendance data item, if FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE (from matching Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Flexible - Bilingual/ESL") is greater than 0, then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be greater than 0.
  • (4) 42500-0051: If FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE is greater than 0, then LEP-INDICATOR-CODE must not be blank.
  • 42500-0055: If FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE is not blank, then the last character of FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE must be 0.

Special Warning:

  • 42401-0020: If BILINGUAL/ESL-FUNDING-CODE is not blank, then either TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT should be greater than 0 or FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE should be greater than 0.
  • (4) 42500-0039: For a particular TX-UNIQUE-STUDENT-ID and CAMPUS-ID-OF-ENROLLMENT, if the sum of all FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE is 0 or FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE is not reported, then LEP-INDICATOR-CODE should not be 1.
(3) (4)E1048

FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLEARS.PRSStudent Attendance Details Report
ARS.EI = 09
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>
where xx.x = ARS.PRS when ARS.EI = 09
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
Rules (FATAL):
  • 42401-0014: If DISTRICT-ID matches the Texas Juvenile Justice Department (227622), then FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE must be 0.0 or blank.
  • 42500-0015: FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE, and FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE must each be less than or equal to NUMBER-DAYS-TAUGHT.
  • 42500-0016: For a particular TX-UNIQUE-STUDENT-ID, if FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE is greater than 0, then SEX-CODE must be F for the student.
  • 42500-0042: If DISTRICT-ID matches the Texas School for the Deaf (227906) or the Texas School for the Blind and Visually Impaired (227905), then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be 0, and FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE and FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE must all be 0.0.
  • 42500-0043: If FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT, or FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.
  • 42500-0049: For each Flexible Attendance data item, if FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE (from matching Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Flexible - PRS") is greater than 0, then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be greater than 0.
  • 42500-0053: If FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE is not blank, then the last character of FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE must be 0.
  • (3) 40110-0077: If PREGNANCY-RELATED-SERVICES is 1, then that student must have Attendance with
    • TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT greater than 0, or
    • RA-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT greater than 0, or
    • Flexible Attendance with FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE greater than 0
(3) (4)E1653

FLEX-ATTEND-TOTAL-RESIDENTIAL-FACILITY-DAYS-ELIGIBLEARS.PRSStudent Attendance Details Report
ARS.EI = 14
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>
where xx.x = ARS.PRS when ARS.EI = 14
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See Texas - Student Attendance Details Report (Side-by-Side) (13c) for ARS.PRS calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
Rule (FATAL):
  • 42500-0052: If FLEX-ATTEND-TOTAL-RESIDENTIAL-FACILITY-DAYS-ELIGIBLE is not blank, then the last character of FLEX-ATTEND-TOTAL-RESIDENTIAL-FACILITY-DAYS-ELIGIBLE must be 0.
(3) (4)E1051

FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTINGARS.ELIPStudent Attendance Details Report
ARS.EI = 10
CSH.INSSpecial Education > Instructional SettingsInstructional Setting
CSH.SD/CSH.EDStart Date/End Date
ARP.D1/ARP.D2Attendance Reporting PeriodsStarting Date/Ending Date
<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX.X = ARS.ELIP where the student was enrolled in an instructional setting during the reporting period
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See E0937 for ARS.ELIP calculation.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
  • If the student was not enrolled in the instructional setting for the entire reporting period, the dates are limited to those where the student was enrolled in the instructional setting.
Rules (FATAL):
  • (3) 42505-0009: For a student reported with Special Education Flexible Attendance, FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING must not be 0.0.
  • 42505-0021: For a particular TX-UNIQUE-STUDENT-ID for a student reported with Special Education Flexible Attendance where FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING is not blank, INSTRUCTIONAL-SETTING-CODE and FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING must not be blank within the same set.
  • (4) 42505-0022: If INSTRUCTIONAL-SETTING-CODE, FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING or FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.
  • 42505-0024: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, GRADE-LEVEL-CODE, and FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE for a student reported with Special Education Flexible Attendance, if the sum of all instances of FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING is greater than 0, then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT on the matching Flexible Attendance must be greater than 0.
(3)E0937

TOTAL-ELIGIBLE-DAYS-PRESENTARS.ELIPStudent Attendance Details Report
ATT.CDAttendance EnrollmentEnt/Lv
ATT.PRAttendance EnrollmentElig
DAY.DTCalendarschool days
ATT.ALAttendanceAll Day Code
ARP.D1/ARP.D2Attendance Reporting PeriodsStarting Date/Ending Date

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>


where xx.x = ARS.ELIP, which is based on ATT.CD dates, compared to calendar school days within the reporting period (ARP.D1/ARP.D2), minus any All Day Absences (ATT.AL) within the Reporting Period
  • ARS.ELIP is calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • Eligibility/Ineligibility is determined according to ATT.PR.
  • ARS.ELIP is in-person attendance only.
Rules (FATAL):
  • 42400-0023: Except for the Excel Center (for Adults) (227827), for a particular TX-UNIQUE-STUDENT-ID, if September 1 age is 26 or greater, then TOTAL-ELIGIBLE-DAYS-PRESENT must be 0.0.
  • 42400-0070: For the Excel Center (for Adults) (227827), for a particular TX-UNIQUE-STUDENT-ID, if September 1 age is 51 or greater, then TOTAL-ELIGIBLE-DAYS-PRESENT must be 0.0.
  • 42410-0016: For each CTE Attendance data item, the sum of ELIGIBLE-DAYS-PRESENT-V1, ELIGIBLE-DAYS-PRESENT-V2, ELIGIBLE-DAYS-PRESENT-V3, ELIGIBLE-DAYS-PRESENT-V4, ELIGIBLE-DAYS-PRESENT-V5, and ELIGIBLE-DAYS-PRESENT-V6 must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT on the matching Attendance.
(3) (4)E0833 (C067)

REG-DAY-SCH-PROG-DEAF-CODE

ARS.RD

Student Attendance Summary Report
CSV.CD = 800 or 801Special Education > Student ServicesService

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-RegDaySchProgDeaf>X</TX-RegDaySchProgDeaf>

</SpecialProgramsReportingPeriodAttendanceExtension>


where X = ARS.RD which is calculated as follows:
  • 0 (not receiving) if CSV.CD = 800
  • 3 (receiving) if CSV.CD = 801
Rules (FATAL):
  • 42405-0021: If REG-DAY-SCH-PROG-DEAF-CODE is 0 or blank, then DISTRICT-OF-RDSPD-SERVICE must be blank.
  • 42405-0022: If REG-DAY-SCH-PROG-DEAF-CODE is not 0 or blank, then DISTRICT-OF-RDSPD-SERVICE must not be blank.
  • 42405-0024: For Special Education Attendance, if INSTRUCTIONAL-SETTING-CODE is not blank, then REG-DAY-SCH-PROG-DEAF-CODE must not be blank.
  • 42405-0025: For Special Education Attendance, if ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING is not blank, then REG-DAY-SCH-PROG-DEAF-CODE must not be blank.
  • 42405-0026: For Special Education Attendance, if EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING is not blank, then REG-DAY-SCH-PROG-DEAF-CODE must not be blank.
  • 42405-0027: For Special Education Attendance, if REG-DAY-SCH-PROG-DEAF-CODE is not blank, then INSTRUCTIONAL-SETTING-CODE, ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING, and EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING must not be blank.
(3)E0173 (C035)

INSTRUCTIONAL-SETTING-CODEARS.INSStudent Attendance Detail Report
CSH.INSSpecial Education > Instructional SettingsInstructional Setting

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-InstructionalSetting>XX</TX-InstructionalSetting>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX = ARS.INS, which is populated according to CSH.INS value at the end of each Reporting Period the report was run for.
  • ARS.INS is calculated when the Student Attendance Details Report is run with the Recompute option selected.
Rules (FATAL):
  • 42405-0007: For Special Education Attendance, INSTRUCTIONAL-SETTING-CODE must not be 31, 32, 34, 40, 50, 60, 70, or 71.
  • (3) 42405-0014: For a particular TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, if INSTRUCTIONAL-SETTING-CODE is 00 and EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING is greater than 0, then on the CTE Attendance (Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Regular - CTE") for the same TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, ELIGIBLE-DAYS-PRESENT-V6 must be greater than 0.
  • 42405-0024: For Special Education Attendance, if INSTRUCTIONAL-SETTING-CODE is not blank, then ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING, EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING, and REG-DAY-SCH-PROG-DEAF-CODE must not be blank.
  • 42405-0025: For Special Education Attendance, if ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING is not blank, then INSTRUCTIONAL-SETTING-CODE must not be blank.
  • 42405-0026: For Special Education Attendance, if EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING is not blank, then INSTRUCTIONAL-SETTING-CODE must not be blank.
  • 42405-0027: For Special Education Attendance, if REG-DAY-SCH-PROG-DEAF-CODE is not blank, then INSTRUCTIONAL-SETTING-CODE must not be blank.
  • 42505-0008: For Special Education Flexible Attendance, INSTRUCTIONAL-SETTING-CODE must not be 31, 32, 34, 40, 50, 60, 70, or 71.
  • 42505-0015: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE for a student reported with Special Education Flexible Attendance, the INSTRUCTIONAL-SETTING-CODE must not have identical repeating values.
  • (3) 42505-0020: For a particular TX-UNIQUE-STUDENT-ID for a student reported with Special Education Flexible Attendance, if INSTRUCTIONAL-SETTING-CODE is not blank, FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING must not be blank within the same set.
  • 42505-0021: For a particular TX-UNIQUE-STUDENT-ID for a student reported with Special Education Flexible Attendance where FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING is not blank, INSTRUCTIONAL-SETTING-CODE and FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING must not be blank within the same set.
  • (4) 42505-0022: If INSTRUCTIONAL-SETTING-CODE, FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING or FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.

Special Warning:

  • 42405-0018: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE, if INSTRUCTIONAL-SETTING-CODE is 00 and EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING is greater than 0, then Special Education Attendance should not be reported for any other INSTRUCTIONAL-SETTING-CODE.
(3) (4)E1692 (C035)

RS-INSTRUCTIONAL-SETTING-CODERS not currently extracted
(3) (4)E1693 (C035)

RA-INSTRUCTIONAL-SETTING-CODEARS.INSStudent Attendance Details Report
ARS.ELRA > 0
CSH.INSSpecial Education > Instructional SettingsInstructional Setting

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-RAInstructionalSetting>XX</TX-RAInstructionalSetting>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX = ARS.INS when ARS.ELRA > 0
  • ARS.INS is populated according to CSH.INS value at the end of each Reporting Period the report was run for.
  • ARS.INS is calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See E1679 for ARS.ELRA calculation.

Rule (FATAL):

  • 42405-0007: For Special Education Attendance, RA-INSTRUCTIONAL-SETTING-CODE must not be 31, 32, 34, 40, 50, 60, 70, or 71.
(3) (4)E0945

EXCESS-HOURS-IN-INSTRUCTIONAL-SETTINGARS.ECHStudent Attendance Details Report
ARS.INS
ARS.EI = 5
ARH.HR
CSH.INSSpecial Education > Instructional SettingsInstructional Setting
CSH.SD/CSH.EDStart Date/End Date
ARP.D1/ARP.D2Attendance Reporting PeriodsStarting Date/Ending Date

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-ExcessHoursInstrSetting>x.x</TX-ExcessHoursInstrSetting>

</SpecialProgramsReportingPeriodAttendanceExtension>


where X.X = ARS.ECH, which is populated accordingly if ARH.HR exceeds 6 contact hours on any date
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • ARS.INS is populated according to CSH.INS value at the end of each Reporting Period the report was run for.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
  • If the student was not enrolled in the instructional setting for the entire reporting period, the relevant dates are limited to those where the student was enrolled in the instructional setting.
Rules (FATAL):
  • (3) 42405-0006: For each Special Education Attendance data item, if EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING is greater than 0, there must be a matching CTE Attendance data item (Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Regular - CTE").
  • (3) 42405-0014: For a particular TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, if INSTRUCTIONAL-SETTING-CODE is 00 and EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING is greater than 0, then on the CTE Attendance (Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Regular - CTE") for the same TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, ELIGIBLE-DAYS-PRESENT-V6 must be greater than 0.
  • 42405-0024: For Special Education Attendance, if INSTRUCTIONAL-SETTING-CODE is not blank, then EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING must not be blank.
  • 42405-0025: For Special Education Attendance, if ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING is not blank, then EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING must not be blank.
  • 42405-0026: For Special Education Attendance, if EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING is not blank, then INSTRUCTIONAL-SETTING-CODE, ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING, and REG-DAY-SCH-PROG-DEAF-CODE must not be blank.
  • 42405-0027: For Special Education Attendance, if REG-DAY-SCH-PROG-DEAF-CODE is not blank, then EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING must not be blank.
  • (3) 42405-0028: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, the sum of all instances of EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING must be less than or equal to the sum of all instances of ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING multiplied by 5.75.
  • (3) 42405-0029: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and INSTRUCTIONAL-SETTING-CODE (where INSTRUCTIONAL-SETTING-CODE is not "00"), if there is CTE Attendance with a matching TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE with ELIGIBLE-DAYS-PRESENT-V6 greater than 0, and ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING plus ELIGIBLE-DAYS-PRESENT-V6 is greater than NUMBER-DAYS-TAUGHT, then EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING must be greater than 0 for that INSTRUCTIONAL-SETTING-CODE.
  • (3) 42405-0030: If a student is reported with Special Education Attendance in INSTRUCTIONAL-SETTING-CODE 00 (Speech Therapy) only and no other instructional setting, then for a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, if there is CTE Attendance with a matching TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE with ELIGIBLE-DAYS-PRESENT-V6 greater than 0, and ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING plus ELIGIBLE-DAYS-PRESENT-V6 is greater than NUMBER-DAYS-TAUGHT, then EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING must be greater than 0.

Special Warnings:

  • (4) 42405-0018: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE, if INSTRUCTIONAL-SETTING-CODE is 00 and EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING is greater than 0, then Special Education Attendance should not be reported for any other INSTRUCTIONAL-SETTING-CODE.
  • (3) 42405-0019: For a particular TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, the sum of all EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING should not be greater than 140.000.
  • (3) 42405-0020: For a particular TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, the sum of all EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING where INSTRUCTIONAL-SETTING-CODE is 00 should not be greater than 10.000.
(3) E1694

RS-EXCESS-HOURS-IN-INSTRUCTIONAL-SETTINGnot currently extracted
(3)E1695

RA-EXCESS-HOURS-IN-INSTRUCTIONAL-SETTINGARS.ECHStudent Attendance Details Report
ARS.INS
ARH.HR
ARS.ELRA > 0
CSH.INSSpecial Education > Instructional SettingsInstructional Setting

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-RAExcessHoursInstrSetting>x.x</TX-RAExcessHoursInstrSetting>

</SpecialProgramsReportingPeriodAttendanceExtension>


where X.X = ARS.ECH, which is populated accordingly if ARH.HR exceeds 6 contact hours on any date, and ARS.ELRA > 0
  • ARS/ARH values are calculated when the Student Attendance Details Report is run with the Recompute option selected.
  • See E1085 in SpecialProgramsReportingPeriodAttendanceExtension for ARS.EI calculation.
  • If the student was not enrolled in the instructional setting for the entire reporting period, the dates are limited to those where the student was enrolled in the instructional setting.
  • See E1679 for ARS.ELRA calculation.
  • This is only extracted when RA-TOTAL-ELIGIBLE-DAYS-PRESENT > 0.
(3) (4)E1046

FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENTARS.MPStudent Attendance Details Report
ATDSupplemental Attendance

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleMinutesPresent></TX-TotalEligibleMinutesPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>


where

Rules (FATAL):

  • 42500-0011: The value for FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be 0 or equal to or greater than 45.
  • 42500-0025: For a particular CAMPUS-ID-OF-ENROLLMENT, TX-UNIQUE-STUDENT-ID, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, the sum of FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT and FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT must be equal to or greater than 45.
  • 42500-0042: If DISTRICT-ID matches the Texas School for the Deaf (227906) or the Texas School for the Blind and Visually Impaired (227905), then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be 0, and FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE and FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE must all be 0.0.
  • 42500-0043: If FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT, or FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.
  • 42500-0044: If FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT is reported, then it must be 0-32400.
  • 42500-0047: Except for the Excel Center (for Adults) (227827), for a particular TX-UNIQUE-STUDENT-ID, if September 1 age is 26 or greater, then all instances of FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be 0, blank, or not reported.
  • 42500-0048: For each Flexible Attendance data item, if FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE (from matching Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Flexible - Bilingual/ESL") is greater than 0, then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be greater than 0.
  • 42500-0049: For each Flexible Attendance data item, if FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE (from matching Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Flexible - PRS") is greater than 0, then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be greater than 0.
  • 42500-0050: For the Excel Center (for Adults) (227827), for a particular TX-UNIQUE-STUDENT-ID, if September 1 age is 51 or greater, then all instances of FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT must be 0, blank, or not reported.
  • 42505-0024: For a particular TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, GRADE-LEVEL-CODE, and FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE for a student reported with Special Education Flexible Attendance, if the sum of all instances of FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING is greater than 0, then FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT on the matching Flexible Attendance must be greater than 0.
  • 42510-0018: For each CTE Flexible Attendance data item, FLEX-ATTEND-TOTAL-CAREER-TECH-MINUTES-PRESENT must not be greater than FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT on the matching Flexible Attendance.

Special Warnings:

  • 42500-0031: For each Flexible Attendance data item, FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT should not be greater than NUMBER-DAYS-TAUGHT multiplied by 360.
  • (3) 42500-0034: For a particular TX-UNIQUE-STUDENT-ID, the sum of FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT for all reporting periods should not be greater than 64800 (180 days).
(3) (4)E1053

FLEX-ATTEND-TOTAL-CAREER-TECH-MINUTES-PRESENTARS.MPStudent Attendance Details Report
ATDSupplmental Attendance

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalEligibleMinutesPresent></TX-TotalEligibleMinutesPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>


where

Rules (FATAL):

  • 42510-0014: For a particular TX-UNIQUE-STUDENT-ID, the sum of FLEX-ATTEND-TOTAL-CAREER-TECH-MINUTES-PRESENT must not be less than 45.
  • 42510-0016: If FLEX-ATTEND-TOTAL-CAREER-TECH-MINUTES-PRESENT is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.
  • 42510-0017: If FLEX-ATTEND-TOTAL-CAREER-TECH-MINUTES-PRESENT is reported, then it must be 45-5400.
  • 42510-0018: For each CTE Flexible Attendance data item, FLEX-ATTEND-TOTAL-CAREER-TECH-MINUTES-PRESENT must not be greater than FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT on the matching Flexible Attendance.
(3)E1047

FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENTARS.MIStudent Attendance Details Report
ATDSupplemental Attendance

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-TotalIneligibleMinutesPresent></TX-TotalIneligibleMinutesPresent>

</SpecialProgramsReportingPeriodAttendanceExtension>


where

Rules (FATAL):
  • 42500-0012: The value for FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT must be 0 or equal to or greater than 45.
  • 42500-0025: For a particular CAMPUS-ID-OF-ENROLLMENT, TX-UNIQUE-STUDENT-ID, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE, the sum of FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT and FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT must be equal to or greater than 45.
  • 42500-0041: If DISTRICT-ID matches the Texas School for the Deaf (227906) or the Texas School for the Blind and Visually Impaired (227905), then FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT must be greater than 0.
  • 42500-0043: If FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT, or FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.

Special Warning:

  • (3) 42500-0035: For a particular TX-UNIQUE-STUDENT-ID, the sum of FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT for all reporting periods should not be greater than 64800 (180 days).
(3) (4)E1052

FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTINGARS.MEStudent Attendance Details Report
ATDSupplemental Attendance

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-ExcessMinutesInstrSetting></TX-ExcessMinutesInstrSetting>

</SpecialProgramsReportingPeriodAttendanceExtension>


where
Rules (FATAL):
  • 42505-0005: For each Special Education Flexible Attendance data item, if FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING is greater than 0, then there must be a matching CTE Flexible Attendance data item (Special Programs Attendance with ATTENDANCE-EVENT-INDICATOR of "Flexible - CTE").
  • 42505-0020: For a particular TX-UNIQUE-STUDENT-ID for a student reported with Special Education Flexible Attendance, if INSTRUCTIONAL-SETTING-CODE is not blank, FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING must not be blank within the same set.
  • 42505-0021: For a particular TX-UNIQUE-STUDENT-ID for a student reported with Special Education Flexible Attendance where FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING is not blank, INSTRUCTIONAL-SETTING-CODE and FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING must not be blank within the same set.
  • (4) 42505-0022: If INSTRUCTIONAL-SETTING-CODE, FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING or FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.

Special Warnings:

  • (3) 42505-0018: For a particular TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, the sum of all instances of FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING should not be greater than 84000 (233.33 days).
  • (3) 42505-0019: For a particular TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE, the sum of all instances of FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING where INSTRUCTIONAL-SETTING-CODE is 00 should not be greater than 10000.
(3)E0724 (C022)SERVICE-IDCRS.SVCCourses > OtherService ID
CRS.DC = CTECourses Dept

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-CTEMultiplier>

<ID>XXXXXXXX</ID

</TX-CTEMultiplier>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XXXXXXXX = CRS.SVC when CRS.DC = CTE
(3)E0950

ELIGIBLE-DAYS-PRESENT-V1

ARS.ELIP

Student Attendance Details Report
ARD.PR
ARD.CD
CAR.SECourse AttendanceSection
CAR.DS/CAR.DEStart Date/Stop Date
MST.CH > 0Master ScheduleCTE V-Code
CRS.SVCCourses > OtherService ID
PGM.CDSpecial ProgramsProgram Code

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-CTEMultiplier>

<TX-CTEEligibleDaysPresentV1>xxx.x</TX-CTEEligibleDaysPresentV1>

</TX-CTEMultiplier>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX.X = ARS.ELIP when
  • ARD.PR = 'Career and Tech Education' when CAR records include course with MST.CH > 0
  • ARD.CD = V1 when CAR records exist for the reporting period where all MST.CH totals only 1 CTE hour
NOTE:
  • See E0937 for ARS.ELIP calculation.
  • ARS.ELIP is in-person attendance only.
  • ARS and ARD values are calculated when the Student Attendance Detail Report is run with the option to Recalculate selected.
  • ELIGIBLE-DAYS-PRESENT-V1 indicates the total number of days the student was eligible and present and enrolled in an approved CTE course that generated one contact hour during a particular reporting period according to the following (see the TEA Student Attendance Accounting Handbook section 5.5):
    • V1: 45-90 minutes
    • V2: 90-134 minutes
    • V3: 135-180+ minutes
Three contact hours is the maximum a district may claim for a single course. 
Example: A student enrolled in three separate 45-minute CTE courses would be assigned a code of V3 (V1 + V1 + V1 = V3).
  • For CTE students placed in a disciplinary setting during the reporting period, CTE Eligibility must cease on the day before the student is placed the disciplinary setting and resume the day after the student's last day in the setting. Use PGM.CD = 414 (CTE Ineligible Funding) to track these students. The option is used in calculations when the student was enrolled in this program for six or more consecutive school days.
  • For CTE students who start receiving homebound services during the reporting period, CTE Eligibility must cease on the day before the student starts receiving services, and resume the day after homebound instruction ends. CTE days are not counted during this period. (See SAAH 5.2.4)
    • For special education students, homebound services are indicated by the Instructional Setting (CSH.INS = 01).
    • For PRS and all other students, homebound services are indicated by the special program (PGM.CD = 412).
Rules (FATAL):
  • 42410-0007: The last character of ELIGIBLE-DAYS-PRESENT-V1 must be either 0 or 5.
  • 42410-0016: For each CTE Attendance data item, the sum of ELIGIBLE-DAYS-PRESENT-V1, ELIGIBLE-DAYS-PRESENT-V2, ELIGIBLE-DAYS-PRESENT-V3, ELIGIBLE-DAYS-PRESENT-V4, ELIGIBLE-DAYS-PRESENT-V5, and ELIGIBLE-DAYS-PRESENT-V6 must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT on the matching Attendance.
(3)E0951

ELIGIBLE-DAYS-PRESENT-V2ARS.ELIPStudent Attendance Detail Report
ARD.PR
ARD.CD

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-CTEMultiplier>

<TX-CTEEligibleDaysPresentV2>xxx.x</TX-CTEEligibleDaysPresentV2>

</TX-CTEMultiplier>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX.X = ARS.ELIP when
  • ARD.PR = 'Career and Tech Education' when CAR records include course with MST.CH = 2
  • ARD.CD = V2 when CAR records exist for the reporting period where all MST.CH totals 2 CTE hours
NOTE:
  • See E0950 for details.
  • ELIGIBLE-DAYS-PRESENT-V2 indicates the total number of days the student was eligible and present and enrolled in an approved CTE course that generated two contact hours during a particular reporting period according to the TEA Student Attendance Accounting Handbook section 5.5.
  • For CTE students placed in a disciplinary setting during the reporting period, CTE Eligibility must cease on the day before the student is placed the disciplinary setting and resume the day after the student's last day in the setting. Use PGM.CD = 414 (CTE Ineligible Funding) to track these students. The option is used in calculations when the student was enrolled in this program for six or more consecutive school days.
  • For CTE students who start receiving homebound services during the reporting period, CTE Eligibility must cease on the day before the student starts receiving services, and resume the day after homebound instruction ends. CTE days are not counted during this period. (See SAAH 5.2.4) 
    • For special education students, homebound services are indicated by the Instructional Setting (CSH.INS = 01).
    • For PRS and all other students, homebound services are indicated by the special program (PGM.CD = 412).
Rules (FATAL):
  • 42410-0008: The last character of ELIGIBLE-DAYS-PRESENT-V2 must be either 0 or 5.
  • 42410-0016: For each CTE Attendance data item, the sum of ELIGIBLE-DAYS-PRESENT-V1, ELIGIBLE-DAYS-PRESENT-V2, ELIGIBLE-DAYS-PRESENT-V3, ELIGIBLE-DAYS-PRESENT-V4, ELIGIBLE-DAYS-PRESENT-V5, and ELIGIBLE-DAYS-PRESENT-V6 must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT on the matching Attendance.
(3)E0952

ELIGIBLE-DAYS-PRESENT-V3ARS.ELIPStudent Attendance Details Report

ARD.PR
ARD.CD

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-CTEMultiplier>

<TX-CTEEligibleDaysPresentV3>xxx.x</TX-CTEEligibleDaysPresentV3>

</TX-CTEMultiplier>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX.X = ARS.ELIP when
  • ARD.PR = 'Career and Tech Education' when CAR records include course with MST.CH > 2
  • ARD.CD = V3 when CAR records exist for the reporting period where all MST.CH totals three or more CTE hours
NOTE:
  • See E0950 for details.
  • ELIGIBLE-DAYS-PRESENT-V3 indicates the total number of days the student was eligible and present and enrolled in an approved CTE course that generated three contact hours during a particular reporting period according to the TEA Student Attendance Accounting Handbook section 5.5.

    Three contact hours is the maximum a district may claim for a single course. 
    Example: A student enrolled in three separate 45-minute CTE courses would be assigned a code of V3 (V1 + V1 + V1 = V3).


  • For CTE students who start receiving homebound services during the reporting period, CTE Eligibility must cease on the day before the student starts receiving services, and resume the day after homebound instruction ends. CTE days are not counted during this period.
    • For special education students, homebound services are indicated by the Instructional Setting (CSH.INS = 01).
    • For PRS and all other students, homebound services are indicated by the special program (PGM.CD = 412).
Rules (FATAL):
  • 42410-0009: The last character of ELIGIBLE-DAYS-PRESENT-V3 must be either 0 or 5.
  • 42410-0016: For each CTE Attendance data item, the sum of ELIGIBLE-DAYS-PRESENT-V1, ELIGIBLE-DAYS-PRESENT-V2, ELIGIBLE-DAYS-PRESENT-V3, ELIGIBLE-DAYS-PRESENT-V4, ELIGIBLE-DAYS-PRESENT-V5, and ELIGIBLE-DAYS-PRESENT-V6 must not be greater than TOTAL-ELIGIBLE-DAYS-PRESENT on the matching Attendance.
(3)E1696

RS-ELIGIBLE-DAYS-PRESENT-V1RS not currently extracted
(3)E1697

RS-ELIGIBLE-DAYS-PRESENT-V2RS not currently extracted
(3)E1698

RS-ELIGIBLE-DAYS-PRESENT-V3RS not currently extracted
(3)E1702

RA-ELIGIBLE-DAYS-PRESENT-V1ARS.ELIPStudent Attendance Details Report
ARS.ELRA > 0
ARD.PR
ARD.CD

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-CTEMultiplier>

<TX-RACTEEligibleDaysPresentV1>xxx.x</TX-RACTEEligibleDaysPresentV1>

</TX-CTEMultiplier>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX.X = ARS.ELIP when ARS.ELRA > 0 and:
  • ARD.PR = 'Career and Tech Education' when CAR records include course with MST.CH > 0
  • ARD.CD = V1 when CAR records exist for the reporting period where all MST.CH totals only 1 CTE hour

NOTES:

  • See E0950 for details.
  • See E1679 for ARS.ELRA calculation.
  • This is only extracted when RA-TOTAL-ELIGIBLE-DAYS-PRESENT > 0.
Rule (FATAL):
  • 42410-0019: If RA-ELIGIBLE-DAYS-PRESENT-V1 is not blank, then the last character must be either 0 or 5.
(3)E1703

RA-ELIGIBLE-DAYS-PRESENT-V2ARS.ELIPStudent Attendance Details Report
ARS.ELRA
ARD.PR
ARD.CD

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-CTEMultiplier>

<TX-RACTEEligibleDaysPresentV2>xxx.x</TX-RACTEEligibleDaysPresentV2>

</TX-CTEMultiplier>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX.X = ARS.ELIP when ARS.ELRA > 0 and:
  • ARD.PR = 'Career and Tech Education' when CAR records include course with MST.CH = 2
  • ARD.CD = V2 when CAR records exist for the reporting period where all MST.CH totals 2 CTE hours

NOTES:

  • See E0950/E0951 for details.
  • See E1679 for ARS.ELRA calculation.
  • This is only extracted when RA-TOTAL-ELIGIBLE-DAYS-PRESENT > 0.
Rule (FATAL):
  • 42410-0019: If RA-ELIGIBLE-DAYS-PRESENT-V2 is not blank, then the last character must be either 0 or 5.
(3)E1704

RA-ELIGIBLE-DAYS-PRESENT-V3ARS.ELIPStudent Attendance Details Report

ARS.ELRA > 0
ARD.PR
ARD.CD

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-CTEMultiplier>

<TX-RACTEEligibleDaysPresentV3>xxx.x </TX-RACTEEligibleDaysPresentV3>

</TX-CTEMultiplier>

</SpecialProgramsReportingPeriodAttendanceExtension>


where XX.X = ARS.ELIP when ARS.ELRA > 0 and:
  • ARD.PR = 'Career and Tech Education' when CAR records include course with MST.CH > 2
  • ARD.CD = V3, when CAR records exist for the reporting period where all MST.CH totals more than 2 CTE hours

NOTES:

  • See E0950/E0952 for details.
  • See E1679 for ARS.ELRA calculation.
Rule (FATAL):
  • 42410-0019: If RA-ELIGIBLE-DAYS-PRESENT-V3 is not blank, then the last character must be either 0 or 5.
(3) (4)E1527

DISTRICT-OF-RDSPD-SERVICEARS.DSStudent Attendance Details Report
CSV.DSSpecial Education > Student ServicesDist of Service
CSV.CD = 801Service

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-LEAOfRDSPDService>CCCDDD</TX-LEAOfRDSPDService>

</SpecialProgramsReportingPeriodAttendanceExtension>


where CCCDDD = ARS.DS, which is based on CSV.DS when CSV.CD = 801
  • ARS.DS is populated by the CSV.DS value at the end of each Reporting Period the report was run for when CSV.CD = 801.
  • ARS values are calculated when the Student Attendance Details Report is run with the Recompute option selected.  
Rules (FATAL):
  • 42405-0021: If REG-DAY-SCH-PROG-DEAF-CODE is 0 or blank, then DISTRICT-OF-RDSPD-SERVICE must be blank.
  • 42405-0022: If REG-DAY-SCH-PROG-DEAF-CODE is not 0 or blank, then DISTRICT-OF-RDSPD-SERVICE must not be blank.
  • 42405-0023: If DISTRICT-OF-RDSPD-SERVICE is not blank, then the value for DISTRICT-OF-RDSPD-SERVICE must match a Regional Day School Program for the Deaf district in the Texas School Directory.
(3) (4)E1045 (C177)

FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODEARS.FA Student Attendance Details Report
ATT.FA/ENR.FAAttendance EnrollmentFlex-Att
PGM.CD = 401Special ProgramsProgram Code

<SpecialProgramsReportingPeriodAttendanceExtension>

<TX-FlexibleAttendanceProgram>X</TX-FlexibleAttendanceProgram>

</SpecialProgramsReportingPeriodAttendanceExtension>


where X = ARS.FA, which is populated according to ATT.FA value at the end of each Reporting Period the report was run for.
  • ARS.FA is calculated when the Student Attendance Details Report is run with the Recompute option selected.
Rules (FATAL):
  • (3) 42500-0008: For a student reported with Flexible Attendance, FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must not be 3.
  • (4) 42500-0009: For flexible attendance in Submission 4, FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be 3.
  • 42500-0043: If FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE, FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT, or FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.
  • (3) 42505-0012: For a student reported with Special Education Flexible Attendance, FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must not be 3.
  • (4) 42505-0013: For special education flexible attendance in Submission 4, FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be 3.
  • 42505-0022: If INSTRUCTIONAL-SETTING-CODE, FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING or FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.
  • (3) 42510-0010 : For CTE flex attendance, FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must not be 3.
  • (4) 42510-0011: For CTE flexible attendance, FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be 3.
  • 42510-0016: If FLEX-ATTEND-TOTAL-CAREER-TECH-MINUTES-PRESENT is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.

Special Warning:

  • 42500-0036: For a particular CAMPUS-ID-OF-ENROLLMENT, if there are any students where FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE is 1 or 6, and there is not at least one CourseTranscript with a matching TX-UNIQUE-STUDENT-ID, then a special warning message showing the total number of students in this category will be issued asking for verification.
  • 42505-0022: If INSTRUCTIONAL-SETTING-CODE, FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING or FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.
  • 42510-0016: If FLEX-ATTEND-TOTAL-CAREER-TECH-MINUTES-PRESENT is not blank, then FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE must be reported and must not be 0 or blank.

Additional Rules:

  • 42401-000D: For Special Programs Attendance (Bilingual/ESL, Pregnancy Related Services, Special Education Mainstream, Residential Facility) the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT, and GRADE-LEVEL-CODE.
  • (4) 42401-0017: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE reported on SpecialProgramsReportingPeriodAttendanceExtension, if REPORTING-PERIOD-INDICATOR-CODE is 9, there must be a Calendar ReportingPeriodExtension with a matching CAMPUS-ID, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • (3) 45435-0003: Excluding Texas School for the Deaf (227906), Texas School for the Blind and Visually Impaired (227905), and Texas Juvenile Justice Department (227622), if:
    • NON-MEMBERSHIP-DISCIPLINE-RESTRAINT-INDICATOR-CODE is 0, and
    • SPECIAL-ED-INDICATOR-CODE is 1 on the restraint event data

Then there must be Special Education Attendance or Special Education Flexible Attendance with:

  • A matching TX-UNIQUE-STUDENT-ID, INSTRUCTIONAL-SETTING-CODE, and REPORTING-PERIOD-INDICATOR-CODE, or
  • Attendance with a matching TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE where TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT is greater than 0, or
  • Flexible Attendance with a matching TX-UNIQUE-STUDENT-ID and REPORTING-PERIOD-INDICATOR-CODE where FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE is greater than 0

Bilingual/ESL Attendance

  • 42401-000A: The combination of the following fields must be unique for each Bilingual/ESL Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, GRADE-LEVEL-CODE, and at least one of the BILINGUAL/ESL-FUNDING-CODE, RS-BILINGUAL/ESL-FUNDING-CODE, or RA-BILINGUAL/ESL-FUNDING-CODE.

Pregnancy-Related Services Attendance

  • 42401-000B: The combination of the following fields must be unique for each Pregnancy Related Services Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE.

Special Education Mainstream Attendance

  • 42401-000C: The combination of the following fields must be unique for each Special Education Mainstream Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE.

Special Education Attendance

  • 42405-000A: The combination of the following fields must be unique for each Special Education Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, GRADE-LEVEL-CODE, REG-DAY-SCH-PROG-DEAF-CODE, and at least one of the INSTRUCTIONAL-SETTING-CODE, RS-INSTRUCTIONAL-SETTING-CODE, or RA-INSTRUCTIONAL-SETTING-CODE.
  • 42405-000B: For Special Education Attendance the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT, GRADE-LEVEL-CODE, REG-DAY-SCH-PROG-DEAF-CODE, INSTRUCTIONAL-SETTING-CODE, ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING, and EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING.
  • (3) 42405-0002: For each Special Education Attendance data item, there must be a matching attendance data item, and a matching StudentProgram where SPECIAL-ED-INDICATOR-CODE is 1.
  • 42405-0003: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT for Special Education Attendance, there must be Attendance with matching CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • 42405-0004: The Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), and the Texas Juvenile Justice Department (227622) must not submit Special Education Attendance.
  • (4) 42405-0031: For each special education attendance data item, there must be a matching attendance data item.

CTE Attendance

  • (3) 42410-000A: The combination of the following fields must be unique for each CTE Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE.
  • (3) 42410-000B: For CTE Attendance the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT, GRADE-LEVEL-CODE, ELIGIBLE-DAYS-PRESENT-V1, ELIGIBLE-DAYS-PRESENT-V2, ELIGIBLE-DAYS-PRESENT-V3, ELIGIBLE-DAYS-PRESENT-V4, ELIGIBLE-DAYS-PRESENT-V5, and ELIGIBLE-DAYS-PRESENT-V6.
  • (3) 42410-0001: For each CTE Attendance data item, there must be matching Attendance data item.
  • (3) 42410-0002: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT for CTE Attendance , there must be Attendance with matching CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • (3) 42410-0004: The Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), and the Texas Juvenile Justice Department (227622) must not submit CTE Attendance.
  • (3) 42410-0015: For each CTE Attendance data item and SERVICE-ID, the sum of ELIGIBLE-DAYS-PRESENT-V1, ELIGIBLE-DAYS-PRESENT-V2, ELIGIBLE-DAYS-PRESENT-V3, RS-ELIGIBLE-DAYS-PRESENT-V1, RS-ELIGIBLE-DAYS-PRESENT-V2, RS-ELIGIBLE-DAYS-PRESENT-V3, RA-ELIGIBLE-DAYS-PRESENT-V1, RA-ELIGIBLE-DAYS-PRESENT-V2, and RA-ELIGIBLE-DAYS-PRESENT-V3 must be greater than 0.

Residential Facility Attendance

  • (3) 42401-000J: The combination of the following fields must be unique for each Residential Facility Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE.

Flexible Attendance

  • 42401-000H: For Special Programs Flexible Attendance (Bilingual/ESL, Pregnancy Related Services, Special Education Mainstream, Residential Facility) the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT, GRADE-LEVEL-CODE, and FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE.
  • 42500-000A: The combination of the following fields must be unique for each Flexible Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, GRADE-LEVEL-CODE, and FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE.
  • 42500-000B: For Flexible Attendance the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT, GRADE-LEVEL-CODE, FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE, FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT, and FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT.
  • 42401-000H: For Special Programs Flexible Attendance (Bilingual/ESL, Pregnancy Related Services, Special Education Mainstream, Residential Facility) the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT, GRADE-LEVEL-CODE, and FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE.
  • (3) 42500-0045: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE reported on Flexible Attendance data, there must be a ReportingPeriod (Calendar sub-category) with a matching CAMPUS-ID, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • (3) 43415-0007: For a CourseTranscript, there must be Attendance and/or Flexible Attendance with a matching TX-UNIQUE-STUDENT-ID and CAMPUS-ID-OF-ENROLLMENT.
  • (3) 44425-0024: For each DisciplineAction, there should be Attendance and/or Flexible Attendance with matching TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT and REPORTING-PERIOD-INDICATOR-CODE.
  • (3) 43415-0047: For each campus registered with TEA as an active instructional campus reporting Attendance or Flexible Attendance (if applicable), there should be at least one CourseTranscript.

Flexible Attendance Bilingual/ESL

  • 42401-000E: The combination of the following fields must be unique for each Flexible Attendance Bilingual/ESL Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, GRADE-LEVEL-CODE, and BILINGUAL/ESL-FUNDING-CODE.

Flexible Attendance Pregnancy-Related Services

  • 42401-000F: The combination of the following fields must be unique for each Flexible Attendance Pregnancy Related Services Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE.

Flexible Attendance Special Education Mainstream

  • 42401-000G: The combination of the following fields must be unique for each Flexible Attendance Special Education Mainstream Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE.

Flexible Attendance Special Education

  • 42505-000A: The combination of the following fields must be unique for each Special Education Flexible Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, GRADE-LEVEL-CODE, FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE, and INSTRUCTIONAL-SETTING-CODE.
  • 42505-000B: For Special Education Flexible Attendance the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT, GRADE-LEVEL-CODE, FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE, INSTRUCTIONAL-SETTING-CODE, FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING, and FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING.
  • 42505-0001: For a particular TX-UNIQUE-STUDENT-ID reported with Special Education Flexible Attendance, there must be a student with a matching TX-UNIQUE-STUDENT-ID
  • (3) 42505-0002: For each Special Education Flexible Attendance data item, there must be a matching Flexible Attendance data item and a matching StudentProgram where SPECIAL-ED-INDICATOR-CODE is 1.
  • 42505-0003: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT reporting Special Education Flexible Attendance, there must be Flexible Attendance with matching CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • 42505-0004: The Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), and the Texas Juvenile Justice Department (227622) must not submit Special Education Flexible Attendance.
  • (4) 42505-0023: For each Special Education Flexible Attendance data item, there must be a matching flexible attendance data item.

Flexible Attendance CTE

  • 42510-000A: The combination of the following fields must be unique for each CTE Flexible Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, GRADE-LEVEL-CODE, and FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE.
  • 42510-000B: For CTE Flexible Attendance the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, NUMBER-DAYS-TAUGHT, GRADE-LEVEL-CODE, FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE, and FLEX-ATTEND-TOTAL-CAREER-TECH-MINUTES-PRESENT.
  • 42510-0001: For each CTE Flexible Attendance data item, there must be matching Flexible Attendance data item.
  • 42510-0002: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT reporting CTE Flexible Attendance, there must be Flexible Attendance with matching CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • 42510-0004:The Texas School for the Deaf (227906), the Texas School for the Blind and Visually Impaired (227905), and the Texas Juvenile Justice Department (227622) must not submit CTE Flexible Attendance.

Flexible Attendance Residential Facility

  • 42401-000K: The combination of the following fields must be unique for each Flexible Attendance Residential Facility Attendance data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, ATTENDANCE-EVENT-INDICATOR, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and GRADE-LEVEL-CODE.



StudentTruancyExtension ↑

SubmissionElement ID
(Code Table)
Data ElementAeries Table.FieldAeries PageLabel
(3)E1523

TX-UNIQUE-STUDENT-IDSTU.CIDDemographics > Student Data 2Unique ID

<StudentTruancyExtension>

<TX-StudentReference>

<StudentIdentity>

<StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId>

</StudentIdentity>

</TX-StudentReference>

</StudentTruancyExtension>


where UUUUUUUUUU = STU.CID
Rule (FATAL):
  • 42600-0001: For StudentTruancy data, TX-UNIQUE-STUDENT-ID must match a TX-UNIQUE-STUDENT-ID for a student.
(3)E0782

CAMPUS-ID-OF-ENROLLMENTLOC.CC + LOC.DC + LOC.SCSchool OptionsCounty + District + Campus
<StudentTruancyExtension>
<TX-CampusIdOfEnrollment>CCCDDDSSS</TX-CampusIdOfEnrollment>
</StudentTruancyExtension>

where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
(3)E0017 (C050)

GRADE-LEVEL-CODESTU.GR
DemographicsGrd
<StudentTruancyExtension>
<TX-GradeLevel>XX</TX-GradeLevel>
</StudentTruancyExtension>

where XX = STU.GR
(3)E1657 (C088)

EXCESSIVE-UNEXCUSED-ABSENCE-INDICATOR-CODESTU.TRU = YDemographics > Student Data 2Truant
<StudentTruancyExtension>
<TX-ExcessiveUnexcusedAbsenceIndicator>0/1</TX-ExcessiveUnexcusedAbsenceIndicator>
</StudentTruancyExtension>

where 0/1 = 1 if STU.TRU=Y; otherwise 0
Rule (Fatal):
  • 42600-0003: For Student Truancy, at least one of the following must be 1: EXCESSIVE-UNEXCUSED-ABSENCE-INDICATOR-CODE, TRUANCY-PREVENTION-MEASURE-INDICATOR-CODE, or TRUANCY-COMPLAINT-FILED-INDICATOR-CODE.
Special Warning:
  • 42600-0002: If TRUANCY-COMPLAINT-FILED-INDICATOR-CODE is 1, then EXCESSIVE-UNEXCUSED-ABSENCE-INDICATOR-CODE should be 1.
(3)E1658 (C088)

TRUANCY-PREVENTION-MEASURE-INDICATOR-CODEINV.CD *InterventionsCode
<StudentTruancyExtension>
<TX-TruancyPreventionMeasureIndicator>0/1</TX-TruancyPreventionMeasureIndicator>
</StudentTruancyExtension>

where 0/1 = INV.CD If INV.CD = 1 intervention record exists in current year Code is translated to 1 for  "Intervention Strategy," the indicator record will be extracted.
Truancy Prevention Measure Indicator Code (INV.CD) values must be mapped to C088 codes on Code Translations.

Rule (Fatal):
  • 42600-0003: For Student Truancy, at least one of the following must be 1: EXCESSIVE-UNEXCUSED-ABSENCE-INDICATOR-CODE, TRUANCY-PREVENTION-MEASURE-INDICATOR-CODE, or TRUANCY-COMPLAINT-FILED-INDICATOR-CODE.
(3)E1659 (C088)

TRUANCY-COMPLAINT-FILED-INDICATOR-CODEINV.TCF = YInterventionsTruancy Complaint Filed
<StudentTruancyExtension>
<TX-TruancyComplaintFiledIndicator>0/1</TX-TruancyComplaintFiledIndicator>
</StudentTruancyExtension>

where 0/1 = 1 if INV.TCF = Y
Truancy Complaint Filed is only displayed when Code = Truant and INV.CD is mapped on Code Translations.
Rule (Fatal):
  • 42600-0003: For Student Truancy, at least one of the following must be 1: EXCESSIVE-UNEXCUSED-ABSENCE-INDICATOR-CODE, TRUANCY-PREVENTION-MEASURE-INDICATOR-CODE, or TRUANCY-COMPLAINT-FILED-INDICATOR-CODE.
Special Warning:
  • 42600-0002: If TRUANCY-COMPLAINT-FILED-INDICATOR-CODE is 1, then EXCESSIVE-UNEXCUSED-ABSENCE-INDICATOR-CODE should be 1.

Additional Rules:

  • 42600-000A: The combination of the following fields must be unique for each StudentTruancy data item: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, and GRADE-LEVEL-CODE.
  • 42600-000B: For StudentTruancy the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID-OF-ENROLLMENT, GRADE-LEVEL-CODE, EXCESSIVE-UNEXCUSED-ABSENCE-INDICATOR-CODE, TRUANCY-PREVENTION-MEASURE-INDICATOR-CODE, and TRUANCY-COMPLAINT-FILED-INDICATOR-CODE.