ScheduleRequests, 82 (ver3.6.1)
This table stores information about student requests for scheduling.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AlternateCourseNumber1 | 4.0.0 | Varchar(20) | The alternate course number to be used for scheduling elective courses. In the course catalog this course must be flagged in order to be scheduled. Indexed. |
AlternateCourseNumber2 | 4.0.0 | Varchar(20) | The alternate course number to be used for scheduling elective courses. In the course catalog this course must be flagged in order to be scheduled. Indexed. |
AlternateCourseNumber3 | 4.0.0 | Varchar(20) | The alternate course number to be used for scheduling elective courses. In the course catalog this course must be flagged in order to be scheduled. Indexed. |
AlternateGroupCode | 3.6.1 | Varchar(2) | This code indicates whether this course request is an Alternate, Elective = E, or required. |
AlternatePriority | 3.6.1 | Number(10,0) | This will indicate if alternates are to be used the priority for each one. |
CourseNumber | 3.6.1 | Varchar(20) | The name of the course assigned by school or district, such as Algebra. Indexed. |
CreationCode | 3.6.1 | Number(10,0) | Indicates how this record was created: 0=Created by an administrator, 1=Created by a duplicate command, 2=Created in mass, 5=Created by the student. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
GlobalAlternateCourse | 3.6.1 | Number(10,0) | Flag indicating whether this is an alternate request or elective/required. 1=Yes, alternate. |
LoadStatusCode | 3.6.1 | Varchar(4) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
NoGlobalSubstitutionAllowed | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Registreq_ID | 3.7.0 | Number(10,0) | Identifies the request template used when creating this request. This is necessary when displaying the request within the context of the template. Not all requests have this field populated since requests can be created outside of the request template. Indexed. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SectionTypeCode | 3.6.1 | Varchar(2) | A shorter (abbreviation) of the section type up to 2 characters from schedulesectiontypes tables. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
StudentSortField | 3.6.1 | Varchar(12) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
StudentYOGSort | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Student_Number | 3.6.1 | Float | The schools student number using the studentID from Student table. |
Unused | 3.7.0 | Number(10,0) | Currently unused field. |
YearID | 3.6.1 | Number(10,0) | A number representing which year the term belongs to, such as 1300 for 2003-2004. Indexed. |