ScheduleSections, 112 (ver3.6.1)
This is the scheduler version of the Sections table, which maintains occurrences of courses in a period and other related information such as Teacher and Grade level.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Bitmap | 3.6.1 | BLOB | A binary string holding the actual schedule for the class. Some can understand this string, but the schedule expression is the text representation of this. |
Blockperiods_Obsolete | 3.6.1 | Varchar(20) | Used for backward compatibility. These indicate the block of periods this section spans. Changed to Expressions. |
BuildID | 3.6.1 | Number(10,0) | The internal number for the ScheduleBuild with which this record is associated. Indexed. |
Building | 3.6.1 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
CampusID | 3.6.1 | Number(10,0) | No longer used by the application, but is still used for copying purposes. |
Comment_Value | 3.6.1 | CLOB | An optional area to describe any information about this item. Note: The column name was renamed from Comment to Comment_Value in ver5.2.0. |
Course_Number | 3.6.1 | Varchar(20) | The name of the course assigned by school or district, such as Algebra. Indexed. |
CreditType | 3.6.1 | Varchar(20) | The type of credit this course counts as toward graduation, such as Math or elective. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Department | 3.6.1 | Varchar(12) | Department this section belongs to from ScheduleCourseCatalogs, Sched_Department. Indexed. |
Dependent_Secs | 3.6.1 | CLOB | Text string holding the course numbers of dependent sections. |
ExcludeFromClassRank | 3.6.1 | Number(10,0) | Indicates whether this course should be excluded during class ranking. Valid values: 1=True, to be excluded, 0=False. |
ExcludeFromGPA | 3.6.1 | Number(10,0) | Indicates whether this course should be excluded during GPA calculations. Valid values: 1=True, to be excluded, 0=False. |
ExcludeFromHonorRoll | 3.6.1 | Number(10,0) | Indicates whether this course should be excluded during Honor Roll calculations. Valid values: 1=True, to be excluded, 0=False. |
Expression | 3.6.1 | Varchar(80) | The schedule expression for the section, which is a representation of the day and period it is offered. It may be multiple if offered over several days, such as 2(A) = 2nd period A days. |
GradeScaleID | 3.6.1 | Number(10,0) | The grade scale associated with the section could be the same as the one for the course. |
Grade_Level | 3.6.1 | Number(10,0) | Maintains the grade level for the section. |
House | 3.6.1 | Varchar(10) | If this section is located in a house, then its name would be maintained here, such as school that separate 9,10 grade into a house and 11,12 into another. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
LockedSection | 3.6.1 | Number(10,0) | Indicates whether or not this section is locked and should not accept more students. |
MaxEnrollment | 3.6.1 | Number(10,0) | The maximum number of students for this particular section. |
Maxcut | 3.6.1 | Number(10,0) | Flag indicating whether or not to accept more enrollments if maximum number of enrollments has been reached. |
Max_Load_Status | 5.0.12 | Varchar(24) | Used to identify those teachers who are scheduled to teach more students in a day than is allowed by their contract. |
NoAttendance | 3.6.1 | Number(10,0) | Flag indicating if this section is used in the ADA/ADM calculation or not. 0=Yes, do not count. 1=No., count. |
No_of_Students | 3.6.1 | Number(10,0) | The number of students currently enrolled in this section. |
Period_Obsolete | 3.6.1 | Varchar(7) | Used for backward compatibility. These indicate the period for this section. Changed to Expressions. |
Room | 3.6.1 | Varchar(10) | The room number the section is in. This is not presently tied to PowerScheduler, so it will need to be imported or entered manually. Indexed. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SectionType | 3.6.1 | Varchar(2) | SectionTypeCode from ScheduleSectionTypes associated with this record. |
Section_Number | 3.6.1 | Varchar(10) | The section number associated with this class. Indexed. |
Teacher | 3.6.1 | Number(10,0) | The internal ID of the teacher for this particular section. Indexed. |
Team | 3.6.1 | Varchar(10) | Name assigned to a team. Some schools sometimes assign students and teachers to teams to provide the best support and monitoring system. Optional for code 16 but course also has to be flagged to use this team. |
TermID | 3.6.1 | Number(10,0) | The internal number for the term with which this record is associated. Indexed. |
Unused1 | 3.6.1 | Number(10,0) | Currently unused field. |
WhereTaught | 3.6.1 | Number(10,0) | A field for the USOE report. School ID of where this section is being taught if other than current school. 0=current school. |