South Dakota School Calendar Extract

Tool Search: SD Extract

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

The School Calendar Extract describes the calendar(s) which are attached to schools. To generate this extract, select School Calendar from the Extract Type field on the SD Extract  editor.

Screenshot of the School Calendar Extract, located at Reporting, SD State Reporting, SD ExtractSchool Calendar Extract

Report Logic

At least one record will report for each school. Multiple records per school can occur if that school has multiple calendars, as in the case of a school which has a main school and calendar and an alternative school and calendar.

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 Calendar Extract Layout

The following tables describe the fields which appear in the School Calendar 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 Calendar Records

Element Name

Description

Location

Record Type

Type of record being generated. Always reports the value of "SS".


Alphabetic, 2 characters

Not dynamically stored

District Number

State-assigned district identification number.


Numeric, 5 digits

District Information > State District Number


District.number

School Number

State-assigned school identification number.


Numeric, 2 digits

School Information > State School Number


School.number

Year

The end year of the calendar.


Date field, 4 characters (YYYY)

Calendar Information > End Date


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 > Calendar ID


Calendar.number

Calendar Type

The type of calendar for which information is being reported.


Alphanumeric, 1 character

 Calendar Information > Type


Calendar.type

Student Day

The number of minutes of instruction in a typical student day, as entered in the Student Day field of the Calendar.


Numeric, 3 digits

Calendar Information > Student Day (minutes)


Calendar.studentDay

4 Day School Week

Indicates a 4 Day School Week.


Alphanumeric, 1 character (Y or N)

 Calendar Information > 4 Day School Week


Calendar.alternativeCode

VirtualIndicates if the calendar is 100% virtual.
If the Virtual checkbox is marked on the Calendar, report Y. Otherwise, report N.


Alphanumeric, 1 character (Y or N)

Calendar Information > Virtual
Calendar.virtual