Skip to main content
Skip table of contents

ScheduleBuilds, 105 (ver3.6.1)

All information regarding a Build scenario whether active or inactive is maintained in this table.

Column NameInitial VersionData TypeDescription

BlocksPerDay

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

BuildID

3.6.1

Number(10,0)

Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed.

BuildName

3.6.1

Varchar(25)

Name associated to this build.

BuildType

3.6.1

Varchar(10)

What kind of a Build category this is, such as Optimize, Build, and Load.

BuildYear

3.6.1

Number(10,0)

Two-digit representations of the year for this build, such as 12= 2002-2003, 13=2003-2004.

CalcFutureAssignments

3.6.1

Number(10,0)

True means that scheduler calculates the future assignments for each combination when we build the list of teachers for each section.

CloseRoom

3.6.1

Number(10,0)

Not currently used and set to False. When true, limits the number of students scheduled into a room (by period) to the room size.

Comments

3.6.1

CLOB

Any comments or description provided for this build.

CourseCatalogID

3.6.1

Number(10,0)

The internal number for the ScheduleCatalogl with which this record is associated. Indexed.

CurrentBuild

3.6.1

Number(10,0)

Indicates whether this the current active build for this school. 1=Active.

DLoadMax

3.6.1

Number(10,0)

Maximum number of sections for which Scheduler calculate the score for each combination by running a full load.

DPCycle

3.6.1

Number(10,0)

Number of days in a cycle for a schedule. Required.

DateLastBuild

3.6.1

Date

The date when the last Build or Optimize was imported into this table.

DateLastLoad

3.6.1

Date

The date when the last Load was imported into this table.

DCID

4.0.0

Number(10,0)

Unique identifier for this table. Indexed. Required.

Debug

3.6.1

Number(10,0)

When true writes program steps in the debug.log file.

DebugScores

3.6.1

Number(10,0)

Indicates whether debug the scores, i.e. write the BalScore file.

DynamicCombos

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

FixedCycleSchedule

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

FutureAsgnEach

3.6.1

Number(10,0)

True means that scheduler calculates the future assignments for each combination when we build the list of teachers for each section.

FutureAsgnPct

3.6.1

Number(10,0)

Indicates the % of the teachers' time scheduled before scheduler starts calculating the future assignments.

FutureAsgnScore

3.6.1

Number(10,0)

True means that scheduler calculates the future assignments for each combination that scored better than the previous ones.

FutureMaxTime

3.6.1

Float

Maximum number of seconds the scheduler can spend calculating future assignments for one teacher per combination.

InvOverSubFatal

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

InvPreSchdFatal

3.6.1

Number(10,0)

Flag indicating whether to report the preschedule constraint schedule expression is incompatible with the course parameters validation as a fatal error warning (level 3), and thus abort the scheduler after validations, or warning only (level 2) so that the scheduler starts building. true = validation is fatal (3)false = validation is a warning (2).

IsThisALoad

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

LastBuildLog

3.6.1

CLOB

No longer used by the application. This field may still be referenced on reports and/or custom pages.

LastLoadLog

3.6.1

CLOB

No longer used by the application. This field may still be referenced on reports and/or custom pages.

LinesToDisplay

3.6.1

Number(10,0)

Controls how many lines of the combination machine to show in the debug file.

LoadMin

3.6.1

Number(10,0)

Guaranteed minimum number of combinations to evaluate when loading a student.

LoadPCT

3.6.1

Number(10,0)

Percentage of combinations to evaluate when Loading a student.

LoadSectionThreshold

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

LoadUseMax

3.6.1

Number(10,0)

Indicates whether to enforce CloseAtMax field. 1=yes, enforce.

MaintainIntegrityOfHouses

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

MaxComboFastAsgn

3.6.1

Number(10,0)

Maximum number of combinations allowed attempting the faster assignment method. When there are more combinations than this, scheduler always uses the slower method because the fast method would use too much memory. Defaults to 1 = disabled Fast Assign Method (was 10,000,000).

MaxMemForTAsgn

3.6.1

Number(10,0)

Maximum memory (in bytes) that can be used to optimize the Teacher Assignment function (AssignTeachers in CourseSet).

MaxMemForTSched

3.6.1

Number(10,0)

Maximum amount of memory (in bytes) that can be used to optimize the calculation of teacher schedules (per teacher).

MaxMemSpedTable

3.6.1

Number(10,0)

Controls maximum amount of memory to use in order to speed up the calculations of the combinations

MaxScores

3.6.1

Number(10,0)

Contains the maximum number of identical best scores scheduler will store

MaxSubsAtATime

3.6.1

Number(10,0)

Limit of the number of substitution/alternate requests allowed at a time.

MaxSubstPerCrs

3.6.1

Number(10,0)

Limit of the number of substitution/alternate requests allowed per course.

MaxSubstPerStd

3.6.1

Number(10,0)

Limit of the number of substitution/alternate requests allowed per student.

MaxTimeUpFutAsgn

3.6.1

Number(10,0)

Number of consecutive times we can fail Future Assignments because scheduler run out of time before scheduler stop calculating future assignments.

MinimumBlockedCourseCombos

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

MinimumSchedulesToEvaluate

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

MsgMaxCount

3.6.1

Number(10,0)

Maximum count of same message to write to the message file.

NoLunchPeriods

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

NonConflictWeight

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

OptDebug

