The following tables are used with Attendance History, which you can view on the student’s Attendance History page (Student Data > Attendance History). These tables are calculated by the Attendance History process; they can’t be edited on screen. See Attendance History Configuration.
AHS - Attendance History Summary – stores a summary, by student, school, program and year, of days enrolled, present, absent (excused and unexcused), tardies, truancy, suspensions, in-school suspensions and independent study days. Most counts are based on the all-day code; truancy also counts days with a truant period code.
AHD - Attendance History Details – stores a detailed history of student attendance counts by code, period, school and year.
AHC - Attendance History Codes – stores a history of absence code descriptions for each school.
CHD - Attendance History (Flex) – for Flex scheduling schools, stores student absence counts by code, flex period and year. These records are shown on the Attendance History Details tab.
Attendance History Summary (AHS) fields
A student can have more than one AHS record for a year at the same school: the key is ID, YR, SCL, SP and HS, so there is one record for each program and home school.
| Field | Description | Comment |
| ID | Student ID | Key field. |
| YR | Year | Key field. School year, for example 2025-2026. |
| SCL | School | Key field. |
| SP | Student Program | Key field. Program code from attendance enrollment (ATT/ENR). In Texas this column is labeled ADA Eligibility on the Attendance History page. |
| HS | Home School | Key field. Home school code from attendance enrollment. |
| EN | Enrolled | Days enrolled. Days with a code flagged Temporarily Not Enrolled (ABS.NE) are not counted. |
| PR | Present | Enrolled days minus absent days, independent study days and (in California) in-school suspension days. In Texas, in-school suspension days count as present, and days counted in RA or RS are not included in PR. |
| AB | Absences | All-day code of type Unverified, Excused absence - verified or Unexcused absence - verified. |
| AE | Excused | All-day code of type Excused absence - verified, not flagged Suspension. |
| AU | Unexcused | All-day code of type Unverified or Unexcused absence - verified, not flagged Suspension. |
| TD | Tardies | All-day code of a tardy type. |
| TRU | Days of Truancy | All-day code of type Unexcused absence - verified or flagged Partial Day > 30 Minutes Truant (ABS.PT), not flagged Suspension. Also includes days with a truant period code. |
| SU | Days of Suspension | All-day code flagged Suspension (ABS.SU = True) and not flagged Count for ADA (ABS.AD = False). |
| ISS | Days of In School Suspension | All-day code flagged Suspension (ABS.SU = True) and Count for ADA (ABS.AD = True). |
| ISC | Days of Complete Independent Study | All-day code with Independent Study = Complete (ABS.IS = C). |
| ISI | Days of Incomplete Independent Study | All-day code with Independent Study = Incomplete (ABS.IS = I). |
| PE | Periods Expected to Attend | Calculated only for Alternative Ed schools that use period, positive attendance, or schools with Calculate Attendance Totals Based on Period Attendance turned on. |
| PA | Periods Attended | Calculated only for Alternative Ed schools that use period, positive attendance, or schools with Calculate Attendance Totals Based on Period Attendance turned on. |
| POS | Periods Out-of-School Suspension | Calculated only for Alternative Ed schools that use period, positive attendance, or schools with Calculate Attendance Totals Based on Period Attendance turned on. |
| PIS | Periods Attended In-School Suspension | Calculated only for Alternative Ed schools that use period, positive attendance, or schools with Calculate Attendance Totals Based on Period Attendance turned on. |
| PAX | Periods Absent Excused | Calculated only for Alternative Ed schools that use period, positive attendance, or schools with Calculate Attendance Totals Based on Period Attendance turned on. |
| PAU | Periods Absent Unexcused | Calculated only for Alternative Ed schools that use period, positive attendance, or schools with Calculate Attendance Totals Based on Period Attendance turned on. |
| PIC | Periods Independent Study Complete | Calculated only for Alternative Ed schools that use period, positive attendance, or schools with Calculate Attendance Totals Based on Period Attendance turned on. |
| PIN | Periods Independent Study Incomplete | Calculated only for Alternative Ed schools that use period, positive attendance, or schools with Calculate Attendance Totals Based on Period Attendance turned on. |
| RA | Remote Asynchronous Present | Texas only. |
| RS | Remote Synchronous Present | Texas only. |
In User Security, Attendance History has three entries under Attendance / Enrollment:
- Attendance History Summary (AHS) – Read permission controls access to the Attendance History page, including the Summary, Details and Codes tabs.
- Attendance History Details (Query Only) (AHD) and Attendance History Codes (Query Only) (AHC) – control access to these tables in Query only.
Because the data is calculated by the system, only Read and Mass Update can be set for these entries.
