GradReq, 37 (ver3.6.1)
Requirement items such as courses, credit hours, etc. that make up gradreqsets.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AppliesTo | 3.6.1 | Varchar(20) | Indicates whether these requirements apply to all students or students in certain grade level (see AppliesToDataLi). |
AppliesToData | 3.6.1 | Varchar(80) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
AppliesToDataLi | 3.6.1 | Number(10,0) | If these requirements apply only to a certain grade level then this contain the grade level value. |
AppliesToDisp | 3.6.1 | Varchar(60) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Classification | 3.6.1 | Varchar(30) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
CountInReqTots | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
CourseDesig | 3.6.1 | Varchar(30) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
CourseGroup | 3.6.1 | Varchar(40) | The name of the course group this record is associated with from the gen table, cat=coursegroups. |
CourseListCheck | 3.6.1 | CLOB | If it is a list of courses this is a check to make sure they are real courses in the course list. |
CourseListHTML | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
CourseListOrder | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
CourseListT | 3.6.1 | CLOB | The list of courses associated with the requirement. |
CourseSource | 3.6.1 | Varchar(20) | Where the courses for this request are drawn from. CreditType, group, any listed. Indexed. |
CreditType | 3.6.1 | Varchar(20) | The type of credit this counts as toward graduation, such as Math or elective. |
DCID | 4.0.4 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | CLOB | The description of the requirement. |
EntryBoxHeight | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
EntryBoxWidth | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
FieldComparator | 3.6.1 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
FieldMatchValue | 3.6.1 | Varchar(40) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
FieldName | 3.6.1 | Varchar(40) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
FirstItem | 3.6.1 | Varchar(40) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
GradReqSetID | 3.6.1 | Number(10,0) | The internal number of the GradReqSet with which this record is associated. Indexed. |
Grade_Level | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
How2DispCourses | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
ItemType | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ListBoxHeight | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
MaxNoOfCourses | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
MinNoOfCourses | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
MinimumMessage | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
MultiTerm | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Name | 3.6.1 | Varchar(80) | The name of the grad requirement. |
OverallCrHrs | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ReqCrHrs | 3.6.1 | Float | Number of hours required for this requirement. |
ReqForGrad | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ReqTerms | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
RequestType | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
SchedPriority | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SortOrder | 3.6.1 | Number(10,0) | The order this item appears on the page for the GradReqSet. |
SubjectArea | 3.6.1 | Varchar(30) | The subject area this request is associated with allowing for further grouping of requests. |
Subtype | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Type | 3.6.1 | Varchar(20) | Specifies graduation requirement or requesting requirement. |