S_SCH_CALENDARS_C (ver 19.11.1.0)
This table is a child table of the [Schools] table and is primarily used in conjunction with Ed-Fi related functionality. This table available for all states and provinces and may or may not be utilized for your state or province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 19.11.1.0 | Number(11,0) | Primary Key |
SchoolsDCID | 19.11.1.0 | Number(11,0) | The unique DCID in the Schools table. |
CalendarCode | 19.11.1.0 | Varchar2(60) | The identifier for the calendar. |
CalendarType | 19.11.1.0 | Varchar2(50) | The type of calendar - Ed-Fi descriptor. |
MaxGradeLevel | 19.11.1.0 | Number(11,0) | The maximum grade level for the calendar - used in Ed-Fi for gradeLevels array. |
MinGradeLevel | 19.11.1.0 | Number(11,0) | The minimum grade level for the calendar - used in Ed-Fi for gradeLevels array. |
| SchoolId | 19.11.1.0 | Number(11,0) | The School_Number for the referenced school; indexed. |
Track | 19.11.1.0 | Varchar2(1) | The PowerSchool Track letter for the calendar. If no track then 'X' is written to table; indexed. |
YearId | 19.11.1.0 | Number(11,0) | The PowerSchool year id for the calendar; indexed. |