- DATA VIEW NAME
- STDNT_MULTITERM
- OVERVIEW
- This view contains student demographic information, for each student registered, for the two prior terms, the current term and up to two future terms. Students who have withdrawn or are deceased are also included but have been identified accordingly.
- LOAD FREQUENCY
- A FERPA indicator is provided in this view and it is the users responsibility to check this indicator if the information is being considered for release.
Data will be refreshed nightly (Monday through Friday).
- DATA CUSTODIAN
- Registrar’s Office
Contact: Phil Hull - AUTHORIZATION
- For information about how to get authorized for InfoAccess data views, connect to InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - There are no special considerations.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 09/2001 – New view created.
06/2002 – Eliminated the following data elements.
(Refer to data view Stdnt_Actions _Multiterm for this information.)
Drop_Action_Code
Drop_Action_Descr
Probation_Action_Code
Probation_Action_Descr
Permission_Action_Code
Permission_Action_Descr
Last_Action_Taken
Clearing_Action_Code
Clearing_Action_Descr
Clearing_Action_Date
03/2003 – Many changes were implemented.
1) Nine new fields have been added to the view.
They are:
Term_Descr
Academic_Level_Proj
Academic_Level_EOT
Term_Credits_Total
Term_Taken_Credits_NoGPA
Term_Taken_Credits_Progress
Term_Taken_Credits_Prog_Grad
Term_Inprog_Credits_Total
Term_Inprog_Credits_NoGPA
2) In addition to the above new fields some of the existing credit/gpa related fields were reordered.
3) Country_of_Birth_Ind field name was corrected to Country_of_Birth_Descr (to match the data)
4) Term_Taken_Credits_Total was increased to allow for 999999.999 (as ISIS does)
5) Cum_Credits_Total and Cum_Taken_Credits_GPA are now reported for GRAD career as well as other career’s
6) Term_GPA and Cum_GPA have been changed to report 0 only if the student has failed all courses. Null when it has not been determined.
09/2003
Corrected definitions of fields Citizen_Ind, Citizen_Status, Ethnic_Group, Diversity, Minority, and Targeted_Minority.
03/2004
Added documentation for Citizen_Status with a value of 7. Also added a warning to the Special Considerations section.
04/2005
Updated code and documentation to make sure Citizen_Status=7 are dealt with appropriately. Fields impacted were: Citizen_Status, Citizen_Ind, Country_of_Citizenship, Ethnic_Group, Diversity, Diversity_Descr, Targeted_Minority, and Minority.
06/2005
Admit_Type changed to make sure EOR admit types are shown. Also when reviewing the ethnicity detail when setting Targeted Minority it was decided it was not necessary to look for Ethniciy_Primary = Y but instead look for any row for the student with the Ethnic Code ACAMLAOV.
09/2009
Updated Diversity, Ethnic_Group, and Minority fields.
12/2011
Seven study abroad related fields have been removed. Stdnt_Study_Abroad data view should be used if the information is needed.
02/2012 – Custodian Change.
06/2014 – Change the program to populat the Term_Taken_Credits_Prog_Grad field to show all graduate level courses taken by a student regardless of their career. This will allow credits to be calculated correctly for dual career students.
07/2014 – Changed Term_Taken_Credits_Prog_Grad field to show qualifying credits values for all careers (not just GRAD)
12/2014 – Preferred name policy s8w .
04/2020 Removed fields:
Diversity
Diversity Descr
Ethnic Group
Ethnic Group Descr
Minority
Targeted Minority
11/2023 – Implemented targeted fix to DEG_EXPECTED calculation for specific sets of students with multiple plans.
02/2024 – Corrected DECEASED_IND to flag student as deceased in term of death and after. - DATA FORMATS
- Key fields are identified with an asterisk (*) Field Formats describe the field type and length.
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’
NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions. X = total number of digits and Y = the number of digits after the decimal.
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12DATE = 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 academic year and semester. |
| *ID | VARCHAR2 11 | ISIS personal Identifier. The ID 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 occasionally at the student’s request. |
| NAME | VARCHAR2 50 | The student’s preferred name. Note: this field is current as of the Refresh date posted in the last field, EXTRACT_DATE_TIME. Format: Last First Middle. This may be case sensitive with some query tools. |
| FERPA_FLAG | VARCHAR2 1 | Restricted information indicator. Y = information restricted. |
| DECEASED_IND | VARCHAR2 1 | Indicates a student is deceased. Flagged the term they died and any term after (if enrolled). Y = deceased otherwise, null |
| WITHDREW_IND | VARCHAR2 1 | Indicates if a student withdrew in the given term. Y = withdrew otherwise, null |
| WITHDREW_REASON | VARCHAR2 4 | The reason a student withdrew, as reported by the student or determined administratively. Values are: BADC = Bad Check CANC = Course Cancelled DECD = Deceased DROP = Student Dropped Courses MEDI = Medical MILT = Military Service MISC = Miscellaneous NPAY = Non-Payment of Fees PERS = Personal RESI = Residency Denied RETR = Retroactive SCHC = Scholastic WBTT = Withdraw by Touchtone |
| WITHDREW_DATE | DATE | Date of withdrawal. Format: YYYYMMDD |
| PRIMARY_ACADEMIC_ GROUP |
VARCHAR2 5 | Academic group (e.g, College or School) associated to the student’s Primary Academic Program for the given term. Each Program is associated to a unique Academic Group. Values are: ALS College of Agricultural & Life Sciences AMN Officer Education BUS School of Business DCS Division of Continuing Studies EDU School of Education EGR College of Engineering HEC School of Human Ecology IES Nelson Institute for Environmental Studies L&S College of Letters and Science LAW Law School MED School of Medicine and Public Health MSN University of Wisconsin – Madison (Admin only) NUR School of Nursing PHM School of Pharmacy RGE Research and Graduate Education VET School of Veterinary Medicine |
| ACADEMIC_LEVEL | VARCHAR2 3 | The student’s academic level at the beginning of the given term for the given Career. Values are: 05 = Spcl, Guest 10 = Freshman 20 = Sophomore 30 = Junior 40 = Senior GR = Graduate P1 = Professional Year 1 P2 = Professional Year 2 P3 = Professional Year 3 P4 = Professional Year 4 |
| ACADEMIC_LEVEL_PROJ | VARCHAR2 3 | The student’s academic level projected for the beginning of that given term. This includes all completed credits, in-progress credits and transfer credits (includes other and test credits) for all prior terms. Values are: 05 = Spcl, Guest 10 = Freshman 20 = Sophomore 30 = Junior 40 = Senior GR = Graduate P1 = Professional Year 1 P2 = Professional Year 2 P3 = Professional Year 3 P4 = Professional Year 4 |
| ACADEMIC_LEVEL_EOT | VARCHAR2 3 | The student’s academic level calculated to include completed credits for that given term. Values are: 05 = Spcl, Guest 10 = Freshman 20 = Sophomore 30 = Junior 40 = Senior GR = Graduate P1 = Professional Year 1 P2 = Professional Year 2 P3 = Professional Year 3 P4 = Professional Year 4 |
| CAREER_TYPE | VARCHAR2 1 | A grouping of the values of Career into 4 types. Values are: U = Undergraduate G = Graduate (excluding students jointly enrolled in professional programs) P = Professional (includes students jointly enrolled in graduate programs) including Law, Pharmacy, Med, and Vet Med S = Special (not enrolled in any degree program) |
| CAREER | VARCHAR2 4 | The type of academic career in which the student is currently enrolled. Values are: UGRD = Undergraduate GRAD = Graduate VMED = Veterinary Medicine Professional LAW = Law Professional MEDS = Medical Professional PHAR = Pharmacy Professional USPC = University Special Students UGST = University Guest Students (discontinued all 1999) |
| CAREER_DESCR | VARCHAR2 30 | The description of the student’s career. |
| GENDER | VARCHAR2 1 | The student’s sex. Values are: F=Female M= Male U= Unknown. |
| AGE | NUMBER 2 | The students age as of the first day of classes for Fall of Spring; for Summer, the first day of the eight-week session. |
| CITIZEN_IND | VARCHAR2 1 | Indicates whether a student is a US citizen (citizen_status = 1 or 2). Values are: Y = US Citizen N = Not a US Citizen U = Unknown (citizen_status = U or NULL) |
| CITIZEN_STATUS | VARCHAR2 1 | The student’s citizenship status. Valid values are: 1 = Native 2 = Naturalized 3 = Alien Permanent 4 = Alien Temporary 5 = Alien 6 = Refugee 7 = Domestic, status pending U = Unknown |
| RESIDENCY | VARCHAR2 1 | Indicates whether the student is a Wisconsin resident in their first term. Values are: R = Student is a resident N = Student is not a resident U = FISC Wisconsin Resident |
| TUITION_RESIDENCY | VARCHAR2 1 | Indicates the residency status of a student for tuition purposes. A tuition reciprocity agreement exists between Minnesota and Wisconsin. Some non-resident students from Minnesota pay fees comparable to the University of Minnesota, Twin Cities campus, based on a designated formula. Values are: N = non-Wisconsin resident R = Wisconsin resident S = Minnesota compact student U = FISC Wisconsin Resident |
| VISA_PERMIT_TYPE | VARCHAR2 3 | Identifies the type of entry into this country granted to the student. To identify codes contact the Office of International Students and Scholars. |
| VISA_PERMIT_NUMBER | VARCHAR2 15 | This is the number used for reporting to the immigration and naturalization service. |
| COUNTRY_OF_CITIZENSHIP | VARCHAR2 3 | Abbreviation for country of citizenship. |
| COUNTRY_OF_CITIZENSHIP_ DESCR |
VARCHAR 30 | The name of the country of citizenship. |
| COUNTRY_OF_BIRTH | VARCHAR2 3 | Abbreviation of the country of birth. |
| COUNTRY_OF_BIRTH_DESCR | VARCHAR2 30 | The name of the country of birth. |
| PRIMARY_SUPPORT_DESCR | VARCHAR2 30 | Identifies the primary type of financial support for International Students. |
| SECONDARY_SUPPORT_ DESCR |
VARCHAR2 30 | Identifies the secondary type of financial support for International Students. |
| MARTIAL_STATUS_DESCR | VARCHAR2 30 | The student’s marital status. This is self-reported. Values are: Single Married Separated Divorced Widowed Unknown Otherwise, null |
| VETERAN_STATUS | VARCHAR2 1 | This indicates a student’s self-reported veteran status at time of last refresh of the given term (anyone who receives Federal orders). Values are: Y = veteran otherwise, null |
| ACADEMIC_LOAD | VARCHAR2 1 | Indicates if a student is full time, ‘F’, or part time, ‘P’. For undergrads and special students, full-time means 12 or more credits. More specifically, students who don’t meet the criteria for part-time (below) are considered full-time. Part-time status in the Registrar’s Enrollment Report, means: Undergrad Total credits less than 12 Special Total credits less than 12 Masters** Total credits less than 8* Phd** Total credits less than 8* Law Total credits less than 12 Pharm prof Total credits less than 12 Med Total credits less than 9 Vet Med Total credits less than 12* Prior to Fall 93, < 9 = Part-time ** Exceptions to aboveStudents in Warwick Exchange, CIC, Med Fellow, or Medical College of Wisconsin carry zero credits, but are considered full-time.Year Abroad students are registered for 12 or more credits and are considered full-time.Graduate students employed by the University as a teaching assistant 1/3 time or more with 5 or more credits, or more than 1/2 time with 4 or more credits are considered full-time. However, employment information is not normally known in time for the enrollment report. Dissertators are full-time. |
| ADMIT_TYPE | VARCHAR2 3 | This field indicates the admissions status of the student in the given term. Values are: CON= Continuing (Special students only- temporary- these students should never matriculate) EOR= Engineering Outreach Student (applies to UGRD careers only) FYR= First Year Student (applies to UGRD careers only) NEW= New to career (does not apply to UGRD careers) RAD= Readmitted to career RET= Re-admitted with transfer work (applies to UGRD careers only) TRF= Transfer (does not apply to Grad and Special students) |
| ACADEMIC_ADVANCEMENT_ PROG |
VARCHAR2 1 | Indicates whether the student is in the academic advancement program (a minority retention program administered by the college of Letters of Science). Values: Y= program participant otherwise, null |
| DISSERTATOR_IND | VARCHAR2 1 | Indicates the student is a dissertator in the given term. Values are: Y = the student is a dissertator in the given semester otherwise, null |
| HIGH_SCHOOL_CODE | VARCHAR2 11 | The high school from which the student graduated. Use the InfoAccess look-up table, UW_HIGH_SCHOOL_CODES, for translation of this code. These codes are also found in the InfoAccess table, UW.PREVIOUS_INSTITUTION_CODES. |
| HIGH_SCHOOL_PERCENTILE | NUMBER 3 | The student’s percentile rank based on their high school GPA. |
| MATRICULATION_TERM | VARCHAR2 4 | The term a student was first enrolled at UW-Madison in a non-special career. |
| DEG_EXPECTED | VARCHAR2 1 | Indicates the student is expecting a degree or planning to attend commencement in the current term. Y = yes, graduating C = not graduating, but planning to attend commencement otherwise, null |
| TERM_CREDITS_TOTAL | NUMBER(8,3) | The total of all credits “”earned”” by the student in a given term. This total includes credits that are passed, transfer, test, and other credits. Excluded are audits, credits with final grades not considered to be passed, and in-progress credits (unreported grades, P’s, I’s, etc.). NOTES: The value may change as grades are posted or changed. For graduate students, the value represents the number of credits earned (passed) toward a graduate degree (excluding pass/fail, audits, and courses below the 300 level). |
| TERM_TAKEN_CREDITS_ TOTAL |
NUMBER(9,3) | The total of credits earned (whether passed or not) by the student in enrolled courses at UW-Madison. Credits for which a student earned a grade of NW (No Work) may be included. Excluded are audits and in-progress credits (unreported grades, P’s, I’s, etc.). NOTES: The value may change as grades are posted or changed. |
| TERM_TAKEN_CREDITS_GPA | NUMBER(8,3) | The portion of the credits taken on the Madison campus in the previous term that are used to calculate a student’s semester GPA. This excludes courses taken pass/fail, credit/no-credit. This field will not contain course credits for Pass/Fail courses, Audit Credit courses, or courses with grades other than A, AB, B, BC, C, D, F, NW (no work). This will include “In Progress” credits. Transfer credits are excluded. |
| TERM_TAKEN_CREDITS_ NOGPA |
NUMBER(8,3) | The portion of graded credits taken on the Madison campus that do not count toward the GPA. Excluded are audits and in-progress credits (unreported grades, P’s, I’s, etc.). NOTES: The value may change as grades are posted or changed. Included for graduate students are pass/fail and courses below the 300 level. |
| TERM_TAKEN_CREDITS_ PROGRESS |
NUMBER(8,3) | The total of all credits in a given term for which a student is enrolled on the UW-Madison campus. The total includes both graded and in-progress credits. Excluded are transfer, test, other, and audit credits. |
| TERM_TAKEN_CREDITS_ PROG_GRAD |
NUMBER(8,3) | This field should be used for checking current term enrollment for graduate students. Depending on alignment with Graduate School policies and requirements, the total includes credits for a given term that will potentially apply toward a graduate degree and/or count toward full-time status. The total includes both graded (whether passed or not) and in-progress credits. Excluded are pass/fail, audit, and courses below the 300 level. |
| TERM_INPROG_CREDITS_ TOTAL |
NUMBER(8,3) | The total of credits in a given term for which the student does not have a final grade. This includes all unreported grades, P’s, I’s, etc. Excluded are audits. NOTES: The value may change as grades are posted or changed. |
| TERM_INPROG_CREDITS_GPA | NUMBER(8,3) | The portion of a student’s in-progress credits that will count toward the GPA. NOTES: The value may change as grades are posted or changed. |
| TERM_INPROG_CREDITS_ NOGPA |
NUMBER(8,3) | The portion of a student’s in-progress credits that will not count toward the GPA. Excluded are audits. NOTES: The value may change as grades are posted or changed. |
| TERM_CREDITS_AUDIT | NUMBER(8,3) | The total number of credits taken for Audit in the given term. |
| TERM_GRADE_POINTS | NUMBER(9,3) | The total (i.e. sum of the) number of Grade Points earned by the student in the given semester which are used to compute the student’s grade point average for the given semester on the UW-Madison campus. NOTES: The Grade Points earned by a student for a given course are the credits for the course multiplied by the numerical grade received by the student: A = 4.0; AB = 3.5; B = 3.0; BC = 2.5; C = 2.0; D = 1.0; F = 0.0; NW=0.0. |
| TERM_GPA | NUMBER(8,3) | The TERM_GRADE_POINTS divided by TERM_TAKEN_CREDITS_GPA. Contains zero for students who failed all courses; contains Nulls when the GPA has not been determined. |
| CUM_CREDITS_TOTAL | NUMBER(8,3) | The total credits earned by the student up to and including the given term. This should be the sum of all the TERM_CREDITS_TOTAL for all terms in the given career up to and including the present term. It includes transfer, test and other credits as well as UW-Madison credits. |
| CUM_TAKEN_CREDITS_GPA | NUMBER(8,3) | This should be the sum of all the TERM_TAKEN_CREDITS_GPA for all terms in the same career up to and including the given term. |
| CUM_TRANSFER_CREDITS | NUMBER(8,3) | This should be the sum of all the transfer credits for all terms in the same career up to and including the given term. This does not include test and other credits. |
| CUM_TEST_CREDITS | NUMBER(8,3) | This should be the sum of all the test credits for all terms in the same career up to and including the given term. Some examples are CEEB, AP, and credits by examination. |
| CUM_OTHER_CREDITS | NUMBER(8,3) | This should be the sum of all the other credits for all terms in the same career up to and including the given term. An example is retroactive credits. |
| CUM_ GRADE_POINTS | NUMBER(9,3) | This should be the sum of all the TERM_GRADE_POINTS for all terms in the same career up to and including the given term. For the current term the value may change as grades are posted. |
| CUM _GPA | NUMBER(6,3) | The CUM_GRADE_POINTS divided by CUM_TAKEN_CREDITS_GPA. Contains zero for students who failed all courses; contains Nulls when the GPA has not been determined. NOTES: This is the Grade Point Average for all work completed at UW-Madison. |
| PREVIOUS_TERM_GPA | NUMBER(8,3) | The most recent non-null GPA prior to the given term. Not populated for new Freshmen. |
| PREVIOUS_GPA_TERM | VARCHAR2 4 | The code for the most recent term enrolled. |
| CLASS_RANK_NUMBER | NUMBER 5 | The student’s GPA rank within their academic level and academic group within the given term. |
| CLASS_RANK_TOTAL | NUMBER 5 | The total number of students in the given student’s academic level and academic group within the given term. |
| NEGATIVE_SERVICE_IND | VARCHAR2 1 | Indicated whether a student has a negative service indicator placed on their record. Values are: Y = yes otherwise, nullIf the value is Y, the student may have one or more negative service indicators. Please look in ISIS to determine how many and which indicators have been placed on a students record. |
| SEMESTER_HONORS1 | VARCHAR2 6 | A student’s Dean’s Honors action as it stands at the end of a semester, either an indication of Honors. The view retrieves the first 2 actions for the given term. Examples of Deans’ Action Codes include: DNHHL = Dean’s High Honors DNHL = Dean’s Honor List DNLST = Dean’s List GOOD = Congratulations-Good Semester HHNRL = High Honor Roll HNRRL = Honor Roll SOHHNR = Sophomore High Honors SOHNHR = Sophomore Honors-Honors Program SOPHNR = Sophomore Honors. |
| SEMESTER_HONORS2 | VARCHAR2 6 | The second Dean’s Honors action pertaining to the student for the given term. |
| SPORT_CODE1 | VARCHAR2 3 | The code for the first sport listed for a participating student athlete. |
| SPORT_CODE1_DESCR | VARCHAR2 30 | The description for the first sport listed for a participating student athlete. |
| ATHLETE_CODE1 | VARCHAR2 5 | The code for the team for the first sport listed for a participating student athlete. Example: The sport code is HO, Ice Hockey; the team codes are MIH, Men’s Ice Hockey or WIH, Women’s Ice Hockey. |
| ATHLETE_CODE1_DESCR | VARCHAR2 30 | The description of the team for the first sport listed for a participating student athlete. |
| SPORT_CODE2 | VARCHAR2 3 | The code for the second sport listed for a participating student athlete. |
| SPORT_CODE2_DESCR | VARCHAR2 30 | The description for the second sport listed for a participating student athlete. |
| ATHLETE_CODE2 | VARCHAR2 5 | The code for the team of the second sport listed for a participating student athlete. Example: The sport code is HO, Ice Hockey; the team codes are MIH, Men’s Ice Hockey or WIH, Women’s Ice Hockey. |
| ATHLETE_CODE2_DESCR | VARCHAR2 30 | The description for the team for the second sport listed for a participating student athlete. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted from SIS. Format: YYYYMMDD HH24:MI:SS |