Organization Calendars

This category represents information about sessions, grading periods, and calendars as published within the Education Organization Calendar category. The Organization Calendars category includes the following data views and resources:

Calendar

calendar

One calendar per reporting school.

Primary PowerSchool Source Data

[S_VT_SCH_X]

Selection Criteria

Records are published if the following criteria are met:

A calendar type must be selected.
The school must not be excluded from state reporting.
The Exclude School from Instructional Calendar checkbox is not selected.

Resource Output

	Data Element	Description	Data Type	Stored in [Table]Field	Required
Calendars		Describes school calendars
	calendarCode	The school ID followed by the current year and separated by a hyphen.	String 60	CalendarCode	Yes
	calendarTypeDescriptor	Descriptor	Descriptor	CalendarType_DX	Yes
schoolReference	schoolId	The school for which the calendar date is defined.	Integer	SchoolOrgID	Yes
schoolYearTypeReference	schoolYear	School Year	Integer	SchoolYear	Yes
gradeLevels			Array		Yes
	gradeLevelDescriptor	Descriptor	Descriptor	GradeLevel_DX	Yes

Calendar Dates

This view captures basic information about current year calendar dates as published in the calendarDates resource within the Education Organization Calendar category. The layout includes the School Name, Date, Last Publish Date, Publishing ID, Resource ID.

calendarDates

This resource represents a day in the school calendar.

Primary PowerSchool Source Data

[Calendar_Day]

Selection Criteria

Records are published if the following criteria are met:

The school's school calendar is defined in S_VT_SCH_X
The Event duration is more than one.
The school must not be excluded from state reporting.
The calendar date for the district or the school falls within the year for the Term selected in the PowerSchool UI.

Resource Output

A separate calendarDates record is published for each day for the district, and for each school within the year for the Term selected in the PowerSchool UI.
CalendarDates records include both instructional and non-instructional days.
As multiple events may occur on the same date, a separate calendar event is published for each unique combination of duration and eventDescriptor within the calendarEvent complex type.
The calendarDates resource is dependent on the prior publishing of Ed-Fi resources: schools.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (“Run Now” button).

Click Export to export the data collection results to a spreadsheet application.

	Data Element	Description	Data Type	Stored in [Table]Field	Required
CalendarDates	Describes dates on a school calendar
	date	Calendar date.	Date	DateValue	Yes
calendarReference					Yes
	calendarCode	The school ID followed by the current year and separated by a hyphen.	String 60	CalendarCode	Yes
	schoolId	The school for which the calendar date is defined.	Integer	SchoolOrgID	Yes
	schoolYear	School Year.	Integer 4	SchoolYear	Yes
calendarEvents			Array		Yes
	calendarEventDescriptor	The type of scheduled or unscheduled event for the day, for example, Instructional day, Teacher only day, Holiday.	Descriptor	CalendarEvent_DX	Yes

Back to top

Grading Periods

This view captures the grading periods defined at each school within the district as published in the gradingPeriods resource within the Education Organization Calendar category. The layout provides the School Name, Name of Term, Descriptor, First Day of Term, Last Day of Term, Total Instruction Days, Period Sequence, Last Publish Date, Publishing ID, and Resource ID.

gradingPeriods

This resource represents the time span for which grades are reported.

Primary PowerSchool Source Data

[Terms]

Selection Criteria

Records are published if the following criteria are met:

The school must not be excluded from state reporting.
The term or term portion associated with the grading period exists within the year for the Term selected in the PowerSchool UI.

Resource Output

The gradingPeriods resource is dependent on the prior publishing of the following resources: calendarDate.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).

Click Export to export the data collection results to a spreadsheet application.

	Data Element	Description	Data Type	Stored in [Table]Field	Required
GradingPeriods		Describes school grading periods (aligned with terms and used when reporting grades)
	gradingPeriodDescriptor	The the specific time frame during the school year when grades are assigned.	Descriptor	GradingPeriod_DX	Yes
	beginDate	Start date.	Date	BeginDate	Yes
	endDate	End date.	Date	EndDate	Yes
	periodSequence	An integer value used to uniquely identify and order grading periods within a school year.	Integer	PeriodSequence	Yes
	totalInstructionalDays	Total number of instructional days.	Integer	TotalInstructionalDays	Yes
schoolReference	schoolId	School ID	Integer	SchoolOrgID	Yes
schoolYearTypeReference	schoolYear	School Year	Integer	SchoolYear	Yes

Sessions (Terms)

This view captures the sessions/terms defined at each school within the district as published in the sessions resource within the Education Organization Calendar category. Ed-Fi sessions are the equivalent of PowerSchool terms. The layout provides the School Name, Name of Term, Descriptor, Year, First Day of Term, Last Day of Term, Last Publish Date, Publishing ID, and Resource ID.

sessions

This resource represents the prescribed span of time when an education institution is open, instruction is provided, and students are under the direction and guidance of teachers and/or educational institution administration. A session may be interrupted by one or more vacations.

Primary PowerSchool Source Data

[Terms]

Selection Criteria

Records are published if the following criteria are met:

The school must not be excluded from state reporting.
The term or term portion exists within the year for the Term selected in the PowerSchool UI.

Resource Output

A separate sessions record is published for each unique term record at each school based on [Terms]Portion and [Terms]Abbreviation.
The gradingPeriodReference complex type includes a reference to each unique grading period associated with the session (refer to the Organization Calendars > gradingPeriods resource for additional information).
The sessions resource is dependent on the prior publishing of the following resources: schools.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).

Click Export to export the data collection results to a spreadsheet application.

	Data Element	Description	Data Type	Stored in [Table]Field	Required
Sessions	Describes school terms
	sessionName		String 60	SessionName	Yes
	beginDate	Start date.	Date	BeginDate	Yes
	endDate	End date.	Date	EndDate	Yes
	termDescriptor	The term descriptor defines the term length of a session during the school year (e.g., 1st Quarter or Second Semester, Third Trimester).	Descriptor	Term_DX	Yes
	totalInstructionalDays	Total number of instruction dates.	Integer	TotalInstructionalDays	Yes
schoolReference	schoolId	School ID.	Integer	SchoolOrgID	Yes
schoolYearTypeReference	schoolYear	School Year.	Integer	SchoolYear	Yes
gradingPeriods			Array		Yes
	gradingPeriodDescriptor	Specifies the particular time frame within a school year when grades are assigned and recorded.	Descriptor	GradingPeriod_DX	Yes
	periodSequence	An integer value used to uniquely identify and order grading periods within a school year.	Integer	PeriodSequence	Yes
	schoolId	School ID	Integer	SchoolOrgID	Yes
	schoolYear	School Year	Integer	SchoolYear	Yes