Overview
PowerSchool SIS now calculates Special Education Tier of Intensity (TOI) attendance for the Ed-Fi Six Week Reporting Periods. This release adds two things:
-
A nightly calculation: The nightly attendance process now calculates TOI attendance and saves it in two new tables, one for regular attendance and one for Flex attendance.
-
The Attendance (Sped TOI) page: A new Ed-Fi Reporting tab where you can check each student's TOI attendance and troubleshoot Ed-Fi reporting problems before or after you submit data.
How TOI attendance is calculated
TOI attendance only counts days when a student's Special Education (SpEd) record and Tier of Intensity record are both active.
-
Start of counting: TOI days start on the later of the SpEd start date and the Tier start date. For example, if SpEd starts on 08/12/2026 and the Tier starts on 09/11/2026, TOI days start on 09/11/2026.
-
Eligible days: Only eligible days when the student was present are counted. These follow the existing SpEd attendance rules, including the ADA factor, attendance, RA/RS, Flex minutes and excess minutes.
-
What isn't used: Speech and instructional setting don't decide whether a day counts toward TOI attendance.
-
Multiple Tier records: Tier records that don't overlap appear as separate rows, and each row only counts days in its own date range.
-
Gaps: No TOI days are counted between two Tier records.
-
No row: If a student has no active Tier record, or the SpEd and Tier dates don't overlap, no TOI row is created.
Before you begin
Make sure the student has all of the following:
-
Enrollment at a school that has a calendar and reporting periods set up.
-
Daily attendance recorded for in-session days. Absent days aren't counted.
-
A SpEd special program record covering the relevant dates. It must not be excluded from Ed-Fi.
-
An IOS special program record on the SPEDIOS program, with a Tier of Intensity value (for example,
01). Its dates must overlap the SpEd record, and it must not be excluded from Ed-Fi.
For Flex TOI attendance, the student also needs:
-
ADA code
7 -
A Flex program
-
The district Flex preference set to Manual or Calculated
When TOI attendance is calculated
TOI attendance is recalculated in two ways:
-
Nightly attendance process: Runs every night.
-
When you open the page: The Attendance (Sped TOI) page recalculates every time you open it, the same way the other Ed-Fi attendance calculation pages do.
Note: Creating or changing SpEd or IOS records doesn't update TOI attendance right away. Open the page again, or wait for the nightly process, to see your changes.
View TOI attendance
-
Go to Compliance.
-
Select Ed-Fi Reporting.
-
Select the Attendance (Sped TOI) tab.
-
Wait for the refresh to finish. The page then shows the latest data.
Records are sorted by default in this order:
-
Reporting Period
-
School
-
Cal Code (Trk)
-
Grade Level
Table field reference
Both tables are child tables of STUDENTS. The field details come from the table definition files attached to. The page label is filled in only where the ticket confirms it.
S_TX_STU_ATT_SPED_TIER_C (regular TOI attendance)
What makes each row unique: student, school, calendar, reporting period, grade and Tier. Instructional setting isn't part of the key, so rows are added up across instructional settings.
|
Field name |
Page label |
Data type |
Description |
|---|---|---|---|
|
SCHOOLID |
School |
String (9) |
Reportable school ID |
|
STU_UID |
— |
Integer |
Student unique ID |
|
E0975_CALENDAR_CODE |
Cal Code (Trk) |
String (2) |
Calendar code (student track) |
|
E0934_RPT_PERIOD |
Reporting Period |
String (2) |
Reporting period |
|
E0017_GRADE_LEVEL |
Grade Level |
String (2) |
Grade level |
|
E0935_DAYS_TAUGHT |
— |
Integer |
Number of days taught |
|
E0944_SPED_IS_DAYS_PRES |
— |
Double |
Eligible days present in the Special Education Tier |
|
E1690_SPED_IS_RS_DAYS_PRES |
— |
Double |
RS eligible days present in the Special Education Tier |
|
E1691_SPED_IS_RA_DAYS_PRES |
— |
Double |
RA eligible days present in the Special Education Tier |
|
E0945_SPED_IS_EXCESS_HRS |
— |
Double |
Excess hours in the Special Education Tier |
|
E1694_SPED_IS_RS_EXCESS_HRS |
— |
Double |
RS excess hours in the Special Education Tier |
|
E1695_SPED_IS_RA_EXCESS_HRS |
— |
Double |
RA excess hours in the Special Education Tier |
|
E0833_RDSPD |
— |
String (1) |
Regional Day School Program for the Deaf (RDSPD) code |
|
E1527_DIST_RDSPD |
— |
String (6) |
District (LEA) providing the RDSPD service |
|
E3153_TIER_OF_INTENSITY |
— |
String (2) |
Tier of Intensity (C371) value, taken from |
|
YEARID |
— |
Integer |
School year |
|
MARK_FOR_DELETE |
— |
Boolean |
Shows whether the record is marked for deletion |
S_TX_STU_ATT_FLEX_SPED_TIER_C (Flex TOI attendance)
What makes each row unique: the same as the regular table, plus Flex program and instructional setting.
|
Field name |
Page label |
Data type |
Description |
|---|---|---|---|
|
SCHOOLID |
School |
String (9) |
Reportable school ID |
|
STU_UID |
— |
Integer |
Student unique ID |
|
E0975_CALENDAR_CODE |
Cal Code (Trk) |
String (2) |
Calendar code (student track) |
|
E0934_RPT_PERIOD |
Reporting Period |
String (2) |
Reporting period |
|
E0017_GRADE_LEVEL |
Grade Level |
String (2) |
Grade level |
|
E0935_DAYS_TAUGHT |
— |
Integer |
Number of days taught |
|
E1045_FLEX_PROG |
— |
String (2) |
Flexible attendance program code |
|
E1073_FLEX_SPED_IS |
— |
String (2) |
Instructional setting code |
|
E1051_FLEX_SPD_IS_DAYS_PRES |
— |
Double |
Flex eligible days in the Special Education Tier |
|
E1052_FLEX_SPD_IS_EXCS_MIN |
— |
Integer |
Flex excess minutes in the Special Education Tier |
|
E3153_TIER_OF_INTENSITY |
— |
String (2) |
Tier of Intensity (C371) value, taken from |
|
YEARID |
— |
Integer |
School year |
|
MARK_FOR_DELETE |
— |
Boolean |
Shows whether the record is marked for deletion |
Troubleshooting
|
Problem |
What to check |
|---|---|
|
A student doesn't appear |
Check that the student has both a SpEd record and an IOS (SPEDIOS) record with a Tier of Intensity, that their dates overlap, and that neither is excluded from Ed-Fi. |
|
Eligible days look too low |
TOI days only start when both records are active. Check the start and end dates on the SpEd and IOS records. |
|
A student has more than one row |
Each Tier record that doesn't overlap another gets its own row. This is expected. |
|
An old Tier row is still showing |
If you ended or deleted an IOS record, open the page again (or wait for the nightly process) so the old row is removed. |
|
Days are missing between two Tier records |
No days are counted in a gap between Tier records. This is expected. |
|
No Flex TOI data |
Check that the student has ADA code |