S_TN_SCH_InstrProgram_C (ver 17.9.2)
This table is a child table of the [Schools] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| Unique_ID | 17.9.2 | Number(11,0) | Migrated From [InstructionalProgram]unique_ID. |
| SchoolID | 17.9.2 | Number(11,0) | Migrated From [InstructionalProgram]schoolID. |
| ForeignKey | 17.9.2 | Number(11,0) | Migrated From [InstructionalProgram]foreignKey. |
| ForeignKey_Alpha | 17.9.2 | Varchar2(31) | Migrated From [InstructionalProgram]foreignKey_alpha. |
| CalendarNumber | 17.9.2 | Varchar2(2) | Migrated From [InstructionalProgram]TN_200CalendarNumber. |
| PowerSchoolTrack | 17.9.2 | Varchar2(1) | Migrated From [InstructionalProgram]TN_PowerSchoolTrack. |
| InstructionalProgramNbr | 17.9.2 | Number(11,0) | Migrated From [InstructionalProgram]TN_InstructionalProgramNbr. |
| InstructionalCalendar | 17.9.2 | Varchar2(1) | Migrated From [InstructionalProgram]TN_InstructionalCalendar. |
| KGStudentDayLength | 17.9.2 | Number(11,0) | Migrated From [InstructionalProgram]TN_KGStudentDayLength. |
| StudentDayLength | 17.9.2 | Number(11,0) | Migrated From [InstructionalProgram]TN_StudentDayLength. |
| TeacherDayLength | 17.9.2 | Number(11,0) | Migrated From [InstructionalProgram]TN_TeacherDayLength. |
| BlockSchedule | 17.9.2 | Varchar2(1) | Migrated From [InstructionalProgram]user_defined_text. |
| Stockpile_PDD | 17.9.2 | Number(11,0) | Migrated From [InstructionalProgram]TN_200Stockpile_PDD. |
| SpringBlockScheduleDate | 17.9.2 | Date | Migrated From [InstructionalProgram]user_defined_date. |
| YearID | 17.9.2 | Number(11,0) | Migrated From [InstructionalProgram]user_defined_integer. |