031 – Class Section Schedule
Introduction
This extract includes a record for each section taught during the current school year, specifically reporting the day and period that the section is taught.
For sections with students from another school (concurrent enrollments), the section is reported both for the school at which the section is taught (the concurrent school) and for the school at which the student is enrolled (the student's primary school). The school number for the primary school must be entered in the Primary School field on the Edit Section page at the concurrent school.
Extracting Data for an Individual Section Schedule
You can recreate and extract data for an individual section schedule. The next time the extract is created the recreated data will be included.
- Navigate to the School Setup > [select course] > Edit Section page for the section.
- Select the Recreate 031 - Class Section Schedule checkbox.
- Navigate to Special Functions > Interfaces to other systems > Tennessee Education Information System (EIS) > Recreate Section/Staff Transactions.
- Select the 031 - Class Section Schedule checkbox.
- Click Submit.
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. SeeUnderstanding 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 "031" | 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 ID | The school number. If this section has students from another school, then the section is included in the file for both the school at which the section is taught (the concurrent school for those students) and at their primary school. PowerSchool determines that the section has concurrent students if a value is entered in the Primary School field on the Edit Section page. | [Schools]Alternate_School_Number - if populated [Sections]SchoolID | 4 | N |
7 | 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 |
8 | Instructional Program Number | The number used to uniquely identify the program within the school. Valid values: 01, 02, 03, 04, 05, or 06. | [S_TN_SEC_X]InstructionalProgramNbr | 2 | Y |
9 | Local Class Number | The internal section id value from the section enrollment record or the course number + section number Note: Setting is defined in the district > district info setting: Extract as course.section Yes/No | [Sections]ID or Course_Number+Section_Number | 15 | Y |
10 | Monday Duration | N/A | N/A | 3 | N |
11 | Monday Assigned Period | A value is reported if the section is taught on Monday. This is based on the section expression, which indicates the days and periods during which the section is taught. | [Sections]Expression | 2 | Y |
12 | Tuesday Duration | N/A | N/A | 3 | N |
13 | Tuesday Assigned Period | A value is reported if the section is taught on Tuesday. This is based on the section expression, which indicates the days and periods during which the section is taught. | [Sections]Expression | 2 | Y |
14 | Wednesday Duration | N/A | N/A | 3 | N |
15 | Wednesday Assigned Period | A value is reported if the section is taught on Wednesday. This is based on the section expression, which indicates the days and periods during which the section is taught. | [Sections]Expression | 2 | Y |
16 | Thursday Duration | N/A | N/A | 3 | N |
17 | Thursday Assigned Period | A value is reported if the section is taught on Thursday. This is based on the section expression, which indicates the days and periods during which the section is taught. | [Sections]Expression | 2 | Y |
18 | Friday Duration | N/A | N/A | 3 | N |
19 | Friday Assigned Period | A value is reported if the section is taught on Friday. This is based on the section expression, which indicates the days and periods during which the section is taught. | [Sections]Expression | 2 | Y |
20 | Saturday Duration | N/A | N/A | 3 | N |
21 | Saturday Assigned Period | A value is reported if the section is taught on Saturday. This is based on the section expression, which indicates the days and periods during which the section is taught. | [Sections]Expression | 2 | Y |
22 | Filler | N/A | N/A | 20 | N |