Skip to main content
Skip table of contents

Organization Calendars

This category represents information about organization calendars including calendar dates, terms, and grading periods. The Organization Calendars category includes the following data views and resources:

Note: Organization Calendars resources are only published for public schools.

Grading Periods

This view captures the grading periods defined at each school within the district. The published view layout provides the School Name, Name of Term, First Day of Term, Last Day of Term, Last Publish Date, and Publishing ID.

gradingPeriods

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

Note: Grades are not published at this time; however, gradingPeriods are needed to complete the Ed-Fi calendar structure

Primary PowerSchool Source Data

  • [Terms]
  • [Calendar_Day]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be excluded from state reporting.
  • The school must have an Ed-Fi State School number.
  • The school must have a WISEdata Reporting option.
  • The term or term portion associated with the grading period exists within the year for the Term selected in the PowerSchool UI.

Resource Output

  • A separate gradingPeriod record is published for each unique term at each school.
  • The gradingPeriod resource is not dependent on the prior publishing of other Ed-Fi resources.
  • LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).

Note: Click Export to export the data collection results to an Excel spreadsheet.                       

Data Element

Description

[Table]Data Type

Stored in [Table]Field

Req’d

schoolReference  

A reference to the related School resource.
R

/schoolID

 The school for which the grading period is defined.Integer

SchoolId downloaded from State

Derived from:

[S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then

[Schools]Alternate_School_Number] if greater than 0

Otherwise, [Schools]School_Number

R
descriptor  The name of the grading period during the school year in which the grade is offered. For example, First Semester, First Nine Weeks, etc.StringDerived from: 
[Terms]Portion 
[Terms]Abbreviation
R
beginDate  The month, day, and year of the first day of the GradingPeriod.Date

[Terms]FirstDay

Format:'YYYY-MM-DD'

R
totalInstructionalDays  The total days available for educational instruction during the grading period.Integer

Count of [Calender_Day]Date_Value

If the date value falls between [Terms].FirstDay and [Terms].LastDay and [Calender_Day]InSession = 1

R
endDate  The month, day, and year of the last day of the grading period.Date

[Terms]LastDay

Format:'YYYY-MM-DD'

R
periodSequenceThe sequential order of this period relative to other periods.Integer

If [Terms]Portion = 1: '1'

Otherwise, derived from [Terms]Abbreviation

O

Back to top

Sessions (Terms)

This data view 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 education institution administration. The published view layout provides the School Name, Year, Name of Term, First Day of Term, Last Day of Term, Last Publish Date, and Publishing ID.

sessions

This entity 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 education institution administration. A session may be interrupted by one or more vacations.

Primary PowerSchool Source Data

  • [Terms]
  • [Calendar_Day]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be excluded from state reporting.
  • The school must have an Ed-Fi State School number.
  • The school must have a WISEdata Reporting option.
  • 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 at each school.
  • The sessions resource is not dependent on the prior publishing of other Ed-Fi resources.
  • LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).

Note: Click Export to export the data collection results to an Excel spreadsheet.                       

Data Element

Description

[Table]Data Type

Stored in [Table]Field

Req’d

 schoolReference  

 A reference to the related School resource.

 R

/schoolID

The school related to the session. Integer

SchoolId downloaded from State

Derived from:

[S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then

[Schools]Alternate_School_Number] if greater than 0

Otherwise, [Schools]School_Number

schoolYearTypeReference

A reference to the related SchoolYearType resource.

/schoolYear

The identifier for the school year, recorded as the later calendar year of the school year. For example, 2017-2018 school year is recorded as 2018.Integer[Terms]YearID
termDescriptor  The term for the session during the school year. For example, 1st Semester, 1st Quarter, etc.String Derived from: 
[Terms]Portion 
[Terms]Abbreviation
nameThe identifier for the calendar for the academic session, for example, 2010/11, 2011 Summer.String[Terms]Name
beginDate  The month, day, and year of the first day of the session.Date

[Terms]FirstDay

Format:'YYYY-MM-DD'

endDate  The month, day, and year of the last day of the session.Date

[Terms]LastDay

Format:'YYYY-MM-DD'

totalInstructionalDaysThe total number of instructional days in the school calendar.Integer

Count of [Calender_Day]Date_Value

If the date value falls between [Terms].FirstDay and [Terms].LastDay and [Calender_Day]InSession = 1

sessionGradingPeriod

An unordered collection of sessionGradingPeriods. Grading periods associated with the session calendar. For PowerSchool, session grading periods include the grading period for the term record plus any smaller terms contained within it. For example, a semester session will include its corresponding semester grading period, and, if quarters are defined, it will also include the two nine-week grading periods corresponding to its quarters.   

R

/gradingPeriodReference

A reference to the related GradingPeriod resource.

//descriptor

GradingPeriodDescriptor - The name of the period for which grades are reported.StringDerived from: 
[Terms]Portion 
[Terms]Abbreviation

//schoolId

The school for which the grading period is defined.

Integer

SchoolId downloaded from State

Derived from:

[S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then

[Schools]Alternate_School_Number] if greater than 0

Otherwise, [Schools]School_Number

//beginDate

The month, day, and year of the first day of the grading period.Date[Terms]FirstDay

Back to top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.