ScheduleCC, 111 (ver3.6.1)
This is the scheduler version of the CC (current curriculum) table, which holds information about student section enrollments.
| 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. |
BuildID | 3.6.1 | Number(10,0) | The internal number for the Schedule Build with which this record is associated. |
Course_Number | 3.6.1 | Varchar(11) | The name of the course assigned by school or district, such as Algebra. Indexed. |
DateEnrolled | 3.6.1 | Date | The date student enrolled in this section. Usually the terms firstday. |
DateLeft | 3.6.1 | Date | Date student ended this section enrollment. Usually its Terms lastday +1. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
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. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
LoadLock | 5.0.0 | Number(10,0) | Lock individual students' schedules from load. |
Period | 3.6.1 | Varchar(7) | Used for backward compatibility. These indicate the period for this section. Changed to Expressions. From ScheduleSections, Period_Obsolete. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SectionID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Sections 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. This is implied by the SectionID but stored here for convenience. |
StudYear | 3.6.1 | Number(10,0) | The student ID + YearID. Speeds selection of student courses this year. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
TeacherID | 3.6.1 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. |
TermID | 3.6.1 | Number(10,0) | The internal number for the term with which this record is associated. |