Calendars
This category captures the calendar data used to publish the MARSS A Report.
calendar
This resource represents calendars for each school for which data is being published.
Primary PowerSchool Source Data
- [Schools]
- [Terms]
- [S_MN_SCH_SchoolGrades_C]
Selection Criteria
Records are published if the following criteria are met:
- The school cannot be marked as Excluded from State Reporting.
- Grade Levels must be set up on the A File Setup page for each school.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
schoolReference / schoolId | A reference to the related school. | String | Determined by the school that the data is being generated for. | R |
schoolYearTypeReference / schoolYear | The school year associated with the calendar recorded as the later calendar year of the school year. For example, the 2019-2020 school year is recorded as 2020. | String | Determined by the term selected on the PowerSchool screen. | R |
calendarCode | A unique calendar code is required per calendar that is published. Each Kindergarten setup will have a unique calendar. All other calendars will be one per school. | String | WHEN [S_MN_SCH_SchoolGrades_C]Sch_Grd_Lvl = EC or HK THEN combination of:
WHEN [S_MN_SCH_SchoolGrades_C]Sch_Grd_Lvl = begins with K, P or R THEN combination of:
Otherwise, combination of:
| R |
calendarTypeDescriptor | Hardcoded value to 'School/Grade Characteristics'. | String | Hardcoded to 'School/Grade Characteristics'. | R |
gradeLevels array (1-many) A list of valid grade levels for this calendar. | R | |||
calendarGrades / gradeLevelDescriptor | List of grades that this calendar applies to. If a grade is a kindergarten grade level, then there will only be one value selected. Otherwise, all grade levels associated will be selected. | Date-time | [S_MN_SCH_SchoolGrades_C]Sch_Grd_Lvl | O |
Minnesota Extensions ( _ext / MN ) The following are extensions added to the Ed-Fi Specification specific to Minnesota. | R | |||
kindergartenScheduleDescriptor | Kindergarten schedule descriptor as entered into the A File Setup page for a school. | Boolean | [S_MN_SCH_SchoolGrades_C]KG_Sched_Indicator | O |
instructionalDays | The total membership values of In Session days for a given calendar and/or track. | String | [Calendar_Day]MembershipValue If the MembershipValue is 0, but the day is In Session, then 1.0 will be used. Otherwise, the value entered into MembershipValue will be used. | O |
lengthOfDay | The Length of the day as entered into the A File Setup page for a school. | String | [S_MN_SCH_SchoolGrades_C]Length_Sch_Day_Min | O |