- DATA VIEW NAME
- STDNT_FINAL_GRADE_ROSTER
- OVERVIEW
- This view contains final grade information pulled from ISIS for the current term. It includes the grade reported by the instructor for all students. Grades will be blank for those who do not yet have an assigned grade. 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 replaced daily starting in the third week of the term and continuing until 3 weeks after the term has been completed. After the end of the grade reporting period, the RETENTION_COURSE_HISTORY view should be used to retrieve student grades.
- 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
- 05/2007 – New view created.
10/2011 – Set this up so it can now run for summer and added Session_Code field.
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 | VARCHAR2(4) | The ISIS code for the academic year and semester. |
| TERM_DESCR | VARCHAR2(30) | Description of the code for the UW Madison academic year and semester. |
| *ID | VARCHAR2(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 | VARCHAR2(16) | This is simply a unique student identifier (10 digits). It may change. |
| NAME | VARCHAR2(50) | Student’s preferred 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 | VARCHAR2(6) | A unique identifier for each course offered in a given semester. The COURSE_ID is the same for cross-listed courses. |
| SUBJECT_DESCR | VARCHAR2(30) | The name of the department offering the course. |
| SUBJECT_CODE | VARCHAR2(8) | The code for the department offering the course. |
| COURSE_TITLE | VARCHAR2(30) | The title of the course. |
| CATALOG_NUMBER | VARCHAR2(10) | The number assigned to the course in the course catalog. Also known as the Course number. |
| 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. |
| 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: |
| *CLASS_SECTION | VARCHAR2(4) | The section number of the class. |
| CREDITS_TAKEN | NUMBER (5,2) | The number of credits the student is taking the course for. |
| GRADE | VARCHAR2(3) | The grade that the student has received. |
| GRADING_BASIS | VARCHAR2(3) | The code for the basis used to grade the student in this course. |
| 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, you will only get the first instructor. You will only get the instructor of the graded section of the class, which will often be a TA for large lecture/lab/discussion courses. |
| 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, you will only get the first instructor. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |