Classic View: SD State Reporting > SD Extracts > School Calendar
Search Term: SD Extract
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.
SD Extract - School Calendar Editor
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.
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 |
Type, Format and Length |
Campus UI and Database Location |
|---|---|---|---|
Record Type |
Type of record being generated. |
Alphabetic, 2 characters |
Not dynamically stored |
District Number |
State-assigned district identification number. |
Numeric, 5 digits |
System Administration > Resources > District Information > State District Number District.number |
School Number |
State-assigned school identification number. |
Numeric, 2 digits |
System Administration > Resources > School > State School Number School.number |
Year |
The end year of the calendar (i.e. for 2006-2007 = 2007). |
Date field, 4 characters |
System Administration > Calendar > Calendar > Calendar Info > 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 |
System Administration > Calendar > Calendar > Calendar ID Calendar.number |
Calendar Type |
The type of calendar for which information is being reported. |
Alphanumeric, 1 character |
System Administration > Calendar > Calendar > 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 tab. |
Numeric, 3 digits |
System Administration > Calendar > Calendar > Student Day (minutes) Calendar.studentDay |
4 Day School Week |
Indicates a 4 Day School Week. |
Alphanumeric, 1 character |
System Administration > Calendar > Calendar > 4 Day School Week Calendar.alternativeCode |
| Virtual | Indicates 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 |
System Administration > Calendar > Calendar Info > Virtual Calendar.virtual |
Calendar Type Options
Code |
Description |
|---|---|
A |
Alternative |
B |
Homebound |
H |
Homeschooled |
I |
Instructional |
O |
Other |
P |
Private |
R |
Residential |
S |
Summer School |
X |
Outside District |
