Classic View: SD State Reporting > SD Extracts > School Days
Search Term: 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.
SD Extract - School Days Editor
Report Logic
This extract reports one record per day considered a calendar day when school is open.
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 |
Type, Format and Length |
Campus Database |
Campus Database |
|---|---|---|---|---|
Record Type |
Type of record being generated. In this case, always a value of "DY". |
Alphabetic, 2 characters |
Not dynamically stored |
Not dynamically stored |
District Number |
State-assigned district identification number. |
Numeric, 5 digits |
district.number |
System Administration > Resources > District Information > District Number |
School Number |
State-assigned school identification number. |
Numeric, 2 digits |
school.number |
System Administration > Resources > District Information > State School Number |
Year |
The end year of the calendar (i.e. for 2006-2007 = 2007). |
Date field, 4 characters |
calendar.endYear |
System Administration > Calendar > Calendar > End Year |
Calendar Number |
Number assigned to the calendar. Needs to match calendar number in associated SD-Extract-School Calendar file. |
Numeric, 3 digits |
calendar.number |
System Administration > Calendar > Calendar > Calendar ID |
Date |
A day record for each day in the calendar. |
Date field, 10 characters |
day.date |
System Administration > Calendar > Calendar > Days > Date |
Instructional Day |
Indicates whether instruction was given to students on selected date. |
Alphabetic, 1 character |
day.instruction |
System Administration > Calendar > Calendar > Days > Day Detail > 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 |
day.schoolDay |
System Administration > Calendar > Calendar > Days > Day Detail > School Day |
Attendance Day |
Indicates if there is attendance for selected date. |
Alphabetic, 1 character |
day.attendance |
System Administration > Calendar > Calendar > Days > Day Detail > Attendance |
Day Duration |
Number of minutes of instruction offered on selected date. |
Numeric, 3 digits |
day.duration |
System Administration > Calendar > Calendar > Days > Duration |
