South Dakota School Days Extract

Tool Search: SD Extract

This information is current as of the Campus.2427 (July 2024) release. 

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.

Screenshot of the SD Extract with the School Days Extract Type selected, located at Reporting, SD State Reporting, SD Extract.SD Extract - School Days

Special 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: 

  1. 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. 
  2. 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. 
  3. 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