Skip to main content
Skip table of contents

CReq, 38 (ver3.6.1)

Course Requests entered by the admin or student for the different school terms for scheduling purposes are stored in this table.

Column Name

Initial Version

Data Type

Description

Course_Number

3.6.1

Varchar(11)

The course number being requested ties back to courses table course_number field. Indexed.

DCID

4.0.0

Number(10,0)

Unique identifier for this table. Indexed. Required.

Preference

3.6.1

Number(10,0)

Not currently used.

ReqID

3.6.1

Number(10,0)

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

RequestType

3.6.1

Varchar(7)

Used in uploading files to a customer Delta system. A= TRUE, otherwise FALSE.

SchoolID

3.6.1

Number(10,0)

The School_Number of the associated Schools record.

StudentID

3.6.1

Number(10,0)

The internal number and ID of the associated Students record.

TermID

3.6.1

Number(10,0)

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

YearID

3.6.1

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.

JavaScript errors detected

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

If this problem persists, please contact our support.