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 |