Calendar Date
calendarDate
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 Date |
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 | Description | Data View Column Name | Submission | [Table] Field Name | Business Rules | Comments |
CalendarEventDescriptor
| A code or label used to describe specific events on the school calendar. These events can include holidays, professional development days, parent-teacher conferences, and other significant dates that impact the school schedule | Calendar Event Descriptor | Y | [calendar_day]insession | Instructional Day else Holidays |
|
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 |
|
|
Date | The calendar event date. | Date | Y | Schools Calendar | Derived from School Calendar |
|
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. | 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
|
|
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 |