- DATA VIEW NAME
- STDNT_CRSE_SECT_INSTRUCTOR
- OVERVIEW
- This data view identifies all instructors and supervisors, and their roles, associated with a COURSE_OFFER_NBR within a session.
- LOAD FREQUENCY
- Refreshed upon the request of the Provost’s Office.
- DATA CUSTODIAN
- Office of Academic Planning and Institutional Research
Contact: Clare Huhn - 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 - There are no special considerations.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 07/2026 New Data View
- 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) | Numeric representation for the academic term (formerly the semester). The term code is derived as follows: Character 1 = Century (0 = 1900 and 1 = 2000) Character 2 & 3 = Academic Year Character 4 = Term ( 2=Fall, 4=Spring and 6=Summer) |
| 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. |
| 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 |
| COURSE_OFFER_NBR | Number(38,0) | Uniquely identify the course in the particular session. This number is 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. |
| 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 |
| CLASS_STATUS | Varchar2(1) | The status of a class section. Only data for active (A) classes are pulled into this data view. This field is included as a validity check. |
| 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. |
| EMPLOYEE_ID | Varchar2(30) | A unique number assigned to each employee and sourced from the HR system. Eight characters are in use. |
| 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. |
| SECTION_INSTR_COUNT | Number(38,0) | Total number of instructors associated with the COURSE_OFFER_NBR |
| EXTRACT_DATE_TIME | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |