- DATA VIEW NAME
- STDNT_TIMETABLE_MULTITERM
- OVERVIEW
- This view contains Timetable information for all terms with active courses and sections starting with Summer 1999 (term 0996).
- LOAD FREQUENCY
- Data will be refreshed daily Monday through Friday for the past two terms, the current term, and any future terms with active courses.
- DATA CUSTODIAN
- Registrar’s Office
Contact: Phil Hull - AUTHORIZATION
- You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - The field FIRST COURSE RECORD IND should be used in combination with other fields to do course counts.
For example, this field could be selected with BREADTH VALUE to answer the following question: How many natural science courses are being offered this semester?
Some sections will have multiple records if they take place at more than one time, take place in more than one location, meet in nonconsecutive weeks, or have more than one instructor.
The field FIRST SECTION RECORD IND will be used in combination with other fields to do section counts. For example, it could be selected along with COMPONENT TYPE to determine how many field
sections are being taught. If this indicator is not used in your selection criteria, you could get duplicate counts due to the possibility multiple records per section.
The fields BEGIN TIME and END TIME should only be used for display purposes, not in selection criteria. The fields BEGIN TIME-24HR and END TIME 24HR should be used for selection. - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 05/2003 – New view created.
12/2004 – Two new fields related to E-Grading were added. They are:
Instructor Grade Access and Graded Component Ind. These fields only have significance starting in term 1052.
06/2008 – Data Custodian change. C4j.
1/2010 – Data Custodian Change C4j.
08/2011 – Four new wait list releated fields were added. The fields will only have values starting in term 1114:
Wait_List_Tot
Wait_List_Cap
Combined_Wait_List_Tot
Combined_Wait_List_Cap
09/2012 – Data Custodian Contact changed from Karen Hanson to Kim Alling
10/2014 – Added Service_Learning_Ind S8W
04/2015 – Preferred name policy, added Building_number S8W . - DATA FORMATS
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description | ||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| *TERM | VARCHAR2(4) | The code for the academic year and semester. The term code is 4 digits CYYT – and is DERIVED as follows: C = century, i.e.:0=1900 or 1=2000 YY = academic year, i.e.: 99 = academic year 98-99 or 00 =academic year 99-00; etc T = term, i.e.: 2=Fall or 4=Spring or 6=Summer. Examples: Fall 1998-99 is 0992 or Summer 1999-00 is 1006 |
||||||||||||||||||||||||||||||||||||||||||||
| TERM DESCR | VARCHAR2(30) | Description of the code for the academic year and semester | ||||||||||||||||||||||||||||||||||||||||||||
| *SESSION CODE | VARCHAR2(3) | The session or weeks a course meets. An A1 session code identifies Fall and Spring full term offerings, All Summer offerings and Fall and Spring modular offerings have a 3 character code. Each letter in a 3 character code corresponds to a number (A=1, B=2, C=3, etc.). The first letter indicates the week the session begins; the second letter indicates how many weeks the class spans; the third letter indicates the number of weeks of actual instruction. | ||||||||||||||||||||||||||||||||||||||||||||
| START DATE | DATE | This date is the first Monday of the week that a class section begins. Format is YYYYMMDD. | ||||||||||||||||||||||||||||||||||||||||||||
| END DATE | DATE | This date is the last Sunday of the week that a class section ends. Format is YYYMMDD. | ||||||||||||||||||||||||||||||||||||||||||||
| WEEKS OF INSTRUCTION | VARCHAR2(2) | The number of weeks of instruction for a section or meeting pattern. Valid Values: 01-18 |
||||||||||||||||||||||||||||||||||||||||||||
| *SUBJECT CODE | VARCHAR2(8) | The Timetable department number of the course. For example, 600 is Mathematics. | ||||||||||||||||||||||||||||||||||||||||||||
| SUBJECT DESCR | VARCHAR2(30) | The department name corresponding to the subject code. | ||||||||||||||||||||||||||||||||||||||||||||
| SUBJECT DESCRSHORT | VARCHAR2(10) | The short department name corresponding to the subject code. | ||||||||||||||||||||||||||||||||||||||||||||
| *CATALOG NUMBER | VARCHAR2(10) | The course number that goes with the title of the course. UW MSN uses up to 3 characters to define the actual course number. | ||||||||||||||||||||||||||||||||||||||||||||
| COURSE TITLE | VARCHAR2(30) | The name of the course. | ||||||||||||||||||||||||||||||||||||||||||||
| ACADEMIC ORG | VARCHAR2(10) | Academic Org is a code that identifies one or more Subjects. For example, French (400) and Italian (508) are two different Subjects, but the same Academic Org (L1040). This is used to establish a level of security in ISIS. | ||||||||||||||||||||||||||||||||||||||||||||
| COURSE ACADEMIC GROUP | VARCHAR2(5) | The code of the school or college that offers the course. Formerly known as college code. | ||||||||||||||||||||||||||||||||||||||||||||
| COURSE ACADEMIC GROUP DESCR | VARCHAR2(10) | Name of the school or college offering the course. | ||||||||||||||||||||||||||||||||||||||||||||
| COURSE ID | VARCHAR2(6) | A unique ID number assigned by ISIS to a specific course, regardless of academic department. Therefore, all course members of a crosslisted course will have the same Course ID. | ||||||||||||||||||||||||||||||||||||||||||||
| *SECTION NUMBER | VARCHAR2(4) | The particular unit of instruction, such as a lecture, lab or a seminar. Section numbers are divided into three ranges of numbers to separate different types of instruction. Range 1 sections are considered the primary type of instruction. Valid Values: 001-299 = Range 1 301-599 = Range 2 601-999 = Range 3 |
||||||||||||||||||||||||||||||||||||||||||||
| COMBINED SECTION IND | VARCHAR2(1) | Indicates if the section is combined with another section(s). This could be a meets-with or a crosslisted section. Valid Values: Y = Yes N = No |
||||||||||||||||||||||||||||||||||||||||||||
| COMBINED SECTIONS ID | VARCHAR2(4) | Term specific code shared by the members of a group of combined sections, whether crosslisted or meets-with. | ||||||||||||||||||||||||||||||||||||||||||||
| COMPONENT TYPE | VARCHAR2(3) | The abbreviation for the type of instruction for a particular section. For a course, all range 1 sections should have the same component or type of instruction. This is true for ranges 2 and 3 also. Valid Values: DIS = Discussion FLD = Field Studies IND = Independent Study LAB = Laboratory LEC = Lecture SEM = Seminar |
||||||||||||||||||||||||||||||||||||||||||||
| OPTIONAL SECTION IND | VARCHAR2(1) | Indicates if a component is optional. This could be a totally optional review/help session where enrollment and attendance is not required or discussion which is optional for an additional credit. For example, lecture only is 3 credit; lecture and discussion are 4 credits. Valid Values:
|
||||||||||||||||||||||||||||||||||||||||||||
| CLASS STATUS | VARCHAR2(1) | The status of a class section. Valid Values:
|
||||||||||||||||||||||||||||||||||||||||||||
| BEGIN TIME | VARCHAR2(8) | The begin time of the meeting pattern. The format is HH:MM pm. For example 08:50 am or 02:25 pm. Use this column for display purposes. For search criteria us BEGIN TIME 24HR | ||||||||||||||||||||||||||||||||||||||||||||
| BEGIN TIME 24HR | VARCHAR2(5) | The time a specified class meeting pattern begins on a 24 hour clock. For example, 08:50 or 14:25. This field should be used for search criteria. | ||||||||||||||||||||||||||||||||||||||||||||
| END TIME | VARCHAR2(8) | The end time of the meeting pattern. The format is HH:MM pm. For example 09:40 am or 03:15 pm. Use this column for display purposes. For search criteria, use END TIME 24HR | ||||||||||||||||||||||||||||||||||||||||||||
| END TIME 24HR | VARCHAR2(5) | The time a specified class meeting pattern ends on a 24 hour clock. For example, 09:40 or 15:15. This field should be used for search criteria. | ||||||||||||||||||||||||||||||||||||||||||||
| CLASS LENGTH | NUMBER(3) | Length of the section meeting pattern in minutes, for example 050. | ||||||||||||||||||||||||||||||||||||||||||||
| NUMBER OF DAYS | NUMBER(3) | The number of days the class meets. For example, a MWF class would have the value 3. | ||||||||||||||||||||||||||||||||||||||||||||
| CONTACT PERIODS | VARCHAR2(4) | Weekly contact periods are calculated by: Class Length * number of class meetings per week / 50 where 50 minutes equals one contact period. The value is reported to one decimal place. | ||||||||||||||||||||||||||||||||||||||||||||
| STANDARD MEETING PATTERN | VARCHAR2(7) | The days of the week the section meets. Example: MWF means the section meets Monday, Wednesday and Friday. Valid Values: M = Monday T = Tuesday W = Wednesday R = Thursday F = Friday S = Saturday U = Sunday |
||||||||||||||||||||||||||||||||||||||||||||
| MEETS MON IND | VARCHAR2(1) | Indicates if the section meets on Mondays. Valid Values: Y = Yes N = No |
||||||||||||||||||||||||||||||||||||||||||||
| MEETS TUES IND | VARCHAR2(1) | Indicates if the section meets on Tuesdays. Valid Values: Y = Yes N = No |
||||||||||||||||||||||||||||||||||||||||||||
| MEETS WED IND | VARCHAR2(1) | Indicates if the section meets on Wednesdays. Valid Values: Y = Yes N = No |
||||||||||||||||||||||||||||||||||||||||||||
| MEETS THURS IND | VARCHAR2(1) | Indicates if the section meets on Thursdays. Valid Values: Y = Yes N = No |
||||||||||||||||||||||||||||||||||||||||||||
| MEETS FRI IND | VARCHAR2(1) | Indicates if the section meets on Fridays. Valid Values: Y = Yes N = No |
||||||||||||||||||||||||||||||||||||||||||||
| MEETS SAT IND | VARCHAR2(1) | Indicates if the section meets on Saturdays. Valid Values: Y = Yes N = No |
||||||||||||||||||||||||||||||||||||||||||||
| MEETS SUN IND | VARCHAR2(1) | Indicates if the section meets on Sundays. Valid Values: Y = Yes N = No |
||||||||||||||||||||||||||||||||||||||||||||
| INSTRUCTION MODE | VARCHAR2(2) | The method of delivery of the instruction. Valid values:
|
||||||||||||||||||||||||||||||||||||||||||||
| INSTRUCTION MODE DESCR | VARCHR2(30) | Description of the mode of instruction. | ||||||||||||||||||||||||||||||||||||||||||||
| FACILITY ID | VARCHAR2(10) | Defines the building code, wing and room number. The first five digits define the building code and wing. The last five digits define the room number. Typically, only two groups or four are displayed. | ||||||||||||||||||||||||||||||||||||||||||||
| BUILDING NUMBER | VARCHAR2(5) | Building number and wing of the room where the instruction takes place for a course section. | ||||||||||||||||||||||||||||||||||||||||||||
| BUILDING NAME | VARCHAR2(10) | Short name of the building where instruction takes place for a course section. | ||||||||||||||||||||||||||||||||||||||||||||
| ROOM NUMBER | VARCHAR2(10) | A specific room number in the building where instruction takes place for a course section. | ||||||||||||||||||||||||||||||||||||||||||||
| ROOM CAP REQUEST | NUMBER(4) | The projected room capacity needed for a section. Used to determine general assignment classroom size and to determine the maximum projected enrollment for a section. | ||||||||||||||||||||||||||||||||||||||||||||
| ROOM SEATING CAPACITY | NUMBER (4) | The number of seats a classroom contains. Note that capacities for non-General Assignment classroom space may be set to 0 or 1. Also, the Facility ID of ‘0000 GA RM’ which denotes a request for a GA classroom has a capacity of 1. | ||||||||||||||||||||||||||||||||||||||||||||
| ASSOCIATED CLASS | NUMBER (4) | Each class section has an Associated Class Number. Different components (e.g. lectures, discussions, labs) that are taken as package have the same Associated Class Number. Associated Class 99 or 9999 identifies a section that is linked to more than one Associated Class Number. | ||||||||||||||||||||||||||||||||||||||||||||
| *CLASS MEETING NUMBER | NUMBER (2) | If a class has multiple meeting patterns, such as a class that does not meet consecutive weeks, each meeting pattern is specified by a unique class meeting number. | ||||||||||||||||||||||||||||||||||||||||||||
| COMPONENT COUNT | NUMBER (1) | The number of components offered in a course. A course can have up to 3 components (e.g. lecture, lab, discussion). | ||||||||||||||||||||||||||||||||||||||||||||
| COURSE OFFER NUMBER | NUMBER(2) | A number used to identify cross-listed courses when associated with course id. Each course has a Course Offer Number. Each member of a crosslisted group has a unique Course Offer Number. | ||||||||||||||||||||||||||||||||||||||||||||
| EXAM CODE | VARCHAR2(8) | A Code for the time and date of the section two-hour summary instructional period. Exam Code is found in the EXAM column of the timetable, and the schedule of codes is also printed in the timetable. | ||||||||||||||||||||||||||||||||||||||||||||
| EXTENDED DAY IND | VARCHAR2(1) | Indicates if a section is taught 4:30 or later on weekdays or anytime on the weekend, or is taught via distance education. Valid Values: N = No Y = Yes |
||||||||||||||||||||||||||||||||||||||||||||
| SCHEDULE PRINT IND | VARCHAR2(1) | Indicates if the section appears in the timetable. Valid Values: N = No (does not print in the timetable) Y = Yes (does print in the timetable) Exception: component type IND never prints in the timetable, regardless of the Schedule-Print indicator. |
||||||||||||||||||||||||||||||||||||||||||||
| TOPIC TITLE ELIGIBLE IND | VARCHAR2(1) | Indicates if a course has been approved as a topics course at the catalog level; courses without such an indicator cannot have topics displayed in the Timetable topic title or on the transcript. Valid Values: N = No Y = Yes |
||||||||||||||||||||||||||||||||||||||||||||
| TOPIC TITLE NUMBER | NUMBER (3) | Sequential code that corresponds to a submitted Topic Title in the Course Catalog. | ||||||||||||||||||||||||||||||||||||||||||||
| TOPIC TITLE DESCR | VARCHAR2(30) | Description of the Topic Title Number. | ||||||||||||||||||||||||||||||||||||||||||||
| *INSTRUCTOR ID | VARCHAR2(11) | The Empl ID to uniquely identify the instructor assigned to teach a particular section of a course. If two or more instructors are teaching the same class, additional Empl ID’s will be present on separate records for this section. | ||||||||||||||||||||||||||||||||||||||||||||
| INSTRUCTOR NAME | VARCHAR2(50) | Preferred name of the instructor assigned to teach a particular section. If two or more instructors are teaching the same class, additional names may be present on separate records for this section. | ||||||||||||||||||||||||||||||||||||||||||||
| INSTRUCTOR ROLE CODE | VARCHAR2(4) | Code assigned to an instructor to designate the appointment type of instructor. Valid Values: 1 = Faculty 2 = Emerita/Emeritus 3 = Clinical/CHS Faculty 4 = Visiting/Adjunct Faculty 5 = Lecturer/Faculty Associate 6 = Other Academic Staff 7 = Graduate Assistant 9 = Not Selected PI = Primary Instructor Only available for Term 1186 forward: P = Principal Instructor X = Auxillary Instructor S = Supervisory Instructor |
||||||||||||||||||||||||||||||||||||||||||||
| INSTRUCTOR ROLE DESCR | VARCHAR2(30) | Description of the Instructor Role code. | ||||||||||||||||||||||||||||||||||||||||||||
| INSTRUCTOR GRADE ACCESS | VARCHAR2(1) | The value in this field indicates which type of electronic grade access an instructor of record will have. Instructor Grade Access is relevant only if the instructor is attached to a section that is a Graded Component. (See Graded Component Ind for additional information.) Note: This field is valid beginning Term 1052 onward. Previous Terms may have values other than Nulls, but they have no significance prior to Term 1052. Valid Values: A = Approve. Instructor can input and submit grades or submit grades input by another instructor on the same course section. G = Grade. Instructor can input grades, but not submit. N = No Access. Instructor can neither input nor submit grades. P = Post. This value has been inactivated effective Fall Term 2004-2005 (1052). NULL = No Value. |
||||||||||||||||||||||||||||||||||||||||||||
| GRADED COMPONENT IND | VARCHAR2(1) | The value in this field indicates whether or not a component (i.e., DIS, FLD, IND, LAB, LEC, or SEM) is the component through which grades are entered. Grades can only be entered on sections that have been identified as the Graded Component. Valid Values: Y = Yes N = No ? = Ambiguous. When a section can participate in multiple class associations, it might be the graded component in some, but not in others. Such ambiguity should be relatively rare, and could indicate an error in class setup. |
||||||||||||||||||||||||||||||||||||||||||||
| COURSE ADMINISTRATOR ID | VARCHAR2(11) | The EMPL ID of the Course Administrator. The Course Administrator is the name that will appear on Class and Grade rosters. This may change over the duration of the semester. | ||||||||||||||||||||||||||||||||||||||||||||
| COURSE ADMINISTRATOR NAME | VARCHAR2(50) | The preferred name of the Course Administrator. | ||||||||||||||||||||||||||||||||||||||||||||
| COMBINATION TYPE | VARCHAR2(2) | The type of combination for a section in a crosslist or meet-with group. Valid values are: XL = crosslisted MW = meets-with XM = crosslisted and meets-with SL = meets-with at the section level (not all sections in the course meet together) |
||||||||||||||||||||||||||||||||||||||||||||
| PRIMARY OR SECONDARY DEPT | VARCHAR2(1) | The status of a section that is combined in a crosslist and/or meets-with group. Valid values are: P = Primary S = Secondary |
||||||||||||||||||||||||||||||||||||||||||||
| PRIMARY SUBJECT CODE | VARCHAR2(8) | The primary or coordinating academic department in a crosslist or meets-with combination Example: 900 is Sociology | ||||||||||||||||||||||||||||||||||||||||||||
| PRIMARY SUBJECT DESCRSHORT | VARCHAR2(10) | The description of the department name. | ||||||||||||||||||||||||||||||||||||||||||||
| PRIMARY SESSION CODE | VARCHAR2(3) | The session in which a crosslist or meets-with section is offered. See SESSION CODE for further definition. | ||||||||||||||||||||||||||||||||||||||||||||
| PRIMARY CATALOG NUMBER | VARCHAR2(10) | Primary department’s course or catalog number in a crosslist or meets-with combination. (UW-Madison uses up to 3 characters to define a course number). | ||||||||||||||||||||||||||||||||||||||||||||
| PRIMARY SECTION NUMBER | VARCHAR2(4) | Course section number of the primary department in a crosslist or meets-with combination. | ||||||||||||||||||||||||||||||||||||||||||||
| BREADTH VALUE | VARCHAR2(1) | How courses count in meeting the breadth requirements for the Letters and Sciences BA/BS degrees. Valid Values:
|
||||||||||||||||||||||||||||||||||||||||||||
| COURSE LEVEL | VARCHAR2(1) | The course level. Sixty credits of advanced and intermediate level courses are required for Letters and Science BA/BS degrees. Valid Values: E = Elementary I = Intermediate A = Advanced D = Intermediate or Advanced |
||||||||||||||||||||||||||||||||||||||||||||
| LS DEGREE CREDIT | VARCHAR2(1) | Indicates if the course counts towards credit in or out of Letters and Science. Valid Values:
|
||||||||||||||||||||||||||||||||||||||||||||
| COMM A COURSE IND | VARCHAR2(1) | Indicates if the course meets the General Education Communication Part A requirement. Valid Values: N = No Y = Yes |
||||||||||||||||||||||||||||||||||||||||||||
| COMM B COURSE IND | VARCHAR2(1) | Indicates if the course meets the General Education Communication Part B requirement. Valid Values: N = No Y = Yes |
||||||||||||||||||||||||||||||||||||||||||||
| COMM B SECTION IND | VARCHAR2(1) | Indicates if this section (but not all sections) in a course meets the General Education Communication Part B requirement. Note: If all sections in a course are Comm B, then the Comm B Course field will contain a ‘Y’; Comm B Secttion will contain an ‘N’. Valid Values: N = No Y = Yes |
||||||||||||||||||||||||||||||||||||||||||||
| QR A COURSE IND | VARCHAR2(1) | Indicates if the course meets the General Education Quantitative Reasoning Part A requirement. Valid Values: N = No Y = Yes |
||||||||||||||||||||||||||||||||||||||||||||
| QR B COURSE IND | VARCHAR2(1) | Indicates if the course meets the General Education Quantitative Reasoning Part B requirement. Valid Values: N = No Y = Yes |
||||||||||||||||||||||||||||||||||||||||||||
| COURSE HONORS SYMBOL | VARCHAR2(4) | The Honors status of a course. Valid Values:
|
||||||||||||||||||||||||||||||||||||||||||||
| SECTION HONORS SYMBOL | VARCHAR2(4) | The Honors status of a section of a course. Valid Values:
|
||||||||||||||||||||||||||||||||||||||||||||
| COURSE REPEATABLE IND | VARCHAR2(1) | Identifies courses for which a student may receive credit multiple times. For example, a course which offers different topics each semester is often repeatable. Valid Values: N = No Y = Yes |
||||||||||||||||||||||||||||||||||||||||||||
| CREDIT NO CREDIT IND | VARCHAR2(1) | Identifies courses taken on a credit/no credit basis. Valid Values: Y = Yes (credit/no credit grade basis) N = No (lettered grade basis (default)) |
||||||||||||||||||||||||||||||||||||||||||||
| ETHNIC STUDIES IND | VARCHAR2(1) | Indicates if the course meets ethnic studies requirements. Valid Values: N = No Y = Yes |
||||||||||||||||||||||||||||||||||||||||||||
| OPEN TO FRESHMEN IND | VARCHAR2(1) | Indicates if the course is open to freshmen registration. Valid Values: Y = Yes N = No |
||||||||||||||||||||||||||||||||||||||||||||
| SERVICE_LEARNING_IND | VARCHAR2(1) | Indicates if the course meets service learning requirements. Valid Values: N = No Y = Yes |
||||||||||||||||||||||||||||||||||||||||||||
| MINIMUM CREDITS | NUMBER(5,2) | Minimum credits for an entire course. If Minimum and Maximum credits are equal, then the course has been approved to be offered for a fixed, single credit only. If Minimum and Maximum credits differ, then a credit range had been approved for the course. Null when the section Associated Class = 99 or 9999 and the min/max credits vary across the other Class Associations for the course. | ||||||||||||||||||||||||||||||||||||||||||||
| MAXIMUM CREDITS | NUMBER(3,2) | Maximum credits for a course. If the minimum and maximum credits are equal, then the course has been approved to be offered for a fixed, single credit only. If minimum and mazimum credits differ, then a credit range has been approved for the course. Not populated when the section Associated Class = 99 or 9999 and the min/max credits vary across the other Class Associations for the course. | ||||||||||||||||||||||||||||||||||||||||||||
| ASSOC LVL REQUISITE GRP NBR |
VARCHAR2(6) | Controls enrollment at the class association level and may change. Represents the conditions that must be met before a student can enroll. | ||||||||||||||||||||||||||||||||||||||||||||
| ASSOC LVL REQUISITE GRP DESCR | VARCHAR2(30) | Description of the Assoc Level Requisite Group. | ||||||||||||||||||||||||||||||||||||||||||||
| CATALOG LVL REQUISITE GRP NBR | VARCHAR2(6) | Controls enrollment at the catalog [course] level and may change from semester to semester. Represents the conditions that must be met before a student can enroll. | ||||||||||||||||||||||||||||||||||||||||||||
| CATALOG LVL REQUISITE GRP DESC | VARCHAR2(30) | Description of the Catalog Level Requisite Group. | ||||||||||||||||||||||||||||||||||||||||||||
| AUTO ENROLLED SECTION1 | VARCHAR2(4) | The section (a different component) of a course in which a student is automatically enrolled. Example: Discussion 301 has an auto-enrolled-section1 value of Lecture 001. A student registering for Discussion 301 will automatically be enrolled in Lecture 001. Nulls = no auto-enrolled section is set up. |
||||||||||||||||||||||||||||||||||||||||||||
| AUTO ENROLLED SECTION2 | VARCHAR2(4) | The section (a different component) of a course in which a student is automatically enrolled. Example: Discussion 301 has an auto-enrolled-section1 value of Lecture 001. A student registering for Discussion 301 will automatically be enrolled in Lecture 001. Nulls = no auto-enrolled section is set up. |
||||||||||||||||||||||||||||||||||||||||||||
| CLASS NUMBER | NUMBER (5) | Class number is assigned by ISIS. The class number is the call number used for student enrollment except where auto enroll is established. | ||||||||||||||||||||||||||||||||||||||||||||
| CLASS TYPE | VARCHAR2(1) | The Class type indicates whether the section is an enrollment or non-enrollment section. Valid values: E = enrollment N = non-enrollment. |
||||||||||||||||||||||||||||||||||||||||||||
| CONSENT CODE | VARCHAR2(1) | Indicates that permission is required to enroll for this section Values are: ‘D’ = Departmental consent ‘I’ = Instructor consent ‘N’ = Consent not required |
||||||||||||||||||||||||||||||||||||||||||||
| ENROLLMENT CAP | NUMBER(4) | The number of student enrollments allowed as of the Extract Date Time using the section’s Class Number. This is often changed by departments during enrollment to manage seats available to students to enroll. | ||||||||||||||||||||||||||||||||||||||||||||
| COMBINED ROOM CAP REQUEST |
NUMBER(4) | The projected room capacity needed for a crosslist or meets-with section. Used to determine general assignment classroom size and to determine the maximum projected enrollment for a section. The value is zero if the section is not crosslisted or meetswith. | ||||||||||||||||||||||||||||||||||||||||||||
| COMBINED ENROLLMENT | NUMBER(4.0) | The total number of students enrolled for all members of a specific crosslist or meets-with section combination as of the the Extract Date Time. The value is zero if the section is not crosslist or meets-with. | ||||||||||||||||||||||||||||||||||||||||||||
| COMBINED ENROLLMENT CAP | NUMBER(4.0) | Total number of student registrations allowed for a specific crosslist or meets-with section combination as of the Extract Date Time. The value is zero if the section is not crosslisted or meets-with. There won’t be a distinction made between a null value and an entered zero value. | ||||||||||||||||||||||||||||||||||||||||||||
| FIRST COURSE RECORD IND | VARCHAR2(1) | Identifies the first record for a course (term/session/subject code/catalog number). This record should be used to do course counts. The first record for each course has the value ‘Y’ and all additional section records have Nulls in this field. | ||||||||||||||||||||||||||||||||||||||||||||
| FIRST SECTION RECORD IND | VARCHAR2(1) | Identifies the first record for a section (term/session/subject code/catalog number/section number). This record should be used if doing section counts. The first record for each section has the value ‘Y’ and all additional records (for multiple meeting patterns or multiple instructor names) have Nulls in this field. | ||||||||||||||||||||||||||||||||||||||||||||
| SECTION COUNT | NUMBER (4) | The number of students enrolled for this section under this department as of the Extract Date Time. | ||||||||||||||||||||||||||||||||||||||||||||
| WAIT_LIST_TOT | NUMBER (4) | Total number of students on wait list within selected department. | ||||||||||||||||||||||||||||||||||||||||||||
| WAIT_LIST_CAP | NUMBER (4) | Total number of students allowed to wait list within selected department. | ||||||||||||||||||||||||||||||||||||||||||||
| COMBINED_WAIT_LIST_TOT | NUMBER (4) | Total number of students on wait list for all members of a combined section. | ||||||||||||||||||||||||||||||||||||||||||||
| COMBINED_WAIT_LIST_CAP | NUMBER (4) | Total number of students allowed to wait list for all members of a combined section. | ||||||||||||||||||||||||||||||||||||||||||||
| EXTRACT DATE TIME | DATE | The date and time the data was extracted. Format: YYYYMMDD HH24:MI:SS |