Skip to main content
Skip table of contents

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 NameInitial VersionData TypeDescription

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

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

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.

JavaScript errors detected

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

If this problem persists, please contact our support.