RegistReq, 56 (ver3.6.1)
Used for maintaining specific school and grade level requirements which is used for registration purposes by students (CReq table).
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AppliesTo | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
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) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
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) | Course Groups from GEN table which contain list of courses to use for this record. If ItemType=1 the courses will be listed in the Popup. |
CourseList | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
CourseListCheck | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
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. |
CourseSource | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
CreditType | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | CLOB | A longer description of what the name stands for or other relevant information. |
EntryBoxHeight | 3.6.1 | Number(10,0) | If ItemType = Entry Box this indicate the Height of the EntyBox. |
EntryBoxWidth | 3.6.1 | Number(10,0) | If ItemType = Entry Box this indicate the Width of the EntyBox. |
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) | If the ItemType= Popup, this is the first item on the list. There is always a blank item. If * insert just a blank item. |
Grade_Level | 3.6.1 | Number(10,0) | Grade level of the students in this school to which these requirements apply. Indexed. |
How2DispCourses | 3.6.1 | Varchar(20) | The course list can be either a Scrolling List, Text Only, or Un-Displayed. This only matters for ItemTypes of Entry or Required. |
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) | The type of this requirement field, Popup, Entry Form or Required. This is required. |
ListBoxHeight | 3.6.1 | Number(10,0) | If the How2DispCourses is scrolling this holds the height of the display listbox. |
MaxNoOfCourses | 3.6.1 | Number(10,0) | Maximum number courses that student can request for this registration record. Defaults to 0, no limit. |
MinNoOfCourses | 3.6.1 | Number(10,0) | Minimum number of courses that student must request for this registration record. Defaults to 0. |
MinimumMessage | 3.6.1 | CLOB | If the Maximum or Minimum numbers (see above) are not met then return this message for the student. |
MultiTerm | 3.6.1 | Varchar(20) | Indicates whether this requirement is for multiple terms. Blank=NA, 1=only 1 term, 2=2 terms, etc. |
Name | 3.6.1 | Varchar(80) | The name given to this requirement such as Foreign Language. This is required. |
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 | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
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) | The abbreviation of the terms into which this request can be placed (usually holds one). This is optional. |
RequestType | 3.6.1 | Varchar(20) | Indicates the type of request available for this record: a=alternate, e=elective, r=required. |
SchedPriority | 3.6.1 | Number(10,0) | If any scheduling priority needs to be given to this registration requests. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SortOrder | 3.6.1 | Number(10,0) | The sort order to apply to display these registration records for a grade level for a school. |
SubType | 3.6.1 | Varchar(20) | An optional field if the Type field needs to be broken up even more into sub types. |
SubjectArea | 3.6.1 | Varchar(30) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Type | 3.6.1 | Varchar(20) | The type for this requirement. Defaults to Registration. This is required. |
YearID | 3.7.0 | 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. Indexed. |