Courses, 2 (ver3.6.1)

This table lists course information such as the Course Name, Number, and Scheduling data.

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

Value is copied from the ScheduleCourseCatalogs table. These are other courses that must be taken with this course at the same term.

Course_Name

3.6.1

Varchar(40)

The name of the course, such as Algebra.

Course_Number

3.6.1

Varchar(11)

The number the school assigns to a particular course. Indexed.

Credit_Hours

3.6.1

Float

The amount of credit awarded for completing a course.

CreditType

3.6.1

Varchar(20)

The type of credit this counts as toward graduation, such as Math or elective.

CrHrWeight

3.6.1

Float

The amount of weight this course carries in a weighted GPA.

Custom

3.6.1

CLOB

Holds course-related custom fields.

DCID

4.0.0

Number(10,0)

Unique identifier for this table. Indexed. Required.

Exclude_ADA

4.0.0

Number(10,0)

Indicates whether or not to exclude ADA. Valid values: 0 = Include Course in ADA/ADM calculation, 1 = Do not include Course in ADA/ADM calculation.

ExcludeFromClassRank

3.6.1

Number(10,0)

Indicates whether this course should be excluded during class ranking. Valid values: 1=True, to be excluded, 0=False.

ExcludeFromGPA

3.6.1

Number(10,0)

Indicates whether this course should be excluded during GPA calculations. Valid values: 1=True, to be excluded, 0=False.

ExcludeFromHonorRoll

3.6.1

Number(10,0)

Indicates whether this course should be excluded during Honor Roll calculations. Valid values: 1=True, to be excluded, 0=False.

ExcludeFromStoredGrades

7.6.0

Number(10,0)

Indicates whether this course should be excluded during the Permanently Store Grades function. Valid values: 1=True, to be excluded, 0=False.

If set to 0, grades for this course will be stored by the Permanently Store Grades function. If set to 1, prevents grades for this course from being stored by the Permanently Store Grades function. Defaults to 0.

Note: This setting may be overridden for individual sections. For more information, see ExcludeFromStoredGrades in the Sections table.

GPA_AddedValue

3.6.1

Float

Number to be added to GPA for this course. Usually, for AP courses there is a bump to the GPA, such as 0.125.

GradeScaleID

3.6.1

Number(10,0)

The ID for the grade scale attached to this course. Relates to the GradescaleItem table.

ID

4.0.0

Number(10,0)

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

IsCareerTech19.11.0Number(1,0)Indicates whether this course is a Career & Technical Education course. Valid values: 1=True, is a Career Tech course, 0=False.
IsFitnessCourse21.4.0Number(1,0)Indicates whether this course conducts fitness tests. Valid values: 1=True, does conduct fitness tests, 0=False. Required. Default 0.
IsPEWaiver21.4.1Number(1,0)Indicates whether this course will be alerted to a PE Waiver. Valid values: 1=True, will see PE Waiver alert, 0=False. Required. Default 0.

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.

MaxCredit

7.8.1

Float

The maximum number of credits a student can receive for taking a course. The value must be greater than or equal to the Credit Hours.

Multiterm

3.6.1

Varchar(40)

The value is copied to ScheduleCourseCatalog table, but not used anywhere.

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.

ProgramID

4.0.0

Number(10,0)

Program identifier value. Indexed.

PSGUID

7.8.0

Varchar(50)

If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus.

PrerequisitesValue

3.6.1

CLOB

Used to store the value for Course Notes. No longer related to Course Prerequisites. The value is copied to ScheduleCourseCatalog table.

Note: Also known as Prerequisites.

RegAvailable

3.6.1

Number(10,0)

The value is copied to ScheduleCourseCatalog table, but not used anywhere.

RegCourseGroup

3.6.1

Varchar(80)

The value is copied to ScheduleCourseCatalog table, but not used anywhere.

RegGradeLevels

3.6.1

Varchar(40)

The value is copied to ScheduleCourseCatalog table, but not used anywhere.

RegTeachers

3.6.1

CLOB

The value is copied to ScheduleCourseCatalog 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 the 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. For example, if 3 boys and 35 girls request a class the number of boys and girls in a class will never be equal no matter how hard you try.

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 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, this indicates if the class should be closed: True (selected)=Yes False (deselected)=No.

Sched_ConcurrentFlag

3.6.1

Number(10,0)

The value is copied to ScheduleCourseCatalog table, but not used anywhere.

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)

The value is copied to ScheduleCourseCatalog table, but not used anywhere.

Sched_Department

3.6.1

Varchar(12)

The department this course belongs to.

Sched_Do_Not_Print

3.7.0

Number(10,0)

This was introduced for v3.7, as a way of allowing the user of this course to specify that should not be included when producing Report Cards and Transcripts. It was initially implemented for Lunch courses but there are additional types of courses that, in effect, are not gradable courses and should not be included on those two reports. One example is Study Hall courses.

Sched_ExtraDayScheduleTypeCode

3.6.1

Varchar(8)

The value is copied to ScheduleCourseCatalog table, but not used anywhere.

Sched_Facilities

3.6.1

Varchar(50)

What facilities are required to teach this course.

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 of 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(10)

If Sched_SubstitutionAllowed is True, this is the first course to try if this course is not possible.

Sched_GlobalSubstitution2

3.6.1

Varchar(10)

If Sched_SubstitutionAllowed is True, this is the second course to try if this course is not possible.

Sched_GlobalSubstitution3

3.6.1

Varchar(10)

If Sched_SubstitutionAllowed 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_LabPeriodsPerMeeting

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)

Introduced for v3.7 as a way of allowing the user to specify which course is the lunch course. This information is used during the build process in PowerScheduler by the scheduling engine. The scheduling engine automatically assigns teachers to this course if the teacher has been assigned to lunch (see Teachers:Sched_Lunch field). There can only be one course with this flag set to true.

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_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)

The value is copied to ScheduleCourseCatalog table, but not used anywhere.

Sched_PeriodsPerCycle

3.6.1

Number(10,0)

The product of periods per meeting and frequency.

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_RepeatsAllowed

3.6.1

Number(10,0)

Can a student repeat this course with the schedule year: True (selected)=Yes False (deselected)=No.

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_ScheduleTypeCode

3.6.1

Varchar(8)

The course type this is going to be built as: Standard, Lab, LabFloat, Float, and Custom.

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_UsePreestablishedTeams

3.7.0

Number(10,0)

To maintain the consistency of capturing committed information from [ScheduleCourseCatalog] since Sched_UsePreestablishedTeams is also new. As with the other Sched fields in the Courses table it is not used in any current functionality.

Sched_UseSectionTypes

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)

The value is copied to ScheduleCourseCatalog table, but not used anywhere.

SchoolGroup

3.6.1

Number(10,0)

The value is copied to ScheduleCourseCatalog table, but not used anywhere.

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 the course was made either by a user or automatically by an import. Valid values: 0=user-created, 3=auto-created.

TargetClassSize

3.6.1

Number(10,0)

The number of students 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

3.6.1

CLOB

The value is copied to ScheduleCourseCatalog table, but not used anywhere.

Note: Also known as Sched_ValidExtraDayCombinations.

Vocational

3.6.1

Number(10,0)

Used to flag courses as vocational for searching purposes. Valid values: 1=Yes/Selected, 0=No/Deselected.

Copyright © 2021 PowerSchool Group LLC