020 – Instructional Program
Introduction
This extract includes a record for each instructional program created at the school level. Districts can set up a calendar for each unique attendance schedule used at the school level (Start Page > District Setup > District Info > TN 200 Day Calendar). Students, teachers, and sections (classes) are associated to each calendar using school-specific Instructional Program numbers. For example, Calendar Number 01 may be associated with Instructional Program number 01 at School 100. At School 100, assign Instructional Program number 01 to data elements that use that attendance calendar: teachers (Edit Information staff page), sections (Edit Section page), and students (using tracks on the Transfer Info > Edit Current/Previous Enrollment page).
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
- The school data is only reported for the Primary school and will not report from the Alternative School Number, except when the school number is invalid and the alternate school number (ASN) is populated and does not match another school number in the district. Then the ASN is reported as the School ID. See the School ID data element in the table below for more information.
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 "020" | 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 [Prefs]Name=districtnumber | 3 | N |
6 | School ID | The school number. Note: If the school number is invalid and the alternate school number (ASN) is populated and does not match another school number in the district, the ASN is reported as the School ID. If the ASN matches another school number in the district, the 020 extract will not report. | [S_TN_SCH_InstrProgram_C]SchoolID [Schools]Alternate_School_Number | 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 [Terms]LastDay | 4 | N |
8 | Calendar Number | The number for this school year that the district has assigned to uniquely identify the calendar within the district. | [S_TN_SCH_InstrProgram_C]CalendarNumber | 2 | Y |
9 | 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_SCH_InstrProgram_C]InstructionalProgramNbr | 2 | Y |
10 | Instructional Calendar | The type of instructional calendar, either traditional or year round. | [S_TN_SCH_InstrProgram_C]InstructionalCalendar | 1 | Y |
11 | Student Day | The length in minutes for a standard full-time day of instruction including lunch, for students in this program within the school. | [S_TN_SCH_InstrProgram_C]StudentDayLength | 3 | Y |
12 | Teacher Day | The length in minutes for a standard full-time day of instruction including lunch, for teachers in this program within the school. This value is usually the student day plus the time teachers are required to be at the school both before student arrival and after student departure. | [S_TN_SCH_InstrProgram_C]TeacherDayLength | 3 | Y |
13 | School Stockpile Professional Development Days | This value is reported if the district does not stockpile days, but specifically stockpiles professional development days. | [S_TN_SCH_InstrProgram_C]Stockpile_PDD | 2 | N |
14 | Block Schedule | The value is Yes or No to indicate whether a block schedule is used for this school. | [S_TN_SCH_InstrProgram_C]BlockSchedule | 1 | Y |
15 | Block Schedule Date | The date that the spring block schedule begins. This field should only be reported if Block Schedule is Yes. | [S_TN_SCH_InstrProgram_C]SpringBlockScheduleDate | 8 | Y |
16 | Filler | N/A | N/A | 11 | N |