CoursesByYear (ver7.8.0)

Add_to_GPA

Float

For description, see Courses.

Code

Varchar2(20)

For description, see Courses

Corequisites

CLOB

For description, see Courses.

Course_Name

Varchar2(100)

For description, see Courses.

Course_Number

Varchar2(20)

For description, see Courses.

CoursesDCID

Number

DCID of the associated Courses record.

CoursesID

Number

ID of the associate Courses record.

Credit_Hours

Float

For description, see Courses.

CreditType

Varchar2(20)

For description, see Courses

CrHrWeight

Float

For description, see Courses.

Custom

CLOB

For description, see Courses.

Exclude_ADA

Number10

For description, see Courses.

ExcludeFromClassRank

Number10

For description, see Courses.

ExcludeFromGPA

Number10

For description, see Courses.

ExcludeFromHonorRoll

Number10

For description, see Courses.

ExcludeFromStoredGrades

Number10

For description, see Courses.

GPA_AddedValue

Float

For description, see Courses.

GradeScaleID

7.8.1?

7.8.0?

Number10

For description, see Courses.

MaxClassSize

Number10

For description, see Courses.

MaxCredit

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

Varchar2(40)

For description, see Courses.

PowerLink

Varchar2(50)

For description, see Courses.

PowerLinkSpan

Varchar2(80)

For description, see Courses.

Prerequisites

CLOB

For description, see Courses.

ProgramID

Number10

For description, see Courses.

RegAvailable

Number10

For description, see Courses.

RegCourseGroup

Varchar2(80)

For description, see Courses.

RegGradeLevels

Varchar2(40)

For description, see Courses.

RegTeachers

CLOB

For description, see Courses.

Sched_BalancePriority

Varchar2(10)

For description, see Courses.

Sched_BalanceTerms

Number10

For description, see Courses.

Sched_BlockStart

Number10

For description, see Courses.

Sched_CloseSectionAfterMax

Number10

For description, see Courses.

Sched_ConcurrentFlag

Number10

For description, see Courses.

Sched_ConsecutivePeriods

Number10

For description, see Courses.

Sched_ConsecutiveTerms

Number10

For description, see Courses.

Sched_CoursePackage

Number10

For description, see Courses.

Sched_CoursePkgContents

CLOB

For description, see Courses.

Sched_CourseSubjectAreaCode

Varchar2(8)

For description, see Courses.

Sched_Department

Varchar2(12)

For description, see Courses.

Sched_Do_Not_Print

Number10

For description, see Courses.

Sched_ExtraDayScheduleTypeCode

Varchar2(8)

For description, see Courses.

Sched_Facilities

Varchar2(50)

For description, see Courses.

Sched_Frequency

Number10

For description, see Courses.

Sched_FullCatalogDescription

CLOB

For description, see Courses.

Sched_GlobalSubstitution1

Varchar2(10)

For description, see Courses.

Sched_GlobalSubstitution2

Varchar2(10)

For description, see Courses.

Sched_GlobalSubstitution3

Varchar2(10)

For description, see Courses.

Sched_LabFlag

Number10

For description, see Courses.

Sched_LabFrequency

Number10

For description, see Courses.

Sched_LabPeriodsPerMeeting

Number10

For description, see Courses.

Sched_LengthInNumberOfTerms

Number10

For description, see Courses.

Sched_LoadPriority

Number10

For description, see Courses.

Sched_LoadType

Varchar2(15)

For description, see Courses.

Sched_LunchCourse

Number10

For description, see Courses.

Sched_MaximumDaysPerCycle

Number10

For description, see Courses.

Sched_MaximumEnrollment

Number10

For description, see Courses.

Sched_MaximumPeriodsPerDay

Number10

For description, see Courses.

Sched_MinimumDaysPerCycle

Number10

For description, see Courses.

Sched_MinimumPeriodsPerDay

Number10

For description, see Courses.

Sched_MultipleRooms

Number10

For description, see Courses.

Sched_PeriodsPerCycle

Number10

For description, see Courses.

Sched_PeriodsPerMeeting

Number10

For description, see Courses.

Sched_RepeatsAllowed

Number10

For description, see Courses.

Sched_Scheduled

Number10

For description, see Courses.

Sched_ScheduleTypeCode

Varchar2(8)

For description, see Courses.

Sched_SectionsOffered

Number10

For description, see Courses.

Sched_SubstitutionAllowed

Number10

For description, see Courses.

Sched_TeacherCount

Number10

For description, see Courses.

Sched_UsePreestablishedTeams

Number10

For description, see Courses.

Sched_UseSectionTypes

Number10

For description, see Courses.

Sched_ValidDayCombinations

CLOB

For description, see Courses.

Sched_ValidStartPeriods

CLOB

For description, see Courses.

Sched_Year

Number10

For description, see Courses.

SchoolGroup

Number10

For description, see Courses.

SchoolID

Number10

For description, see Courses.

SectionsToOffer

Number10

For description, see Courses.

Status

Number10

For description, see Courses.

TargetClassSize

Number10

For description, see Courses.

TermsOffered

CLOB

For description, see Courses.

ValidExtraDayCombinations

CLOB

For description, see Courses.

Vocational

Number10

For description, see Courses.

WhenCreated

Timestamp(6)

Date and time the record was created. Defaults to system date. Required.

WhenModified

Timestamp(6)

Date and time the record was modified. Defaults to system date. Required.

WhoCreated

Varchar2(100)

The user login that created the record. Defaults to database user. Required.

WhoModified

Varchar2(100)

The user login that modified the record. Defaults to database user. Required.

YearID

Number10

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.