- DATA VIEW NAME
- STDNT_MIDTERM_GRADE_ROSTER
- OVERVIEW
- This view contains mid-term grade information pulled from ISIS for terms 1082 forward.. It includes the grade reported by the instructor for all students attending a post-secondary institution for the first time. Grades will be blank for those who do not participate in the mid-term grading process. The view also includes class information about each graded section of a class and the “primary” instructor name and id (if present) associated with the class. To obtain program, plan, and advisor data, the data view must be joined to the appropriate student multiterm view containing that information.
- LOAD FREQUENCY
- Data will be added once a semester, following the deadline for instructor submission of mid-term grades (approximately the end of the seventh week of classes).
- 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 InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 10/2003 – New view created.
10/2008 – Changed from current term to terms 1082 and forward.
02/2012 – c4j Custodian Change
12/2014 – s8w Preferred name policy. - DATA FORMAT
- 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 | VARCHAR(4) | The ISIS code for the academic year and semester. |
| TERM_DESCR | VARCHAR(30) | Description of the code for the UW Madison academic year and semester. |
| *ID | VARCHAR(11) | ISIS personal identifier. It will never be changed throughout the individual’s relationship with the University. This is not the same as Campus_ID. Only 10 characters are in use. |
| CAMPUS_ID | VARCHAR(16) | This is simply a unique student identifier (10 digits). It may change occasionally at the student’s request. |
| NAME | VARCHAR(50) | Student’s preferred name starting in term 1142. Prior to the fall of 2014 it shows the primary/legal name(last, first, middle with no space between last and first names). |
| CLASS_NBR | 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. |
| *COURSE_ID | VARCHAR(6) | A unique identifier for each course offered in a given semester. The COURSE_ID is the same for cross-listed courses. |
| SUBJECT_DESCR | VARCHAR(30) | The name of the department offering the course. |
| SUBJECT_CODE | VARCHAR(8) | The code for the department offering the course. |
| COURSE_TITLE | VARCHAR(30) | The title of the course. |
| CATALOG_NUMBER | VARCHAR(10) | The number assigned to the course in the course catalog. Also known as the Course number. |
| *CLASS_SECTION | VARCHAR(4) | The section number of the class. |
| GRADE | VARCHAR(3) | The mid-term grade that the student has received. |
| GRADING_BASIS | VARCHAR(3) | The code for the basis used to grade the student in this course. |
| INSTRUCTOR_ID | VARCHAR(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, you will only get the first instructor. |
| INSTRUCTOR_NAME | VARCHAR(50) | Preferred name of the instructor(starting in term 1142. Prior to the fall of 2014 it shows the primary/legal name) assigned to teach a particular section. If two or more instructors are teaching the same class, you will only get the first instructor. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |