ScheduleConstraints, 110 (ver3.6.1)
This table stores information about restrictions on a schedule such as Student-Teacher avoidance or Course restrictions.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
BuildID | 3.6.1 | Number(10,0) | The internal number for the Schedule Build with which this record is associated. |
CatalogID | 3.6.1 | Number(10,0) | The internal number for the Schedule Catalog with which this record is associated. |
Classroom | 3.6.1 | Varchar(10) | Must be a valid Room number for ScheduleRoom table. Required for Code 11. |
CodeID | 3.6.1 | Varchar(15) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ConstraintCode | 3.6.1 | Varchar(8) | Fixed static value that categorizes this constraint, such as 31=Teacher Free. |
Constraint Field3 | 3.6.1 | Varchar(15) | Text field for flexibility in defining constraint (not currently used by scheduler). |
ConstraintFlagField1 | 3.6.1 | Number(10,0) | Flag for Code 5, must be true, to indicate that this constraint is a Student/Teacher Avoid constraint, rather than a Student Preference constraint (false). For Code 9, the constraint only applies to the days (not currently used). |
ConstraintFlagField2 | 3.6.1 | Number(10,0) | Flag for Code 9, the constraint only applies to the periods. Not currently used. |
ConstraintFlagField3 | 3.6.1 | Number(10,0) | Flag for Code 9, the constraint only applies to the term specified (not currently used). |
ConstraintKeyID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
ConstraintNumber | 3.6.1 | Number(10,0) | For code 94, this number represents how many sections need to be teamed between the two courses and teachers specified in the constraint record. For example, if the teachers both teach 3 sections of their respective courses, but if 2, then only 2 sections will be teamed. Must be greater than 0. For Code 95 (not currently used), the number of periods to hold in common. |
ConstraintNumber2 | 3.6.1 | Number(10,0) | Number field for flexibility in defining constraint Text field for flexibility in defining constraint. Indexed. |
ConstraintTextField1 | 3.6.1 | Varchar(10) | Text field for flexibility in defining constraint Text field for flexibility in defining constraint. |
ConstraintTextField2 | 3.6.1 | Varchar(12) | Text field for flexibility in defining constraint Text field for flexibility in defining constraint. |
CourseNumber | 3.6.1 | Varchar(20) | The name of the course assigned by school or district, such as Algebra. Required for Code |
CourseNumber2 | 3.6.1 | Varchar(20) | The name of the course assigned by school or district, such as Algebra. Required for Code 92. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Expression | 3.6.1 | Varchar(8 0) | 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. Required for Code 1, 6, 9 and 16. |
GroupSchedule | 3.6.1 | Varchar(1 2) | Not currently used by the scheduler but it is copied. |
MaximumNumber | 3.6.1 | Number(10,0) | Not yet used but for Code 2 this would be the maximum number of periods teacher must be scheduled consecutively only if both Periods are missing otherwise this would be after or before the period entered. For code 9 (not yet used either) the number of sections to schedule for that day. |
MinimumNumber | 3.6.1 | Number(10,0) | Used for Code 18 to indicate the minimum number of combinations to sample for Course Optimization (must be greater than 0). For Code 9, the minimum number of section(s) to get scheduled during one or more specific periods and/or one or more specific day (not currently used for this Code). |
NewRecord | 3.6.1 | Number(10,0) | Flag to indicate when a new constraint is added. It used to check against other constraints to see if duplicate exist and deleting it. Then this is set to False. |
Other | 3.6.1 | Varchar(10) | For Code 30 (not currently used), the number of days in the list of combinations provided must be a multiple of the course frequency. For example, if the frequency is 3, then the number of days provided must be a multiple of 3, i.e., 3, 6, 9, etc., since each group of 3 days represents one valid day combination. |
Percent | 3.6.1 | Number(10,0) | Used for Code 18 to indicate the percent sampling to use for Course Optimization (must be greater than 0 and less than or equal to 100). |
Period | 3.6.1 | Varchar(7) | Period number (1,2,etc.) for this section related constraint. Required for code 31 and must be less than the last period of the day of the school - not yet used. Optional for Code 2 and if period2 is selected, this would be the beginning period. |
Period2 | 3.6.1 | Varchar(7) | Period number (1,2,etc.) for this section related constraint. Optional for Code 2 and if Period is selected this would be the ending period. |
Portion | 3.6.1 | Varchar(20) | Not currently use for any constraint but the fraction of a year the term takes. A Semester is 1/2 a quarter 1/4. Internally only the denominator, the bottom part of the fraction, is stored. |
PreloadCount | 3.6.1 | Number(10,0) | Before loading the students, the count of students scheduled in the sections is preloaded by increasing it by the preload count from this constraint. Required for Code 20 and must be greater than 0. |
Priority | 3.6.1 | Number(10,0) | Constraint or Student priority. |
ScheduleExpressionBitmap | 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. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SectionNumber | 3.6.1 | Varchar(10) | Section number associated with this record. Required for Code 5 (if Student preferences ConstraintFlag = False), 93, 92 (must be same for both course numbers). |
SectionNumber2 | 3.6.1 | Varchar(10) | Section number associated with this record. Required for code 92 and must be same for both course numbers. |
SectionType | 3.6.1 | Varchar(2) | SectionTypeCode from ScheduleSectionTypes associated with this record. Optional for code 16. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. Note: Required for Code 5, 6 and 7. |
StudentID2 | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. Note: Required for Code 7. |
TeacherID | 3.6.1 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. Required for codes 1,2,5,20,94. |
TeacherID2 | 3.6.1 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. This second Teacher ID is required for code 93. |
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 a team for a course must also be flagged. |
Term | 3.6.1 | Varchar(5) | Term abbreviation used for this constraint record. Ex, S1, 02-03. Required for Code 5 if Student Preference - see ConstraintFlag = False. |
TermID | 3.6.1 | Number(10,0) | The internal number for the term with which this record is associated. |
Type | 3.6.1 | Varchar(8) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
YearID | 3.6.1 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. |