- DATA VIEW NAME
- ADMISSIONS_SPECIAL_GUEST
- OVERVIEW
- This shows University Special and Guest admissions information (academic career = USPC or UGST). There are applications for multiple terms available. Only the most recent application information entered will be available (i.e. most recent application and program action). This view contains information on the students ethnic group. If the codes are needed in addition to the ethnic group you will need to get authorized for UW.STUDENT_ETHNIC_CODES as well.
- LOAD FREQUENCY
- The data is refreshed every night.
- DATA CUSTODIAN
- Division of Continuing Studies
Contact: Sarah Stilp - 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 - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 03/1999 New data view created.
10/1999 Five new fields added:
Targeted_Minority_Ind
Citizenship_status
Citizenship
Residency_date
Veteran
09/2009 – Updated Ethnic_Group field. c4j
10/2013 Changed to Varchar2 format c4j
12/2014 Preferred name policy s8w
04/2020 Remove fields:
Ethnic_Group
Ethnic_Group_Minority
Targeted_Minority - 12/2024 – Updated legal sex values
- DATA FORMATS
- Key fields are identified with an asterisk(*)
The codes following the field names in this document define the field. The different types are:
Char: Character data
Number: Numeric fields will be null if no data is available.
Date: This data type allows the date to be represented in various formats and date related functions to be used against the field. The formats (i.e. 19980203, 10-jun-98) and functions available vary based on your query tool.
| Column Name | Format | Description |
|---|---|---|
| *ID | Varchar2(11) | ID number assigned by ISIS to be used internally. This is a unique ID for each student. |
| CAMPUS_ID | Varchar2(16) | ID number assigned to ISIS to be used by student (formerly Student ID) |
| LAST_NAME | Varchar2(30) | Student’s preferred last name. |
| FIRST_NAME | Varchar2(30) | Student’s preferred first name. |
| MIDDLE_NAME | Varchar2(30) | Student’s preferred middle name. |
| GENDER | Varchar2(1) | Student’s legal sex, if indicated. F = Female M = Male X = Another Legal Sex U = Unknown |
| BIRTHDATE | DATE | Student’s date of birth |
| VISA_PERMIT_TYPE | Varchar2(3) | Type of VISA student holds |
| CITIZENSHIP | Varchar2(1) | Valid Indicator Y = Citizen N = Not Citizen U = Unknown |
| CITIZENSHIP_STATUS | Varchar2(1) | Valid Status: 1 = Native 2 = Naturalized 3 = Alien Permanent 4 = Alien Temporary 5 = Alien 6 = Refugee N = Not indicated |
| COUNTRY_CITIZENSHIP | Varchar2(3) | Country code of the country from which student comes |
| RESIDENCY_CODE | Varchar2(5) | N = Non Resident of WI R = Wisconsin Resident S = Minnesota Compact U = Unknown Blank = No decision made |
| RESIDENCY_DATE | DATE | Date residency was established. |
| TUITION_RESIDENCY_CODE | Varchar2(5) | |
| VETERAN | Varchar2(1) | Indicates whether student is a veteran. Y = Yes Blank = No |
| HOME_ADDRESS_LINE1 | Varchar2(35) | First line of home address |
| HOME_ADDRESS_LINE2 | Varchar2(35) | Second line of home address |
| HOME_ADDRESS_LINE3 | Varchar2(35) | Third line of home address |
| HOME_ADDRESS_LINE4 | Varchar2(35) | Fourth line of home address |
| HOME_ADDRESS_CITY | Varchar2(30) | City of home address |
| HOME_ADDRESS_STATE | Varchar2(6) | State of home address |
| HOME_ADDRESS_POSTAL | Varchar2(12) | Zip code of home address |
| HOME_ADDRESS_COUNTRY | Varchar2(3) | Country of home address |
| HOME_ADDRESS_COUNTRY_DESCR | Varchar2(30) | Full name of home country |
| HOME_PHONE | Varchar2(24) | Telephone number at student’s home address |
| MAIL_ADDR_LINE1 | Varchar2(35) | First line of mailing address |
| MAIL_ADDR_LINE2 | Varchar2(35) | Second line of mailing address |
| MAIL_ADDR_LINE3 | Varchar2(35) | Third line of mailing address |
| MAIL_ADDR_LINE4 | Varchar2(35) | Fourth line of mailing address |
| MAIL_ADDR_CITY | Varchar2(30) | City of mailing address |
| MAIL_ADDR_STATE | Varchar2(6) | State of mailing address |
| MAIL_ADDR_POSTAL | Varchar2(12) | Zip code of mailing address |
| MAIL_ADDR_COUNTRY | Varchar2(3) | Country of mailing address |
| MAIL_ADDR_COUNTRY_DESCR | Varchar2(30) | Full name of mailing address country |
| MAIL_PHONE | Varchar2(24) | Telephone number at student’s mailing address |
| EMAIL_ADDRESS | Varchar2(70) | Student’s e-mail address |
| *APPLICATION_NUMBER | Varchar2(8) | ISIS system generated number |
| ADMIT_TERM | Varchar2(4) | Term student has applied for. The term code is derived as follows: The first number is the century, 0=1900 and 1=2000; the second and third numbers are the year; the last number is the term, 2-Fall, 4-Spring, and 6=summer. For Example, Fall 1998-99 would be 0992 and Summer 1998-99 would be 0996. |
| ADMIT_TYPE | Varchar2(3) | A code indicating the type of admission. CON = Continuing to an application center NEW = New RAD = Readmit |
| ADMIT_TYPE_DESCR | Varchar2(30) | Full description of admit type |
| ADMIT_APPL_DATE | DATE | Date that application was entered |
| ACADEMIC_CAREER | Varchar2(4) | USPC = University Special Student USGT = University Guest Student |
| ACADEMIC_GROUP | Varchar2(5) | School or College e.g., DCS, L&S, ALS, etc.) |
| ACADEMIC_PROGRAM | Varchar2(5) | Academic Program was formerly known as classification. Valid values: UNDS UNRS UNVS UNES UNHS UNIS UNOS UNPS GUES |
| ACADEMIC_PLAN | Varchar2(10) | Sub category of Academic Program (e.g., UNDS999) |
| ACADEMIC_LEVEL | Varchar2(3) | Academic standing. For special and guest students this should always be NDG which means Non-degree. |
| PROGRAM_STATUS | Varchar2(4) | Applicant, etc. Valid codes are: AC AD AP CN |
| PROGRAM_ACTION | Varchar2(4) | Decision made from application. ADMT = Admit APPL = Application COND = Conditional Admit DDEF = Defer Decision DEFR = Defer Enrollment DENY = Deny WADM = Administrative Withdrawal WAPP = Applicant Withdrawl |
| PROGRAM_ACTION_DESCR | Varchar2(30) | Full description of Program Action |
| ACTION_DATE | DATE | Date action was taken |
| PROGRAM_REASON | Varchar2(4) | Supporting reason for action taken. Valid codes for University Special and Guest Students are: S05 = Application Received S11 = Admitted S13 = Admitted did not Register S32 = Admit Pending Residency S33 = Incomplete UW Transcript Hold S40 = Do not admit S41 = Continuing Not Process S50 = Student Withdrew Application S51 = Referred to Undergrad Admt S6 = Not Coming S71 = Need Information WDRW = WD for administrative reasons |
| PROGRAM_REASON_DESCR | Varchar2(30) | Full description of Program Reason |
| RECRUITER_ID | Varchar2(11) | EmplID of Admissions Recruiter assigned to applicant. |
| RECRUITER_NAME | Varchar2(50) | Preferred name of Admissions Recruiter assigned to applicant. |
| ADVISOR_NAME | Varchar2(50) | The preferred name of the advisor associated with the applicant’s academic plan. |
| ADVISOR_DEPT | Varchar2(10) | Department of advisor associated with the applicant’s academic plan. |
| PREV_INSTITUTION_CODE | Varchar2(11) | Last institution attended by the applicant. |
| EXTRACT_DATE | DATE | The System generated date when the data was last refreshed. Format: mm/dd/ccyy. |