SPC - Sponsor Site Calendar

Contents

Introduction

The Sponsor Site Calendar is used to identify the time allocated to instruct students. The calendar is also used to edit Student Information System dates, calculate ADA and ADM, and verify compliance with mandated minimum days/minutes of instruction. The instructional school year begins and ends on the first and last days of instruction. Instruction time includes any time spent on in class, on testing or evaluation, but excludes whole or part-days where students only receive report cards. The regular school session calendar may range from a traditional two-semester school year to a year-round school year with four semesters. The regular school session does not include summer school. Calendars should be submitted for each district. It is recommended to submit calendars for individual sites as well.

Collection periods:

Planned Calendars – Submit planned instructional time.
Actual Calendars – Replace the planned calendar with the actual calendar during the spring update.

All values extracted on this report can be entered via Start Page > District Setup > District Info > Click HERE to Create/Edit Sponsor Site Calendar Information.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

School Selection

The report selects records from the [Schools] table that are not excluded from state reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. If sub-districts are enabled: Select Sub-district – Select sub-districts to include in the report. To select a single sub-district, click that sub-district. To select multiple schools, use Ctrl+Click and select each sub-district to be included. Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.. (See Sub District below)
Destination	Choose one of the following from the pop-up menu: Browser – View the report results in a browser. Save as Local File (Default) – Save the report results as a text file to your computer and view the results using a text editor.
Select Sub District	This option will only appear if your district supportssub districts. Leave blank to run the report for all calendars or select asub districtto run the report for asub districtand all schools that are part of thatsub district.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Note: S_LA_CalendarSpc_S and S_LA_CalendarSpc_Event_C are virtual tables as described in Virtual Tables earlier in this document.

Item #	Data Element	Description	[Table]FieldName	Length
1	System ID	Always extracted as “SPC.”	N/A	3
2	School Session Beginning Year	The beginning year of a school session, such as 2010 for 2010-2011. This is the school year selected at report runtime. To change this value, click Term at the top of the page, choose the correct term and re-run the report.	[Terms]FirstDay [Terms]LastDay	4
3	LEA Code	The LEA code (district number) of the district submitting data.	[Prefs]Value where [Prefs]Name=districtnumber	3
4	School/Site Code (where applicable)	The school’s site code. This field should be blank if this is the district (sponsor) calendar.	[S_LA_CalendarSpc_S]SiteCode	6
5	Calendar Code	The unique, district-assigned code identifying the particular calendar for a particular LEA and/or school/site and/or grade level.	[S_LA_CalendarSpc_S]CalendarCode	3
6	Record Type	Always extracted as “10,” to indicate the basic calendar for school session (excluding summer school).	“10”	2
7	First Day of Class	The first day that students attend class for the school year. This is the first day devoted to teach classes outlined in the LA DOE Program of Studies and LEA Pupil Progression Plan.	[S_LA_CalendarSpc_S]First_Day	8
8	Last Day of Class	The last day that students attend class for the school year.	[S_LA_CalendarSpc_S]Last_Day	8
9	Calendar Code Description	A description of the calendar. This field is optional and may be reported blank.	[S_LA_CalendarSpc_S]Calendar_Code_Description	25
10	Minutes Per Day	The number of instructional minutes in a standard school day for this particular calendar.	[S_LA_CalendarSpc_S]Minutes_Per_Day	3
11	Periods Per Day	The number of class periods in a standard school day for this particular calendar.	[S_LA_CalendarSpc_S]Periods_Per_Day	1
12	01 – First Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]First_Grade = 01	2
13	02 – Second Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Second_Grade = 02	2
14	03 – Third Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Third_Grade = 03	2
15	04 – Fourth Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Fourth_Grade = 04	2
16	05 – Fifth Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Fifth_Grade = 05	2
17	06 – Sixth Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Sixth_Grade = 06	2
18	07 – Seventh Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Seventh_Grade = 07	2
19	08 – Eighth Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Eighth_Grade = 08	2
20	09 – Ninth Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Ninth_Grade = 09	2
21	10 – Tenth Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Tenth_Grade = 10	2
22	11 – Eleventh Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Eleventh_Grade = 11	2
23	12 – Twelfth Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Twelfth_Grade = 12	2
24	T9 – Transitional Ninth Grade	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]TransNinth_Grade = T9	2
25	Filler	Filler	N/A	2
26	Infants	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Fifteenth_Grade = 15	2
27	Preschool	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Twentieth_Grade = 20	2
28	Prekindergarten	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Twenty_Fourth_Grade = 24	2
29	Kindergarten	Indicates whether the sponsor offers services for this grade level.	[S_LA_CalendarSpc_S]Twenty_Fifth_Grade = 25	2
30	Ungraded	Not Collected.	N/A	2
31	Number of Semesters	The number of semesters in the school year, excluding summer school.	[S_LA_CalendarSpc_S]Num_Of_Semesters	1
32	Filler	N/A	N/A	45
Event Data
33	System ID	Always extracted as “SPC.”	N/A	3
34	School Session Beginning Year	The beginning year of a school session, such as 2010 for 2010-2011. This is the school year selected at report runtime. To change this value, click Term at the top of the page, choose the correct term and re-run the report.	[Terms]FirstDay [Terms]LastDay	4
35	LEA Code	The LEA code (district number) of the district submitting data.	[Prefs]Value where [Prefs]Name=districtnumber	3
36	School/Site Code (where applicable)	The school’s site code. This field should be blank if this is the district (sponsor) calendar.	[S_LA_CalendarSpc_S]SiteCode	6
37	Calendar Code	The unique, district-assigned code identifying the particular calendar for a particular LEA and/or school/site and/or grade level.	[S_LA_CalendarSpc_S]CalendarCode	3
38	Record Type	The type of event. Valid values: 20 – Teacher-only Days (whole days) 30 – Holidays (whole weekdays) 40 – Student Early Dismissal (partial weekdays) 50 – Emergency Days (whole weekdays) 60 – Make-up Time (whole or partial days)	[S_LA_CalendarSpc_Event_C]Record_Type	2
39	Beginning Date	The first day of the event.	[S_LA_CalendarSpc_Event_C]Beginning_Day	10
40	Ending Day	The last day of the event.	[S_LA_CalendarSpc_Event_C]Ending_Day	10
41	Event Description	A brief description of the event, such as “Christmas.”	[S_LA_CalendarSpc_Event_C]Event_Description	25
42	Instructional Time	The amount of instructional time allocated to the event. Report only for record types 40 and 60. Leave this field blank for record types 20, 30, and 50.	[S_LA_CalendarSpc_Event_C]Instructional_Time	3
43	Filler	N/A	N/A	85

Back to Top