- DATA VIEW NAME
- STDNT_CRSE_SECT_INSTRUCTOR
- OVERVIEW
- This data view is includes all instructors of record for a course section. The data is available for Fall 2024-25 (term 1252) and beyond. There is one row per term, session code, course id, course offer number, section number, instructor id.
- LOAD FREQUENCY
- Nightly
- DATA CUSTODIAN
- Office of the Registrar
Contact: Andrew Hahn - 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 - N/A.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 09/2025 – 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 |