The following entities are included in the Student Attendance domain:
Entity: StudentSchoolAttendanceEvent
Entity: StudentProgramAttendanceEvent (In Development)
Entity: BasicReportingPeriodAttendance
Entity: SpecialProgramsReportingPeriodAttendance
Entity: SpecialEducationProgramReportingPeriodAttendance
Entity: CTEProgramReportingPeriodAttendance
Entity: BilingualESLProgramReportingPeriodAttendance
Entity: FlexibleRegularProgramReportingPeriodAttendance
Entity: FlexibleSpecialEducationProgramReportingPeriodAttendance
Entity: FlexibleCTEProgramReportingPeriodAttendance
Entity: FlexibleBilingualESLProgramReportingPeriodAttendance
Entity: ExtendedSchoolYearServicesAttendance
Level 1 Errors - Student Attendance
Most TEA Ed-Fi codes are hard-coded in Aeries and do not need to be mapped.
* An asterisk in the Label & Aeries Table.Field column indicates a code set where local codes can be used. Any local codes used by the district must be mapped to TEA Ed-Fi codes on School Info > Imports and Exports > Ed-Fi Code Mappings.
NOTE: The Attendance Event Indicator is calculated when the Student Attendance Detail Report is run with the Recompute option selected, and is based on ENR.PR and program participation (PGM.CD).
See StudentAttendance Interchange - Field Mapping and Rules (SpecialProgramsReportingPeriodAttendanceExtension > AttendanceEventIndicator (E1085)).
Entity: StudentSchoolAttendanceEvent
(multiple allowed)
For regular attendance students, extracted if:
- ADA Elig (STU.SP) is 1, 2, 3, 4, 5 or 6
For students in flexible attendance programs (OFSDP and HSEP), extracted if:
- ADA Elig (STU.SP) is 7-Eligible or 8-Ineligible, and
- Flex-ATT (ENR.FA) is 1,2,3, or 6 for enrollment in the current school year
For special education students in an Extended School Year (ESY) program, extracted if
- ESY Contact Hrs (CSH.EH) (TotalESYContactHours) is greater than 0 for an Instructional Setting
- StartDate (CSH.SD) is within the current school year
IMPORTANT: Run the Mass Run Attendance Reports process (or any of the Student Attendance Detail Reports) on a frequent basis with the Recompute attendance calculations option selected. This entity uses data from the ARH table which is populated via the attendance calculations processed with those reports are run.
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | School | See Education Organization domain > School entity (SchoolID element) | |
| Enrollment History | School ENR.SC | ||
| Enrollment History | Campus of Accountability ENR.HS | ||
| ENR.HS if present; otherwise ENR.SC | |||
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E3053 | SchoolAttendanceDuration | Supp Att Data | Time ATD.TM |
| Only extracted for students in flexible attendance programs (OFSDP and HSEP), where ENR.FA = 1, 2, 3 or 6. Sum of minutes for all dates in the current school year Blank for regular attendance students | |||
| .AttendanceEvent | |||
| E3008 (C329) | AttendanceEventCategory | Enrollment History | Flex Attendance Program ENR.FA |
| |||
| E3027 | EventDate | Supp Att Data | Date ATD.DT |
| Special Education (Instructional Settings tab) | Start Date CSH.SD | ||
| Mass Run Attendance Reports calculated when process is run | Date ARH.DT | ||
| Mass Run Attendance Reports calculated when process is run | Program ARH.PR | ||
| Mass Run Attendance Reports calculated when process is run | Hours ARH.HR | ||
| |||
Entity: StudentProgramAttendanceEvent (In Development) ↑
(multiple allowed)
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | EducationOrganization | See Education Organization domain > School entity | |
| Reference | Program | See Alternative and Supplemental Services domain > Program entity | |
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E3046 | ProgramAttendanceDuration | To be determined | |
| E0173 (C035) | InstructionalSetting | To be determined | |
| .AttendanceEvent | |||
| E3008 (C329) | AttendanceEventCategory | To be determined | |
| E3027 | EventDate | To be determined | |
Entity: BasicReportingPeriodAttendance ↑
(multiple allowed)
Extracted if Attendance Event Indicator (ARS.EI) =
- 01 (Regular), or
- 06 (Flexible-Regular)
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | School | See Education Organization domain > School entity (SchoolID reference) | |
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E0975 | CalendarCode | Attendance Reporting Periods | Track ARP.TR |
| E0934 (C130) | ReportingPeriod | Attendance Reporting Periods | Reporting Period ARP.RP |
| E0017 (C050) | GradeLevel | Demographics | Grd STU.GR * |
| Ed-Fi Descriptor Code Set Mapping:Grade Level Descriptor (STU.GR) * Any grades above 12 (e.g., TR & 14-18) must be mapped to Grade 12 | |||
| E0935 | NumberDaysTaught | Attendance Reporting Periods | Total Days ARP.TD |
| E0036 | TotalDaysAbsent | Calendar Calculated | All Day Code ATT.AL |
| E0936 | TotalIneligibleDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.INIP + ARS.INRS + ARS.INRA |
| E0937 | TotalEligibleDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.ELIP |
| E1678 | RSTotalEligibleDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.ELRS |
| E1679 | RATotalEligibleDaysPresent | Student Attendance Details Report Calculated when report is run | To be determined |
Entity: SpecialProgramsReportingPeriodAttendance ↑
(multiple allowed)
Extracted if Attendance Event Indicator (ARS.EI) =
- 04 (PRS), or
- 11 (Special Ed Mainstream), or
- 13 (Residential Facility)
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | School | See Education Organization domain > School entity (SchoolID element) | |
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E0975 | CalendarCode | STU.SC_ | |
| Student Attendance Details Report Calculated when report is run | ARS.TR | ||
| STU.SC_ARS.TR | |||
| E0934 (C130) | ReportingPeriod | Student Attendance Details Report Calculated when report is run | ARS.RP |
| E0017 (C050) | GradeLevel | Demographics | Grd STU.GR * |
| Ed-Fi Descriptor Code Set Mapping:Grade Level Descriptor (STU.GR) * Any grades above 12 (e.g., TR & 14-18) must be mapped to Grade 12 | |||
| E0935 | NumberDaysTaught | Student Attendance Details Report Calculated when report is run | ARS.DT |
| E0939 | TotalEligPregRelSvcsDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.EI = 04 ARS.ELIP |
| E1686 | RSTotalEligPregRelSvcsDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.EI = 04 ARS.ELRS |
| E1687 | RATotalEligPregRelSvcsDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.EI = 04 ARS.ELRA |
| E0940 | TotalEligSpEdMainstreamDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.EI = 11 ARS.ELIP |
| E1688 | RSTotalEligSpEdMainstreamDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.EI = 11 ARS.ELRS |
| E1689 | RATotalEligSpEdMainstreamDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.EI = 11 ARS.ELRA |
| E1652 | TotalEligResidentialFacilityDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.EI = 13 ARS.ELIP |
| E1684 | RSTotalEligResidentialFacilityDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.EI = 13 ARS.ELRS |
| E1685 | RATotalEligResidentialFacilityDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.EI = 13 ARS.ELRA |
Entity: SpecialEducationProgramReportingPeriodAttendance ↑
(multiple allowed)
- Extracted if Attendance Event Indicator (ARS.EI) = 05 (Special Education)
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | School | See Education Organization domain > School entity (SchoolID element) | |
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E0975 | CalendarCode | Student Attendance Details Report Calculated when report is run | STU.SC_ARS.TR |
| E0934 (C130) | ReportingPeriod | Student Attendance Details Report Calculated when report is run | ARS.RP |
| E0017 (C050) | GradeLevel | Demographics | Grd STU.GR * |
| Ed-Fi Descriptor Code Set Mapping: Grade Level Descriptor (STU.GR) * Any grades above 12 (e.g., TR & 14-18) must be mapped to Grade 12 | |||
| E0935 | NumberDaysTaught | Student Attendance Details Report Calculated when report is run | ARS.DT |
| E0173 (C035) | InstructionalSetting | Student Attendance Details Report Calculated when report is run | ARS.INS |
| E0944 | EligibleDaysPresentInInstrSetting | Student Attendance Details Report Calculated when report is run | ARS.ELIP |
| E1690 | RSEligibleDaysPresentInInstrSetting | Student Attendance Details Report Calculated when report is run | ARS.EIRS |
| E1691 | RAEligibleDaysPresentInInstrSetting | Student Attendance Details Report Calculated when report is run | ARS.EIRA |
| E0945 | ExcessHoursInInstructionalSetting | Student Attendance Details Report Calculated when report is run | ARS.ECH |
| E1694 | RSExcessHoursInInstructionalSetting | Student Attendance Details Report Calculated when report is run | ARR.VL where ARR.CD = E1695 |
| E1695 | RAExcessHoursInInstructionalSetting | Student Attendance Details Report Calculated when report is run | ARR.VL where ARR.CD = E1694 |
| E0833 (C067) | RegionalDaySchoolProgramForDeaf | Student Attendance Details Report Calculated when report is run | District of Service ARS.DS |
| 3 is extracted if ARS.DS is not blank; otherwise 0 | |||
| E1527 | LEAOfRDSPDService | Student Attendance Details Report Calculated when report is run | District of Service ARS.DS |
Entity: CTEProgramReportingPeriodAttendance ↑
(multiple allowed)
- Extracted if Attendance Event Indicator (ARS.EI) = 03 (Regular CTE)
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | School | See Education Organization domain > School entity (SchoolID element) | |
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E0975 | CalendarCode | STU.SC | |
| Student Attendance Details Report Calculated when report is run | ARS.TR | ||
| STU.SC_ARS.TR | |||
| E0934 (C130) | ReportingPeriod | Student Attendance Details Report Calculated when report is run | ARS.RP |
| E0017 (C050) | GradeLevel | Student Attendance Details Report Calculated when report is run | ATT.GR/ARS.GR * |
| Demographics | Grd STU.GR * | ||
| Ed-Fi Descriptor Code Set Mapping:Grade Level Descriptor (STU.GR) * Any grades above 12 (e.g., TR & 14-18) must be mapped to Grade 12 | |||
| E0935 | NumberDaysTaught | Student Attendance Details Report Calculated when report is run | ARS.DT |
| E3013 (C330) | CTEServiceId | Student Attendance Details Report Calculated when report is run | ARS.SVC |
| E0950 | EligibleDaysPresentV1 | Student Attendance Details Report Calculated when report is run | ARS.ELIP |
| If ARD.PR = "Career & Tech Education' when CAR records include course where MST.CS > 0 ARD.CD = V1 when CAR records exist for the reporting period where all MST.CH totals only 1 CTE hour. | |||
| E1696 | RSEligibleDaysPresentV1 | Student Attendance Details Report Calculated when report is run | ARS.ELIP |
| If ARS.ELRS > 0 and ARD.PR = "Career & Tech Education' when CAR records include course where MST.CH > 0. ARD.PR = "Career & Tech Education' when CAR records include course where MST.CS > 0 ARD.CD = V1 when CAR records exist for the reporting period where all MST.CH totals only 1 CTE hour. | |||
| E1702 | RAEligibleDaysPresentV1 | To be determined | |
| E0951 | EligibleDaysPresentV2 | To be determined | |
| E1697 | RSEligibleDaysPresentV2 | To be determined | |
| E1703 | RAEligibleDaysPresentV2 | To be determined | |
| E0952 | EligibleDaysPresentV3 | To be determined | |
| E1698 | RSEligibleDaysPresentV3 | To be determined | |
| E1704 | RAEligibleDaysPresentV3 | To be determined | |
Entity: BilingualESLProgramReportingPeriodAttendance ↑
(multiple allowed)
- Extracted if Attendance Event Indicator (ARS.EI) = 02 (Regular Bilingual/ESL)
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | School | See Education Organization domain > School entity (SchoolID element) | |
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E0975 | CalendarCode | STU.SC | |
| Student Attendance Details Report Calculated when report is run | ARS.TR | ||
| STU.SC_ARS.TR | |||
| E0934 (C130) | ReportingPeriod | Student Attendance Details Report Calculated when report is run | ARS.RP |
| E0017 (C050) | GradeLevel | Student Attendance Details Report Calculated when report is run | ARS.GR |
| E0935 | NumberDaysTaught | Student Attendance Details Report Calculated when report is run | ARS.DT |
| E1651 (C225) | BilingualESLFunding | Special Programs | Funding Type PGM.FT * |
| Ed-Fi Descriptor Code Set Mapping: Tx Bilingual ESL Funding Descriptor (PGM.FT) * | |||
| E0938 | TotalEligBilingualESLDaysPresent | Student Attendance Details Report Calculated when report is run | Eligible Days Bilingual ARS.EDB |
| E1682 | RSTotalEligBilingualESLDaysPresen | Student Attendance Details Report Calculated when report is run | ARS.ELRS |
| Only if ARS.ELRS > 0 | |||
| E1683 | RATotalEligBilingualESLDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.ELRA |
| Only if ARS.ELRA > 0 | |||
Entity: FlexibleRegularProgramReportingPeriodAttendance ↑
(multiple allowed)
Extracted if Attendance Event Indicator (ARS.EI) =
- 08 (Flexible CTE), or
- 09 (Flex-PRS), or
- 12 (Flex-Special Ed Mainstream)
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | School | See Education Organization domain > School entity (SchoolID element) | |
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E0975 | CalendarCode | STU.SC | |
| Student Attendance Details Report Calculated when report is run | ARS.TR | ||
| STU.SC_ARS.TR | |||
| E0934 (C130)Grd | ReportingPeriod | Student Attendance Details Report Calculated when report is run | ARS.RP |
| E0017 (C050) | GradeLevel | Demographics | Grd STU.GR * |
| Ed-Fi Descriptor Code Set Mapping:Grade Level Descriptor (STU.GR) * Any grades above 12 (e.g., TR & 14-18) must be mapped to Grade 12 | |||
| E0935 | NumberDaysTaught | Student Attendance Details Report Calculated when report is run | ARS.DT |
| E1045 (C177) | FlexAttendanceProgram | Student Attendance Details Report Calculated when report is run | ARS.FA |
| ARS.FA = 1, 2, 3, or 6 only | |||
| E1046 | FlexAttendTotalEligibleMinutesPresent | Student Attendance Details Report Calculated when report is run | Eligible Minutes Present OSFDP ARS.MPO |
| When ARS.EI = 06 (Flexible Regular) | |||
| E1047 | FlexAttendTotalIneligibleMinutesPresent | Student Attendance Details Report Calculated when report is run | Ineligible Minutes Present OSFDP ARS.MIO |
| When ARS.EI = 06 (Flexible Regular) | |||
| E1048 | FlexTotalEligPregRelSvcsDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.ELIP |
| When ARS.EI = 09 (Flexible PRS) | |||
| E1049 | FlexTotalEligSpEdMainstreamDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.ELIP |
| When ARS.EI = 12 (Flexible Special Ed Mainstream) | |||
| E1653 | FlexTotalEligResidentialFacilityDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.ELIP |
| When ARS.EI = 14 (Flexible Residential Facility) | |||
Entity: FlexibleSpecialEducationProgramReportingPeriodAttendance ↑
(multiple allowed)
Extracted if:
- Attendance Event Indicator (ARS.EI) = 10 (Flexible Special Education) in current school year, or
- Flex Attendance Programs (ARS.FA) = 1, 2, 3, or 6
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | School | See Education Organization domain > School entity (SchoolID element) | |
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E0975 | CalendarCode | School STU.SC | |
Student Attendance Details Report | Track ARS.TR | ||
| STU.SC_ARS.TR | |||
| E0934 (C130) | ReportingPeriod | Student Attendance Details Report Calculated when report is run | Reporting Period ARS.RP |
| E0017 (C050) | GradeLevel | Demographics | Grd STU.GR * |
| Student Attendance Details Report Calculated when report is run | ARS.GR | ||
| Ed-Fi Descriptor Code Set Mapping: Grade Level Descriptor (STU.GR) * Any grades above 12 (e.g., TR & 14-18) must be mapped to Grade 12 | |||
| E0935 | NumberDaysTaught | Student Attendance Details Report Calculated when report is run | Days Taught ARS.DT |
| E1045 (C177) | FlexAttendanceProgram | Student Attendance Details Report Calculated when report is run | Flexible Attendance Program ARS.FA |
| Only extracted if ARS.FA = 1,2,3 or 6 in current school year | |||
| E0173 (C035) | InstructionalSetting | Student Attendance Details Report Calculated when report is run | Instructional Setting ARS.INS |
| E1051 | FlexAttendDaysEligibleInInstrSetting | Student Attendance Details Report Calculated when report is run | Eligible Days Present In Person ARS.ELIP |
| Extracted if ARS.EI = 10 (Flexible Special Education) | |||
| E1052 | FlexAttendExcessMinutesInInstrSetting | Student Attendance Details Report Calculated when report is run | Excess Minutes ARS.ME |
| Extracted if ARS.EI = 10 (Flexible Special Education) | |||
Entity: FlexibleCTEProgramReportingPeriodAttendance ↑
(multiple allowed)
Extracted if:
- Flex-ATT (ENR.FA) is 1,2,3, or 6 for enrollment in the current school year
- Attendance Event Indicator (ARS.EI) = 08 (Flexible CTE)
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | School | See Education Organization domain > School entity (SchoolID element) | |
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E0975 | CalendarCode | School STU.SC | |
| Student Attendance Details Report Calculated when report is run | Track ARS.TR | ||
| STU.SC_ARS.TR | |||
| E0934 (C130) | ReportingPeriod | Student Attendance Details Report Calculated when report is run | Reporting Period ARS.RP |
| E0017 (C050) | GradeLevel | Student Attendance Details Report Calculated when report is run | Grd ARS.GR |
| Ed-Fi Descriptor Code Set Mapping: Grade Level Descriptor (STU.GR) * Any grades above 12 (e.g., TR & 14-18) must be mapped to Grade 12 | |||
| E0935 | NumberDaysTaught | Student Attendance Details Report Calculated when report is run | Days Taught ARS.DT |
| E1045 (C177) | FlexAttendanceProgram | Student Attendance Details Report Calculated when report is run | Flexible Attendance Program ARS.FA |
| Only extracted if ARS.FA = 1,2,3 or 6 in current school year | |||
| E1053 | FlexAttendTotalCareerTechMinutesPresent | Student Attendance Details Report Calculated when report is run | Eligible Minutes Present ARS.MP |
| Extracted if ARS.EI = 8 (Flexible CTE) | |||
Entity: FlexibleBilingualESLProgramReportingPeriodAttendance ↑
(multiple allowed)
Extracted if:
- Attendance Event Indicator (ARS.EI) = 07 (Flexible Bilingual/ESL)
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.FIeld |
| Reference | School | See Education Organization domain > School entity (SchoolID element) | |
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E0975 | CalendarCode | STU.SC | |
| Student Attendance Details Report Calculated when report is run | ARS.TR | ||
| STU.SC_ARS.TR | |||
| E0934 (C130) | ReportingPeriod | Student Attendance Details Report Calculated when report is run | ARS.RP |
| E0017 (C050) | GradeLevel | Demographics | Grd STU.GR * |
| Ed-Fi Descriptor Code Set Mapping:Grade Level Descriptor (STU.GR) * Any grades above 12 (e.g., TR & 14-18) must be mapped to Grade 12 | |||
| E0935 | NumberDaysTaught | Student Attendance Details Report Calculated when report is run | ARDS.DT |
| E1045 (C177) | FlexAttendanceProgram | Student Attendance Details Report Calculated when report is run | ARS.FA |
| ARS.FA = 1, 2, 3, or 6 only | |||
| E1651 (C225) | BilingualESLFunding | Special Programs | Funding Type PGM.FT * |
| Ed-Fi Descriptor Code Set Mapping: Tx Bilingual ESL Funding Descriptor (PGM.FT) * When ARS.EI = 07 (Flexible Bilingual/ESL) | |||
| E1050 | FlexTotalEligBilingualESLDaysPresent | Student Attendance Details Report Calculated when report is run | ARS.ELIP |
| When ARS.EI = 07 (Flexible Bilingual/ESL) | |||
Entity: ExtendedSchoolYearServicesAttendance ↑
(multiple allowed)
- Only Include students whose TotalESYContactHours > 0 for an Instructional Setting with a StartDate (CSH.SD) within the current School Year.
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | School | See Education Organization domain > School entity (SchoolID element) | |
| ENR.HS if present; otherwise ENR.SC | |||
| Reference | Student | See Student Identification and Demographics domain > Student entity | |
| E0017 (C050) | GradeLevel | Enrollment History | Grd ENR.GR |
| E3031 (C035) | FirstInstructionalSetting | Special Education > Instructional Setting | Instructional Setting CSH.INS |
| E1013 | TotalESYContactHoursInFirstInstructionalSetting | Special Education > Instructional Setting | ESY Contact Hrs CSH.EH |
| E3054 (C035) | SecondInstructionalSetting | Special Education > Instructional Setting | Instructional Setting CSH.INS |
| Only reported if there are two instructional settings. If there are two instructional settings, the first one must be 00 (Speech Therapy) | |||
| E1013 | TotalESYContactHoursInSecondInstructionalSetting | Special Education > Instructional Setting | ESY Contact Hrs CSH.EH |
| Only reported if CSH.INS = 00; otherwise omitted | |||
Level 1 Errors - Student Attendance ↑
See Also: Ed-Fi - Troubleshooting Errors.