ScheduleCourseCatalogs, 107 (ver3.6.1)
This table stores information about courses being used for building schedules. These can be different than the courses in Active side since they are for future purposes.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Add_to_GPA | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Code | 3.6.1 | Varchar(20) | Used to track state-specific codes associated with a course, such as the CIP code. |
Corequisites | 3.6.1 | CLOB | These are other courses that must be taken with this course at the same term. |
CourseCatalogID | 3.6.1 | Number(10,0) | The internal number for the ScheduleCatalog with which this record is associated. Indexed. |
Course_Name | 3.6.1 | Varchar(100) | The name of the course assigned by school or district, such as Algebra. Indexed. |
Course_Number | 3.6.1 | Varchar(20) | The number the school assigns to a particular course. Indexed. |
CrHrWeight | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
CreditType | 3.6.1 | Varchar(20) | The type of credit this counts as toward graduation, such as Math or elective. |
Credit_Hours | 3.6.1 | Float | The amount of credit awarded for completing a course. |
Custom | 3.6.1 | CLOB | Holds course-related custom fields. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
GradeScaleID | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
MaxClassSize | 3.6.1 | Number(10,0) | The maximum number of students for this classroom. This is the number that appears on the master schedule and is used for allowing manual entry into a class. This number should be the same as Sched_MaximumEnrollment on the ScheduleCourseCatalog table. |
Multiterm | 3.6.1 | Varchar(40) | Indicates whether this course extends to more than one term. |
PowerLink | 3.6.1 | Varchar(50) | The name PowerLink will use over the phone to phonetically spell a course in English |
PowerLinkSpan | 3.6.1 | Varchar(80) | The name PowerLink will use over the phone to phonetically spell a course in Spanish |
PrerequisitesValue (aka:Prerequisites) | 3.6.1 | CLOB | Copied from Course table, but not used anywhere. |
RegAvailable | 3.6.1 | Number(10,0) | Copied from Courses table but not used anywhere. |
RegCourseGroup | 3.6.1 | Varchar(80) | Copied from Courses table but not used anywhere. |
RegGradeLevels | 3.6.1 | Varchar(40) | Copied from Courses table but not used anywhere. |
RegTeachers | 3.6.1 | CLOB | Copied from Courses table but not used anywhere. |
Sched_BalancePriority | 3.6.1 | Varchar(10) | What type of balancing should primarily be used when scheduling students into the classes. Section=Try to keep the sections as even as possible in number of students, Gender=Try to keep the number of boys and girls even in classes, Grade=try to get an even number of grade levels represented in each section, EthnicCode=Try to racially balance the sections, House=try to balance the sections with house members. Please note for everything except section if the requests are not there sections will not be able to be balanced. |
Sched_BalanceTerms | 3.6.1 | Number(10,0) | Try to put an equal number of sections in each term: True (selected)=Yes False (deselected)=No |
Sched_BlockStart | 3.6.1 | Number(10,0) | The value is still copied to ScheduleCourseCatalog table but not used anywhere. |
Sched_CloseSectionAfterMax | 3.6.1 | Number(10,0) | When this course is scheduled to the maximum number of students, indicates if the class should be closed: True (selected)=Yes False (deselected)=No |
Sched_ConcurrentFlag | 3.6.1 | Number(10,0) | Courses can be scheduled concurrently for scheduler - not currently set. |
Sched_ConsecutivePeriods | 3.6.1 | Number(10,0) | For multiperiod classes must those periods be back to back. True (checked)=Yes, False (unchecked)=no |
Sched_ConsecutiveTerms | 3.6.1 | Number(10,0) | If this course spans terms, indicates if they must be back-to-back:True (selected)=Yes False (deselected)=No |
Sched_CoursePackage | 3.6.1 | Number(10,0) | Indicates if this course is part of a package. All the courses in a package are requested at once: True (selected)=Part of a package. False (deselected)=Not part of a package. |
Sched_CoursePkgContents | 3.6.1 | CLOB | If the Sched_CoursePackage is selected, these are the courses that are part of the particular package to which this course belongs. Includes this course. |
Sched_CourseSubjectAreaCode | 3.6.1 | Varchar(8) | Subject Area Code for this course for scheduler - not currently set. |
Sched_Demand | 3.6.1 | Number(10,0) | Number of students demand for a course. Calculated by Course Rank process. |
Sched_Department | 3.6.1 | Varchar(12) | The department this course belongs to. See Department, which will be filled after the schedule, is published. |
Sched_Do_Not_Print | 3.7.0 | Number(10,0) | Refer to Courses:Sched_Do_Not_Print. ScheduleCourseCatalog represents copies of the courses for the specific catalog. |
Sched_ExtraDayScheduleTypeCode | 3.6.1 | Varchar(8) | Extra day schedule type code for scheduler - not currently set. |
Sched_Facilities | 3.6.1 | Varchar(50) | Which facilities are used to teach this course. See Facility, which will be filled after the schedule is published. |
Sched_Frequency | 3.6.1 | Number(10,0) | How many times this course should meet in the cycle. |
Sched_FullCatalogDescription | 3.6.1 | CLOB | A description for the course. This is not used in any calculations but is available if the school would like to create a course catalog. |
Sched_GlobalSubstitution1 | 3.6.1 | Varchar(11) | If Sched_SubsitutionAllowed is True, this is the first course to try if this course is not possible. |
Sched_GlobalSubstitution2 | 3.6.1 | Varchar(11) | If Sched_SubsitutionAllowed is True, this is the second course to try if this course is not possible. |
Sched_GlobalSubstitution3 | 3.6.1 | Varchar(11) | If Sched_SubsitutionAllowed is True, this is the third course to try if this course is not possible. |
Sched_LabFlag | 3.6.1 | Number(10,0) | Does this course have a lab: True (selected)=Yes False (deselected)=No |
Sched_LabFrequency | 3.6.1 | Number(10,0) | If Sched_LabFlag is True, how often does the lab need to meet in the cycle. |
Sched_LabPeriods PerMeeting | 3.6.1 | Number(10,0) | When the lab does meet, how many periods does it span. |
Sched_LengthInNumberOfTerms | 3.6.1 | Number(10,0) | The LCM of terms this course must meet for. |
Sched_LoadPriority | 3.6.1 | Number(10,0) | When putting students into classes, how important is this class in relation to other classes? The lower the number, the higher the importance. |
Sched_LoadType | 3.6.1 | Varchar(15) | Is this an academic or elective class? PowerScheduler will try to balance the two for students. |
Sched_LunchCourse | 3.7.0 | Number(10,0) | Refer to Courses:Sched_Lunchcourse. ScheduleCourseCatalog represents copies of the courses for the specific catalog. |
Sched_MaximumDaysPerCycle | 3.6.1 | Number(10,0) | If the number of days a course can meet is flexible, what is the absolute maximum number of days the course can meet in one cycle. |
Sched_MaximumEnrollment | 3.6.1 | Number(10,0) | When scheduling, try to keep the enrollment under this number. |
Sched_MaximumPeriodsPerDay | 3.6.1 | Number(10,0) | If the number of periods a course can meet is flexible, how many periods are the absolute maximum that can be met in one day. |
Sched_MinRoomCapacity | 3.6.1 | Number(10,0) | When smaller rooms can be used, the minimum capacity for a smaller room - not currently set. |
Sched_MinimumDaysPerCycle | 3.6.1 | Number(10,0) | If the number of days a course can meet is flexible, what is the minimum number of days the course must occupy in a cycle. |
Sched_MinimumPeriodsPerDay | 3.6.1 | Number(10,0) | If the number of periods a course can meeting is flexible, how many periods are the minimum the course must meet in one day. |
Sched_MultipleRooms | 3.6.1 | Number(10,0) | Indicates whether course can be scheduled in multiple rooms - not currently set. |
Sched_OverlapAllowed | 3.6.1 | Number(10,0) | Indicates whether to allow multiple enrollments during overlapping schedule terms. |
Sched_PeriodsPerCycle | 3.6.1 | Number(10,0) | The number of periods per cycle day. |
Sched_PeriodsPerMeeting | 3.6.1 | Number(10,0) | When this class meets, how many blocks of time in the day will the class occupy. |
Sched_PrepCode | 5.0.0 | Varchar(12) | This is the Prep Code for a given course. |
Sched_Rank | 3.6.1 | Number(10,0) | Course Rank assigned to this record. Calculated by Course Rank process. |
Sched_RepeatsAllowed | 3.6.1 | Number(10,0) | Can a student repeat this course with the schedule year: True (selected)=Yes False (deselected)=No |
Sched_ScheduleTypeCode | 3.6.1 | Varchar(8) | The type of course this is going to be built as: Standard, Lab, LabFloat, Float, and Custom. |
Sched_Scheduled | 3.6.1 | Number(10,0) | A flag indicating if this course has been built into the schedule. True (checked) means it has been build into the schedule and will not be build next time the engine is run unless the engine is told to reschedule regardless of this flag. False (unchecked) the engine will build into the next schedule. |
Sched_SectionsOffered | 3.6.1 | Number(10,0) | The number of sections that will be offered when it is built. |
Sched_SubstitutionAllowed | 3.6.1 | Number(10,0) | Will global alternates be used: True (selected)=Yes False (deselected)=No |
Sched_TeacherCount | 3.6.1 | Number(10,0) | If teacher assignments are not done, how many teachers can instruct this class at any given period. |
Sched_TotalConflictCourses | 3.6.1 | Number(10,0) | Total number of conflicts by courses. Calculated by Course Rank process. |
Sched_TotalConflictStudents | 3.6.1 | Number(10,0) | Total number of conflicts by students. Calculated by Course Rank process. |
Sched_UsePreestablishedTeams | 3.7.0 | Number(10,0) | Refer to Courses:Sched_Usepreestablishedteams. ScheduleCourseCatalog represents copies of the courses for the specific catalog. |
Sched_UseSection Types | 3.6.1 | Number(10,0) | If a section has a type, use it as a scheduling priority: True (selected)=Yes False (deselected)=No |
Sched_ValidDayCombinations | 3.6.1 | CLOB | When this course meets, it must meet on these days only. |
Sched_ValidStartPeriods | 3.6.1 | CLOB | When this course meets, it must start one of these periods. |
Sched_Year | 3.6.1 | Number(10,0) | Scheduling Year set by scheduler. |
SchoolCr seInfo_guid | 4.0.4 | Varchar(32) | Global SIF Group/User Identifier to be used for SIF compliancy. Indexed. |
SchoolGroup | 3.6.1 | Number(10,0) | Not currently used but being set from Courses table. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SectionsToOffer | 3.6.1 | Number(10,0) | The number of sections for the year. This is not tied to PowerScheduler; in order to specify sections for scheduling, it will need to be set up in the course catalog. |
Status | 3.6.1 | Number(10,0) | Indicates if course was made either by a user or automatically by an import: 0=user-created 3=auto-created. |
TargetClassSize | 3.6.1 | Number(10,0) | The number of student's ideal for the course. This field has no bearing on any calculations. It is for informational purposes only. |
TermsOffered | 3.6.1 | Varchar(40) | The terms this course can be offered. |
ValidExtraDayCombinations (aka:Sched_ValidExtraDayCombinations) | 3.6.1 | CLOB | The value is still copied to ScheduleCourseCatalog table but not used anywhere. |
Vocational | 3.6.1 | Number(10,0) | Used to flag courses as vocational for searching purposes: 1=Yes/Selected 0=No/ Deselected. |
YearID | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |