011 – 200 Day Event Calendar
Introduction
This extract includes a record for each calendar event, such as in-service day, teacher vacation, etc.
Report Input
For help with navigation and extract generation, see Create Selected District/School/Staff Extract File.
Extract Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Field Length | Track |
---|---|---|---|---|---|
1 | Record ID | The identifier of this record. | Always "011" | 3 | N |
2 | Record Version | The version of this record. | Always "01" | 2 | N |
3 | Record Type | One of the following record types is reported in order to indicate how to modify the state data to match data in PowerSchool. The data in this record either needs to be added to, modified in, or deleted from the state data:
| N/A | 1 | N |
4 | Filler | N/A | N/A | 2 | N |
5 | District ID | The district number. | [Prefs]Value | 3 | N |
6 | School Year | The four-digit year that the instructional program will be operated to provide instructional services to students. This is the current full year term, as defined using the special operation. See the District Setup > Years & Terms section for more information. | [Terms]FirstDay | 4 | N |
7 | Calendar Number | The number for this school year that the district has assigned to uniquely identify the calendar within the district. | [tndistrictcalendar]calendarNumber | 2 | N |
8 | Event Date | The date that the instructional or non-instructional event takes place. | [districtcalendarday]Datevalue | 8 | Y |
9 | Event Type | The event type, such as abbreviated day, calendar start date, in-service day, etc. | [districtcalendarday]Type | 2 | Y |
10 | School Day Type | The school day type, either instructional or non-instructional. | [districtcalendarday]insession | 1 | Y |
11 | Event Duration | The duration of the event, either full day (100), half day (050), or third of a day (033). Note: Schedule name must include Full, Half or Third so that the State reported value can be determined for the day. | [districtbellschedule]name | 3 | Y |
12 | Filler | N/A | N/A | 20 | N |