3.6.1

Number(10,0)

For debugging the Optimizer results. When true, writes program processing information to an optimize debug log file.

OptHours

3.6.1

Number(10,0)

Number of hours to run the optimizer. Only required for Optimizer.

OptMaxRank

3.6.1

Number(10,0)

Optimize only courses with rank less than or equal to this number. In other words this is the last course to optimize.

OptMinutes

3.6.1

Number(10,0)

Number of minutes to run the optimizer. Only required for Optimizer.

PPDay

3.6.1

Number(10,0)

Periods Per Day. Required,

PercentToCalculate

3.6.1

Float

No longer used by the application. This field may still be referenced on reports and/or custom pages.

PotentialConflictWeight

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

RestrictedWeightFactor

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

RndSeed

3.6.1

Number(10,0)

Random seed (random number) - required.

RotatedDays

3.6.1

Number(10,0)

Number of days in the rotated scheduled.

RotatedPeriods

3.6.1

Number(10,0)

Number of periods in the rotated schedule.

SMapType

3.6.1

Varchar(2)

Schedule Map type Periods first or Days first. P=Periods, D=Days.

STerms

3.6.1

Number(10,0)

Scheduled Terms (number of terms in the year). Required,

ScenarioType

3.6.1

Varchar(10)

Type of scenario but not currently used,

SchdMin

3.6.1

Number(10,0)

Guaranteed minimum number of combinations to evaluate.

SchdPct

3.6.1

Float

Percentage of combinations to evaluate when Loading a student.

SchoolID

3.6.1

Number(10,0)

The School_Number of the associated Schools record.

SectType

3.6.1

Varchar(10)

When Strict, Section types are strictly enforced, when Relaxed a request without a section type can be assigned to a section with a non blank section type. When ignore guess what. Relaxed implemented in Load, but not yet in Build.

SectionLimitForFullLoad

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

ShowDebug

3.6.1

Number(10,0)

Indicates whether to show the debug information.

SortRooms

3.6.1

Number(10,0)

Indicates whether to sort rooms before assigning them. It's a performance flag should be left to true most of the times. 1=True.

StudentsScheduled

3.6.1

Number(10,0)

Number of students that the scheduler their requests.

StudentsWithRequests

3.6.1

Number(10,0)

Total number of students with request that the scheduler tried to schedule.

SwapAll

3.6.1

Number(10,0)

Indicates whether or not scheduler can swap rooms that are in already the master schedule (masterIN).

SwapRoomsAlways

3.6.1

Number(10,0)

Indicates whether to perform a swap room between each course set. False means only do it at the end. It's just a performance flag. Should be left to true most of the times.

TchOverSubFatal

3.6.1

Number(10,0)

Flag indicating whether to report the teacher is oversubscribed validations as fatal error warnings (level 3), and thus abort the scheduler after validations, or warnings only (level 2) so that the scheduler starts building. True = validations are fatal (3), false = validations are warnings (2).

TchSortMaxTime

3.6.1

Float

Maximum amount of time (in seconds) scheduler can spend trying to sort the teachers in order to evaluate the order in which to assign them.

TermLevelList

3.6.1

CLOB

Term(s) numbers for scheduler to use in order - comma separated, such as 1,2 or 1.

TimeLastBuild

3.6.1

Date

The time when the last Build or Optimize was imported into this table.

TimeLastLoad

3.6.1

Date

The time when the last Load was imported into this table.

TotalRequests

3.6.1

Number(10,0)

Total number of requests passed to scheduler.

TotalRequestsSatisfied

3.6.1

Number(10,0)

Total number of requests (not students - see also studentsrequests) that scheduler successfully scheduled.

UseBldg

3.6.1

Number(10,0)

Indicates whether for the scheduler to use the Buildings. 1=Yes

UseHouse

3.6.1

Number(10,0)

Indicates whether for the scheduler to use the House Codes. 1=Yes

UseRotation

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

UseSmallerRoom

3.6.1

Number(10,0)

Flag indicating whether smaller rooms can be used for scheduling courses if there are not enough rooms with cr_max capacity are available for scheduling all of the sections. If this flag is set to true, then smaller rooms can be used for courses where cr_usesmrm is also set to true.

UseStudentPriorityForLoad

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

ValidPeriods

3.6.1

CLOB

No longer used by the application. This field may still be referenced on reports and/or custom pages.

ValidateOnly

3.6.1

Number(10,0)

Indicates whether for the scheduler to only validate.

VerboseLogFile

3.6.1

Number(10,0)

No longer used by the application. This field may still be referenced on reports and/or custom pages.

VerifyAsgnAssgn

3.6.1

Number(10,0)

Indicates whether for the scheduler to verify the teacher assignments for the right number of term codes, etc. while scheduler try to assign each teacher

VerifyAsgnEach

3.6.1

Number(10,0)

Indicates whether for the scheduler to verify the teacher assignments for the right number of term codes, etc. after we get the list of teachers for all sections for each combination.

WFBalance

3.6.1

Number(10,0)

Balance Factor a higher number means that balancing the sections is more important than reducing conflicts. Conflict Factor + Balance Factor = 100.

WFConflict

3.6.1

Number(10,0)

Conflict Factor - a higher number means that reducing conflicts is more important than keeping the sections balanced. Conflict Factor + Balance Factor = 100.

JavaScript errors detected

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

If this problem persists, please contact our support.