Calendar
calendar
Primary PowerSchool Source Data
[Terms]
Selection Criteria
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.
Dependencies
Organization Catalog (LEA and School number must match with values downloaded from the state ODS)
Data Review
Field | Selection |
Choose Dashboard | Organization Calendars |
Choose Category
| Organization Calendars info Summary Organization Calendars info Published Organization Calendars info Dependencies Organization Calendars info Errors |
Choose Data view | Calendar |
Note: To enter Calendar Type and Grade Level information for the Calendar resource, enable the School Calendar Setup on the School Info page under the Other Information section.
Resource Output
Ed-Fi Data Element | Data View Column Name | Submission | [Table] Field Name | Business Rules | Comments | |
CalendarCode | A unique identifier assigned to a specific calendar within the school system. This code helps in distinguishing between different academic calendars used by the school or district. | Calendar Code | Y | [s_sch_calendars_c]calendarcode | N/A | At the District Level School Info, Calendar Setup |
SchoolID | A unique identifier assigned to a school within the district. | School Number | Y | [Schools]SIF_StatePRID [Schools]School_Number
| Derived From [Schools]School_Number Format: ttbbbdddd If [Schools]SIF_StatePRID is blank, [Schools]School_number is pulled. The [Schools]SIF_StatePRID or [Schools]School_number must match with the Organization Catalog. | School Number Format: ttbbbdddd Org Id is defaulted to D=14, if the district wants another value to be published then the district must prepend the above alphabet in their district number.
|
SchoolYear | The academic year for which data is being reported, typically spanning from fall of one year to summer of the next. | School Year | Y | Calculated using [TERMS]YearID
| If 2023-2024, then extract 2024
| N/A |
CalendarTypeDescriptor | Indicates the type of calendar being used, such as "Regular School Year," "Summer School," or "Extended Year." This descriptor helps in categorizing the calendar based on its purpose and schedule. | Calendar Type | Y | Defaults: “Student Specific”
|
| Link:Descriptor If only sending one calendar for the school, send the CalendarTypeDescriptor - Student Specific.
|
GradeLevelDescriptor | Indicates the grade level associated with the calendar. | Published as part of JSON. | Y | [s_sch_calendars_c]minGradeLevel [s_sch_calendars_c]maxGradeLevel | At the District Level School Info, Calendar Setup |
Code set Mapping
Mapping Method | Descriptor Name | Namespace | Code Value | Short Description | Description |
Core | CalendarTypeDescriptor | uri://ksde.org/CalendarTypeDescriptor | Student Specific | Student Specific | Student Specific |
Core | CalendarTypeDescriptor | uri://ksde.org/CalendarTypeDescriptor | IEP | IEP | IEP |
Core | CalendarTypeDescriptor | uri://ksde.org/CalendarTypeDescriptor | Grade Level | Grade Level | Grade Level |
Core | CalendarTypeDescriptor | uri://ksde.org/CalendarTypeDescriptor | School | School | School |
Core | CalendarTypeDescriptor | uri://ksde.org/CalendarTypeDescriptor | Staff | Staff | Staff |