The following extensions are included in InterchangeStudentAttendanceExtension:
BasicReportingPeriodAttendanceExtension
SpecialProgramsReportingPeriodAttendanceExtension
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
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(3) (4) | E1523 | TX-UNIQUE-STUDENT-ID | STU.CID | Demographics > Student Data 2 | Unique ID |
<BasicReportingPeriodAttendanceExtension> <TX-StudentReference> <StudentIdentity> <StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId> </StudentIdentity> </TX-StudentReference> </BasicReportingPeriodAttendanceExtension> where UUUUUUUUUU = STU.CID | |||||
(3) (4) | E0782 | CAMPUS-ID-OF-ENROLLMENT | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus |
<BasicReportingPeriodAttendanceExtension> <TX-CampusIdOfEnrollment>CCCDDDSSS</TX-CampusIdOfEnrollment> </BasicReportingPeriodAttendanceExtension> where:
| |||||
Rules (FATAL):
Special Warnings:
| |||||
(3) (4) | E1085 (C188) | ATTENDANCE-EVENT-INDICATOR | 01-Regular | ||
<BasicReportingPeriodAttendanceExtension> <TX-AttendanceEventIndicator>XX</TX-AttendanceEventIndicator> </BasicReportingPeriodAttendanceExtension> where XX = 01 For BasicReportingPeriodAttendanceExtension, the AttendanceEventIndicator is always 01. | |||||
Rules (FATAL):
| |||||
(3) (4) | E0975 | INSTRUCTIONAL-TRACK-INDICATOR-CODE | ARS.TR | Student Attendance Details Report | |
ATT.TR | Attendance | Track 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-CODE | ARS.RP | Student 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):
Special Warnings:
| |||||
(3) (4) | E0935 | NUMBER-DAYS-TAUGHT | ARP.DT | Attendance Reporting Periods | Total Days |
<BasicReportingPeriodAttendanceExtension> <TX-NumberDaysTaught>nn</TX-NumberDaysTaught> </BasicReportingPeriodAttendanceExtension> where nn = ARP.DT | |||||
Rules (FATAL):
| |||||
(3) (4) | E0017 (C050) | GRADE-LEVEL-CODE | ARS.GR | Student Attendance Details Report | |
ATT.GR | Attendance | Grade | |||
<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) (4) | E0036 | TOTAL-DAYS-ABSENT | ARS.ABS | Student Attendance Details Report | |
ATT.AL | Attendance | All 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):
Special Warnings:
| |||||
(3) | E0936 | TOTAL-INELIGIBLE-DAYS-PRESENT | ARS.INIP | Student Attendance Details Report | |
ATT.CD | Attendance Enrollment | Ent/Lv | |||
ATT.PR | Attendance Enrollment | Elig | |||
DAY.DT | Calendar | school days | |||
ATT.AL | Attendance | All 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
| |||||
Rules (FATAL):
Special Warnings:
| |||||
(3) (4) | E0937 | TOTAL-ELIGIBLE-DAYS-PRESENT | ARS.ELIP | Student Attendance Details Report | |
ARS.FA | |||||
ATT.CD | Attendance Enrollment | Ent/Lv | |||
ATT.PR | Attendance Enrollment | Elig | |||
ATT.FA | Attendance Enrollment | Flex-Att | |||
DAY.DT | Calendar | school days | |||
ATT.AL | Attendance | All 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
| |||||
Rules (FATAL):
then PK-ELIGIBLE-PREVIOUS-YEAR-INDICATOR-CODE must be 0.
Special Warnings:
| |||||
(3) (4) | E1678 | RS-TOTAL-ELIGIBLE-DAYS-PRESENT | ARS.ELRS (RS not currently extracted) | ||
(3) (4) | E1679 | RA-TOTAL-ELIGIBLE-DAYS-PRESENT | ARS.ELRA | Student Attendance Details Report | |
ATT.CD | Attendance Enrollment | Ent/Lv | |||
DAY.DT | Calendar | school days | |||
ATT.AL | Attendance | All Day Code | |||
ATT.PR | Attendance Enrollment | Elig | |||
PGM.CD = RA, or | Special Programs | Program Code | |||
SPR.CD = RA, or | School Programs | Program Type | |||
ATT.AL = RA code | Attendance | All 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
| |||||
Rules (FATAL):
Special Warnings:
| |||||
(3) | E1079 (C186) | PRIMARY-PK-FUNDING-SOURCE | ECD.FT1 | Early Childhood Development | Primary Funding Type |
<BasicReportingPeriodAttendanceExtension> <TX-PrimaryPKFundingSource>X</TX-PrimaryPKFundingSource> </BasicReportingPeriodAttendanceExtension> where X = ECD.FT1; omitted if blank or null | |||||
Rules (FATAL):
Special Warnings:
| |||||
(3) | E1080 (C186) | SECONDARY-PK-FUNDING-SOURCE | ECD.FT2 | Early Childhood Development | Secondary Funding Type |
<BasicReportingPeriodAttendanceExtension> <TX-SecondaryPKFundingSource>X</TX-SecondaryPKFundingSource> </BasicReportingPeriodAttendanceExtension> where X = ECD.FT2; omitted if blank or null | |||||
Rules (FATAL):
| |||||
(3) | E1078 (C185) | PK-PROGRAM-TYPE-CODE | ECD.PTC | Early Childhood Development | Program Type |
<BasicReportingPeriodAttendanceExtension> <TX-PKProgramTypeIndicator>XX</TX-PKProgramTypeIndicator> </BasicReportingPeriodAttendanceExtension> where XX = ECD.PTC; omitted if blank or null | |||||
Rules (FATAL):
Special Warnings:
|
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 ↑
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label | |
(3) (4) | E1523 | TX-UNIQUE-STUDENT-ID | STU.CID | Demographics > Student Data 2 | Unique ID | |
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-StudentReference> <StudentIdentity> <StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId> </StudentIdentity> </TX-StudentReference> </SpecialProgramsReportingPeriodAttendanceExtension> where UUUUUUUUUU = STU.CID | ||||||
Rules (FATAL):
| ||||||
(3) (4) | E0782 | CAMPUS-ID-OF-ENROLLMENT | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus | |
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-CampusIdOfEnrollment>CCCDDDSSS</TX-CampusIdOfEnrollment> </SpecialProgramsReportingPeriodAttendanceExtension> where:
| ||||||
Rules (FATAL):
Special Warnings:
| ||||||
(3) (4) | E1085 (C188) | ATTENDANCE-EVENT-INDICATOR | ARS.EI | Student Attendance Details Report | ||
PGM.CD | Special Programs | Program Code | ||||
PGM.FT | Funding Type | |||||
ATT.PR | Attendance Enrollment | Elig | ||||
CSE.D1 | Special Education | Primary Disability | ||||
CSE.ED/CSE.XD | Entry Date/End Date | |||||
CSH.INS | Special Education > Instructional Settings | Instructional Setting | ||||
RFH.ED/RFH.LD | Special Education > Residential Facility | Entry Date/Leave Date | ||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-AttendanceEventIndicator>XX</TX-AttendanceEventIndicator> </SpecialProgramsReportingPeriodAttendanceExtension> where XX = ARS.EI as follows:
Calculated when the Student Attendance Detail Report is run with the option to Recompute selected. | ||||||
Rules (FATAL):
| ||||||
(3) (4) | E0975 | INSTRUCTIONAL-TRACK-INDICATOR-CODE | ARS.TR | Attendance Reporting Periods | ||
ATT.TR | Attendance | Track 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-CODE | ARS.RP | Student 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):
Special Warnings:
| ||||||
(3) (4) | E0935 | NUMBER-DAYS-TAUGHT | ARS.DT | Student Attendance Details Report | ||
ARP.DT | Attendance Reporting Periods | Total 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):
| ||||||
(3) (4) | E0017 (C050) | GRADE-LEVEL-CODE | ARS.GR | Student Attendance Details Report | ||
ATT.GR | Attendance | Grade | ||||
<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):
Special Warnings:
| ||||||
(3) (4) | E1651 (C225) | BILINGUAL/ESL-FUNDING-CODE | ARS.BE | Student Attendance Details Report | ||
ARS.EI = 02 | ||||||
PGM.CD = 145, 146, or 147 | Special Programs | Program Code | ||||
PGM.FT | Funding Type | |||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-BilingualESLFundingCode>XX</TX-BilingualESLFundingCode> </SpecialProgramsReportingPeriodAttendanceExtension> where XX = ARS.BE when ARS.EI = 02 (Bilingual/ESL)
| ||||||
Rule (FATAL):
Special Warnings:
| ||||||
(3) (4) | E1680 (C225) | RS-BILINGUAL/ESL-FUNDING-CODE | RS not currently extracted | |||
(3) (4) | E1681 (C225) | RA-BILINGUAL/ESL-FUNDING-CODE | ARS.BE | Student 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
| ||||||
(3) (4) | E0938 | TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT | ARS.PRS | Student Attendance Details Report | ||
ARS.EI = 02 | ||||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent> </SpecialProgramsReportingPeriodAttendanceExtension> where xx.x = ARS.PRS when ARS.EI = 02
| ||||||
Rules (FATAL):
Special Warnings:
| ||||||
(3) (4) | E1682 | RS-TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT | RS not currently extracted | |||
(3) (4) | E1683 | RA-TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT | ARS.PRS | Student 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
| ||||||
Rules (FATAL):
| ||||||
(3) | E1652 | TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENT | ARS.PRS | Student Attendance Details Report | ||
ARS.EI = 13 | ||||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent> </SpecialProgramsReportingPeriodAttendanceExtension>where xx.x = ARS.PRS when ARS.EI = 13
| ||||||
Rule (FATAL):
| ||||||
(3) | E1684 | RS-TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENT | RS not currently extracted | |||
(3) | E1685 | RA-TOTAL-ELIG-RESIDENTIAL-FACILITY-DAYS-PRESENT | ARS.PRS | Student 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
| ||||||
Rules (FATAL):
| ||||||
(3) (4) | E0939 | TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT | ARS.PRS | Student Attendance Details Report | ||
ARS.EI = 04 | ||||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent> </SpecialProgramsReportingPeriodAttendanceExtension>where xx.x = ARS.PRS when ARS.EI = 04
| ||||||
Rules (FATAL):
Special Warning:
| ||||||
(3) (4) | E1686 | RS-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT | RS not currently extracted | |||
(3) (4) | E1687 | RA-TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT | ARS.PRS | Student 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
| ||||||
Rules (FATAL):
Special Warning:
| ||||||
(3) (4) | E0940 | TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT | ARS.PRS | Student Attendance Details Report | ||
ARS.EI = 11 | ||||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent> </SpecialProgramsReportingPeriodAttendanceExtension>where xx.x = ARS.PRS when ARS.EI = 11
| ||||||
Rules (FATAL):
| ||||||
(3) (4) | E1688 | RS-TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT | RS not currently extracted | |||
(3) (4) | E1689 | RA-TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT | ARS.PRS | Student 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
| ||||||
Rules (FATAL):
| ||||||
(3) (4) | E0944 | ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING | ARS.ELIP | Student Attendance Details Report | ||
ARS.EI = 05 | ||||||
CSH.INS | Special Education > Instructional Settings | Instructional Setting | ||||
CSH.SD/CSH.ED | Start Date/End Date | |||||
ARP.D1/ARP.D2 | Attendance Reporting Periods | Starting 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
| ||||||
Rules (FATAL):
Special Warning:
| ||||||
(3) (4) | E1690 | RS-ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING | RS not currently extracted | |||
(3) (4) | E1691 | RA-ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING | ARS.ELIP | Student Attendance Details Report | ||
ARS.EI = 05 | ||||||
ARS.ELRA > 0 | ||||||
CSH.INS | Special Education > Instructional Settings | Instructional Setting | ||||
CSH.SD/CSH.ED | Start Date/End Date | |||||
ARP.D1/ARP.D2 | Attendance Reporting Periods | Starting 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
| ||||||
Rules (FATAL):
| ||||||
(3) (4) | E1049 | FLEX-ATTEND-TOTAL-SP-ED-MAINSTREAM-DAYS-ELIGIBLE | ARS.PRS | Student Attendance Details Report | ||
ARS.EI = 12 | ||||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent> </SpecialProgramsReportingPeriodAttendanceExtension>where xx.x = ARS.PRS when ARS.EI = 12
| ||||||
Rules (FATAL):
| ||||||
(3) (4) | E1050 | FLEX-ATTEND-TOTAL-BILINGUAL/ESL-DAYS-ELIGIBLE | ARS.PRS | Student Attendance Details Report | ||
ARS.EI = 07 | ||||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent> </SpecialProgramsReportingPeriodAttendanceExtension>where xx.x = ARS.PRS when ARS.EI = 07
| ||||||
Rules (FATAL):
Special Warning:
| ||||||
(3) (4) | E1048 | FLEX-ATTEND-TOTAL-PRS-DAYS-ELIGIBLE | ARS.PRS | Student Attendance Details Report | ||
ARS.EI = 09 | ||||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent> </SpecialProgramsReportingPeriodAttendanceExtension>where xx.x = ARS.PRS when ARS.EI = 09
| ||||||
Rules (FATAL):
| ||||||
(3) (4) | E1653 | FLEX-ATTEND-TOTAL-RESIDENTIAL-FACILITY-DAYS-ELIGIBLE | ARS.PRS | Student Attendance Details Report | ||
ARS.EI = 14 | ||||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent> </SpecialProgramsReportingPeriodAttendanceExtension>where xx.x = ARS.PRS when ARS.EI = 14
| ||||||
Rule (FATAL):
| ||||||
(3) (4) | E1051 | FLEX-ATTEND-DAYS-ELIGIBLE-IN-INSTR-SETTING | ARS.ELIP | Student Attendance Details Report | ||
ARS.EI = 10 | ||||||
CSH.INS | Special Education > Instructional Settings | Instructional Setting | ||||
CSH.SD/CSH.ED | Start Date/End Date | |||||
ARP.D1/ARP.D2 | Attendance Reporting Periods | Starting Date/Ending Date | ||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalEligibleDaysPresent>xx.x</TX-TotalEligibleDaysPresent> </SpecialProgramsReportingPeriodAttendanceExtension>
| ||||||
Rules (FATAL):
| ||||||
(3) | E0937 | TOTAL-ELIGIBLE-DAYS-PRESENT | ARS.ELIP | Student Attendance Details Report | ||
ATT.CD | Attendance Enrollment | Ent/Lv | ||||
ATT.PR | Attendance Enrollment | Elig | ||||
DAY.DT | Calendar | school days | ||||
ATT.AL | Attendance | All Day Code | ||||
ARP.D1/ARP.D2 | Attendance Reporting Periods | Starting 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
| ||||||
Rules (FATAL):
| ||||||
(3) (4) | E0833 (C067) | REG-DAY-SCH-PROG-DEAF-CODE | ARS.RD | Student Attendance Summary Report | ||
CSV.CD = 800 or 801 | Special Education > Student Services | Service | ||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-RegDaySchProgDeaf>X</TX-RegDaySchProgDeaf> </SpecialProgramsReportingPeriodAttendanceExtension> where X = ARS.RD which is calculated as follows:
| ||||||
Rules (FATAL):
| ||||||
(3) | E0173 (C035) | INSTRUCTIONAL-SETTING-CODE | ARS.INS | Student Attendance Detail Report | ||
CSH.INS | Special Education > Instructional Settings | Instructional 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.
| ||||||
Rules (FATAL):
Special Warning:
| ||||||
(3) (4) | E1692 (C035) | RS-INSTRUCTIONAL-SETTING-CODE | RS not currently extracted | |||
(3) (4) | E1693 (C035) | RA-INSTRUCTIONAL-SETTING-CODE | ARS.INS | Student Attendance Details Report | ||
ARS.ELRA > 0 | ||||||
CSH.INS | Special Education > Instructional Settings | Instructional Setting | ||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-RAInstructionalSetting>XX</TX-RAInstructionalSetting> </SpecialProgramsReportingPeriodAttendanceExtension> where XX = ARS.INS when ARS.ELRA > 0
| ||||||
Rule (FATAL):
| ||||||
(3) (4) | E0945 | EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING | ARS.ECH | Student Attendance Details Report | ||
ARS.INS | ||||||
ARS.EI = 5 | ||||||
ARH.HR | ||||||
CSH.INS | Special Education > Instructional Settings | Instructional Setting | ||||
CSH.SD/CSH.ED | Start Date/End Date | |||||
ARP.D1/ARP.D2 | Attendance Reporting Periods | Starting 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
| ||||||
Rules (FATAL):
Special Warnings:
| ||||||
(3) | E1694 | RS-EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING | not currently extracted | |||
(3) | E1695 | RA-EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING | ARS.ECH | Student Attendance Details Report | ||
ARS.INS | ||||||
ARH.HR | ||||||
ARS.ELRA > 0 | ||||||
CSH.INS | Special Education > Instructional Settings | Instructional 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
| ||||||
(3) (4) | E1046 | FLEX-ATTEND-TOTAL-ELIGIBLE-MINUTES-PRESENT | ARS.MP | Student Attendance Details Report | ||
ATD | Supplemental Attendance | |||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalEligibleMinutesPresent></TX-TotalEligibleMinutesPresent> </SpecialProgramsReportingPeriodAttendanceExtension> where | ||||||
Rules (FATAL):
Special Warnings:
| ||||||
(3) (4) | E1053 | FLEX-ATTEND-TOTAL-CAREER-TECH-MINUTES-PRESENT | ARS.MP | Student Attendance Details Report | ||
ATD | Supplmental Attendance | |||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalEligibleMinutesPresent></TX-TotalEligibleMinutesPresent> </SpecialProgramsReportingPeriodAttendanceExtension> where | ||||||
Rules (FATAL):
| ||||||
(3) | E1047 | FLEX-ATTEND-TOTAL-INELIGIBLE-MINUTES-PRESENT | ARS.MI | Student Attendance Details Report | ||
ATD | Supplemental Attendance | |||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-TotalIneligibleMinutesPresent></TX-TotalIneligibleMinutesPresent> </SpecialProgramsReportingPeriodAttendanceExtension> where | ||||||
Rules (FATAL):
Special Warning:
| ||||||
(3) (4) | E1052 | FLEX-ATTEND-EXCESS-MINUTES-IN-INSTR-SETTING | ARS.ME | Student Attendance Details Report | ||
ATD | Supplemental Attendance | |||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-ExcessMinutesInstrSetting></TX-ExcessMinutesInstrSetting> </SpecialProgramsReportingPeriodAttendanceExtension> where | ||||||
Rules (FATAL):
Special Warnings:
| ||||||
(3) | E0724 (C022) | SERVICE-ID | CRS.SVC | Courses > Other | Service ID | |
CRS.DC = CTE | Courses | 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.SE | Course Attendance | Section | ||||
CAR.DS/CAR.DE | Start Date/Stop Date | |||||
MST.CH > 0 | Master Schedule | CTE V-Code | ||||
CRS.SVC | Courses > Other | Service ID | ||||
PGM.CD | Special Programs | Program Code | ||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-CTEMultiplier> <TX-CTEEligibleDaysPresentV1>xxx.x</TX-CTEEligibleDaysPresentV1> </TX-CTEMultiplier> </SpecialProgramsReportingPeriodAttendanceExtension> where XX.X = ARS.ELIP when
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).
| ||||||
Rules (FATAL):
| ||||||
(3) | E0951 | ELIGIBLE-DAYS-PRESENT-V2 | ARS.ELIP | Student 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
| ||||||
Rules (FATAL):
| ||||||
(3) | E0952 | ELIGIBLE-DAYS-PRESENT-V3 | ARS.ELIP | Student 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
| ||||||
Rules (FATAL):
| ||||||
(3) | E1696 | RS-ELIGIBLE-DAYS-PRESENT-V1 | RS not currently extracted | |||
(3) | E1697 | RS-ELIGIBLE-DAYS-PRESENT-V2 | RS not currently extracted | |||
(3) | E1698 | RS-ELIGIBLE-DAYS-PRESENT-V3 | RS not currently extracted | |||
(3) | E1702 | RA-ELIGIBLE-DAYS-PRESENT-V1 | ARS.ELIP | Student 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:
NOTES:
| ||||||
Rule (FATAL):
| ||||||
(3) | E1703 | RA-ELIGIBLE-DAYS-PRESENT-V2 | ARS.ELIP | Student 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:
NOTES:
| ||||||
Rule (FATAL):
| ||||||
(3) | E1704 | RA-ELIGIBLE-DAYS-PRESENT-V3 | ARS.ELIP | Student 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:
NOTES:
| ||||||
Rule (FATAL):
| ||||||
(3) (4) | E1527 | DISTRICT-OF-RDSPD-SERVICE | ARS.DS | Student Attendance Details Report | ||
CSV.DS | Special Education > Student Services | Dist of Service | ||||
CSV.CD = 801 | Service | |||||
<SpecialProgramsReportingPeriodAttendanceExtension> <TX-LEAOfRDSPDService>CCCDDD</TX-LEAOfRDSPDService> </SpecialProgramsReportingPeriodAttendanceExtension> where CCCDDD = ARS.DS, which is based on CSV.DS when CSV.CD = 801
| ||||||
Rules (FATAL):
| ||||||
(3) (4) | E1045 (C177) | FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE | ARS.FA | Student Attendance Details Report | ||
ATT.FA/ENR.FA | Attendance Enrollment | Flex-Att | ||||
PGM.CD = 401 | Special Programs | Program 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.
| ||||||
Rules (FATAL):
Special Warning:
|
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 ↑
Submission | Element ID (Code Table) | Data Element | Aeries Table.Field | Aeries Page | Label |
(3) | E1523 | TX-UNIQUE-STUDENT-ID | STU.CID | Demographics > Student Data 2 | Unique ID |
<StudentTruancyExtension> <TX-StudentReference> <StudentIdentity> <StudentUniqueStateId>UUUUUUUUUU</StudentUniqueStateId> </StudentIdentity> </TX-StudentReference> </StudentTruancyExtension> where UUUUUUUUUU = STU.CID | |||||
Rule (FATAL):
| |||||
(3) | E0782 | CAMPUS-ID-OF-ENROLLMENT | LOC.CC + LOC.DC + LOC.SC | School Options | County + District + Campus |
<StudentTruancyExtension> <TX-CampusIdOfEnrollment>CCCDDDSSS</TX-CampusIdOfEnrollment> </StudentTruancyExtension> where:
| |||||
(3) | E0017 (C050) | GRADE-LEVEL-CODE | STU.GR | Demographics | Grd |
<StudentTruancyExtension> <TX-GradeLevel>XX</TX-GradeLevel> </StudentTruancyExtension> where XX = STU.GR | |||||
(3) | E1657 (C088) | EXCESSIVE-UNEXCUSED-ABSENCE-INDICATOR-CODE | STU.TRU = Y | Demographics > Student Data 2 | Truant |
<StudentTruancyExtension> <TX-ExcessiveUnexcusedAbsenceIndicator>0/1</TX-ExcessiveUnexcusedAbsenceIndicator> </StudentTruancyExtension> where 0/1 = 1 if STU.TRU=Y; otherwise 0 | |||||
Rule (Fatal):
| |||||
(3) | E1658 (C088) | TRUANCY-PREVENTION-MEASURE-INDICATOR-CODE | INV.CD * | Interventions | Code |
<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):
| |||||
(3) | E1659 (C088) | TRUANCY-COMPLAINT-FILED-INDICATOR-CODE | INV.TCF = Y | Interventions | Truancy 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):
|
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.