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: Beginning School Year 24-25, all districts will be required to publish Calendar Data. This will be necessary before any enrollments can be published.

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.

String

Derived 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

periodSequence

The 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

name

The 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'

totalInstructionalDays

The 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.

String

Derived 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.