Skip to main content
Skip table of contents

ScheduleCC, 111 (ver3.6.1)

This is the scheduler version of the CC (current curriculum) table, which holds information about student section enrollments.

Column NameInitial VersionData TypeDescription

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(20)

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.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.