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 (In Development)
Entity: FlexibleCTEProgramReportingPeriodAttendance (In Development)
Entity: FlexibleBilingualESLProgramReportingPeriodAttendance (In Development)
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)
Included 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
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 | ENR.SC | ||
Reference | Student | See Student Identification and Demographics domain > Student entity | |
E3053 | SchoolAttendanceDuration | Supp Att Data | Time ATD.TM |
Sum of minutes for all dates in the current school year | |||
.AttendanceEvent | |||
E3008 (C329) | AttendanceEventCategory | Enrollment History | Flex Attendance Program ENR.FA |
4 if ENR.FA = 1 5 if ENR.FA = 2 6 if ENR.FA = 3 7 if ENR.FA = 6 | |||
E3027 | EventDate | Supp Att Data | Date ATD.DT |
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 Event Indicator= 01 (Regular) or 06 (Flexible-Regular) (ARS.EI = 01 or 06)
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 Event Indicator = PRS (04), Special Ed Mainstream (11), or Residential Facility (13) (ARS.EI = 04, 11, or 13)
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 Event Indicator= 05 (Special Education) (ARS.EI = 05)
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 Event Indicator= 03 (Regular CTE) (ARS.EI = 03)
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 Event Indicator = Regular Bilingual/ESL (ARS.EI = 02)
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 Event Indicator = Flex-CTE (08), Flex-PRS (09), or Flex-Special Ed Mainstream (12) (ARS.EI = 08, 09, or 12)
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 (In Development) ↑
(multiple allowed)
- Extracted if Event Indicator= 10 (Flexible Special Education) (ARS.EI = 10)
Information below is subject to change.
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 | 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 |
E1045 (C177) | FlexAttendanceProgram | Student Attendance Details Report Calculated when report is run | ARS.FA |
E0173 (C035) | InstructionalSetting | Student Attendance Details Report Calculated when report is run | ARS.INS |
E1051 | FlexAttendDaysEligibleInInstrSetting | Student Attendance Details Report Calculated when report is run | ARS.ELIP |
E1052 | FlexAttendExcessMinutesInInstrSetting | Student Attendance Details Report Calculated when report is run | ARS.ME |
Entity: FlexibleCTEProgramReportingPeriodAttendance (In Development) ↑
(multiple allowed)
Information below is subject to change.
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 | To be determined | |
E0934 (C130) | ReportingPeriod | To be determined | |
E0017 (C050) | GradeLevel | To be determined | |
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 | To be determined | |
E1045 (C177) | FlexAttendanceProgram | To be determined | |
E1053 | FlexAttendTotalCareerTechMinutesPresent | To be determined |
Entity: FlexibleBilingualESLProgramReportingPeriodAttendance ↑
(multiple allowed)
- Extracted if Event Indicator = Flexible Bilingual/ESL (ARS.EI = 07)
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.