Tool Search: SD Extract
The School Days Extract details the school days of the selected calendar(s). To generate this extract, select School Days from the Extract Type field on the SD Extract editor. This extract reports one record per day considered a calendar day when school is open.
SD Extract - School DaysSpecial Education data reports from multiple places. Depending on the selected school year, data reports from different areas.
When the selected school year is 2024-25 or earlier, Special Education information reports from the student's Enrollment record for that year.
When the selected school year is 2025-26 or later, Special Education information reports from the Evaluation, Plan, Summary, and Enrollment data. For each field on the report, a logic check is performed in the following order:
- Evaluation - the most recent Start Date that is on or before the effective date if one is selected (or December 1 of the selected school year if one is not selected) and not more than three years in the past, AND has a locked status.
- Plan - the most recent start date that is on or before the effective date if one is selected (or December 1 of the selected school year if none is selected) and not more than one year in the past, AND has a locked status.
- SPED Summary - the start date is on or before the effective date if one is selected (or December 1 of the selected school year if none is selected) and does not have an end date. When that is not found and there is summary data with a start date that is on or before the effective date if one is selected (or December 1 of the selected school year if none is selected) and the end date is after the effective date if one is selected (or December 1 of the selected school year if none is selected).
School Days Extract Layout
The following tables describe the fields which appear in the School Days Extract.
Header Record
Name | Length | Code/Format | Description |
|---|---|---|---|
Record Type | 2 | “HD” | Always the value “HD” |
Date | 10 | MM/DD/YYYY | Date report was generated |
Time | 8 | HH:MM:SS | Time report was generated |
Version | 15 | “SD2.0” | Always the value “SD2.0” |
School Days Records
Element Name | Description | Location |
|---|---|---|
Record Type | Type of record being generated. In this case, always a value of "DY". Alphabetic, 2 characters | Data not stored |
District Number | State-assigned district identification number. Numeric, 5 digits | District Information > District Number District.number |
School Number | State-assigned school identification number. Numeric, 2 digits | District Information > State School Number School.number |
Year | The end year of the calendar. Date field, 4 characters (YYYY) | Calendar Information > End Year Calendar.endYear |
Calendar Number | Number assigned to the calendar. Needs to match calendar number in associated SD-Extract-School Calendar file. Numeric, 3 digits | Calendar Information > CalendarID Calendar.number |
Date | A day record for each day in the calendar. Date field, 10 characters (MM/DD/YYYY) | Days Setup > Date day.date |
Instructional Day | Indicates whether instruction was given to students on selected date. Alphabetic, 1 character (Y or N) | Days Setup > Day Detail > Instruction Day.instruction |
School Day | Indicates if the school was open on selected date (i.e. teacher in-service day will have Instruction = N and School Day = Y). Alphabetic, 1 character (Y or N) | Days Setup > Day Detail > School Day Day.schoolDay |
Attendance Day | Indicates if there is attendance for selected date. Alphabetic, 1 character (Y or N) | Days Setup > Day Detail > Attendance Day.attendance |
Day Duration | Number of minutes of instruction offered on selected date. Numeric, 3 digits | Days Setup > Duration Day.duration |
