Awsched_Constraint, 152 (ver4.0.0)
Load Constraints are used during the scheduling process to communicate specific requirements to the scheduling engine that the engine must adhere to when it is determining a schedule for a student. Users define constraints that generally have to do with specific students prior to using automated walk-in scheduling. These constraints are then exported to the engine along with the other necessary data needed to produce a schedule for the student.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Bitmap | 4.0.0 | BLOB | Used to store the schedule specified for the Student Preference constraint. |
Classroom | 4.0.0 | Varchar(10) | Populated from ScheduleConstraints:Classroom. |
ConstraintFlagField1 | 4.0.0 | Number(10,0) | Populated from ScheduleConstraints:ConstraintFlagField1- True/False/Blank. Only applicable if ConstraintCode = 05 since this field indicates whether constraint is a Teacher Avoid constraint (ConstraintFlagField1 = True) or a Student Preference constraint. |
Constraint_Code | 4.0.0 | Varchar(8) | This field identifies the type of constraint to the scheduling engine. Constraints will be captured as part of the PowerScheduler commit process from ScheduleConstraints:ConstraintCode and will be exposed for Add/Edit/Delete in PowerSchool. (05 = Teacher Avoid - or Student Preference if ConstraintFlagField1 = True - 06 = Student Free - 07 = Student avoid - 92 = Section Link. |
Course_ Number | 4.0.0 | Varchar(11) | Populated from ScheduleConstraints:Course_Number and must be a valid course in [Courses] and one that is associated to the current school. Indexed. |
Course_ Number2 | 4.0.0 | Varchar(11) | Populated from ScheduleConstraints:CourseNumber2. Required if ConstraintCode = 92. Must be a valid course in [Courses] and one that is associated to the current school. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Expression | 4.0.0 | Varchar(8 0) | Populated from ScheduleConstraints:Expression and required if ConstraintCode = 06. |
ID | 4.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
SchoolID | 4.0.0 | Number(10,0) | The School_Number of the associated Schools record. |
Section_ Number | 4.0.0 | Varchar(10) | Populated from ScheduleConstraints:SectionNumber and must be a valid section in [Sections] for the current school and year. |
Section_ Number2 | 4.0.0 | Varchar(10) | Populated from ScheduleConstraints.SectionNumber2. Required if ConstraintCode = 92. Must be a valid section in [Sections] for the current school and year. |
Section_Type | 4.0.0 | Varchar(2) | Populated from ScheduleConstraints: Section_Type. |
StudentID | 4.0.0 | Number(10,0) | The internal number and ID of the associated Students record. |
StudentID2 | 4.0.0 | Number(10,0) | The internal number for the student with which this record is associated. |
TeacherID | 4.0.0 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. Indexed. |
TeacherID2 | 4.0.0 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. |
TermID | 4.0.0 | Number(10,0) | The internal number for the term with which this record is associated. |
Unused1 | 4.0.0 | Number(10,0) | Currently unused field. |
YearID | 4.0.0 | 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. Maintained in the Terms table. |