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(20) | 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. |