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: | 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 |
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 | R |
schoolYearTypeReference A reference to the related SchoolYearType resource. | R | |||
/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 | R |
termDescriptor | The term for the session during the school year. For example, 1st Semester, 1st Quarter, etc. | String | Derived from: | R |
name | The identifier for the calendar for the academic session, for example, 2010/11, 2011 Summer. | String | [Terms]Name | R |
beginDate | The month, day, and year of the first day of the session. | Date | [Terms]FirstDay Format:'YYYY-MM-DD' | R |
endDate | The month, day, and year of the last day of the session. | Date | [Terms]LastDay Format:'YYYY-MM-DD' | R |
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 | R |
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. | R | |||
//descriptor | GradingPeriodDescriptor - The name of the period for which grades are reported. | String | Derived from: | 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 |
//beginDate | The month, day, and year of the first day of the grading period. | Date | [Terms]FirstDay | R |