- DATA VIEW NAME
- ADMISSIONS_PHARMACY
- OVERVIEW
- This shows Pharmacy admissions information (academic career = PHAR.) 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 authorization for UW.STUDENT_ETHNIC_CODES as well.
- LOAD FREQUENCY
- The data is refreshed every workday night
- DATA CUSTODIAN
- School of Pharmacy
Contact: Beth Janetski - 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
- 05/1999 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_Descr
Targeted_Minority - 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 sex, if indicated. F = Female M = Male 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. |
| 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_GROUP | Varchar2(5) | School or College e.g., PHM, etc.) |
| ACADEMIC_PROGRAM | Varchar2(5) | Academic Program was formerly known as classification. Valid values: DPH NTPD |
| ACADEMIC_PLAN | Varchar2(10) | Sub category of Academic Program (e.g., NTPD756, DPH756) |
| ACADEMIC_LEVEL | Varchar2(3) | Academic standing. (e.g., P1, P2) |
| PROGRAM_STATUS | Varchar2(4) | Valid codes are: AC = Active in Program AD = Admitted AP = Applicant CM = Completed Program CN = Cancelled DC = Discontinued DE = Deceased DM = Dismissed LA = Leave of Absence PM = Prematriculant SP = Suspended WT = Waitlisted |
| PROGRAM_ACTION | Varchar2(4) | Decision made from application. Valid values are: ADMT = Admit ADRV = Admission Revocation APPL = Application COND = Conditional Admit DATA = Data Change DDEF = Defer Decision DEFR = Defer Enrollment DEIN = Intention to Matriculate DENY = Deny MATR = Matriculation PLNC = Plan Change PRGC = Program Change RAPP = Readmit Application RECN = Reconsideration WADM = Administrative Withdrawal WAIT = Waitlist WAOF = Waitlist Offer WAPP = Applicant Withdrawal |
| PROGRAM_ACTION_DESCR | Varchar2(30) | Full description of Program Action |
| ACTION_DATE | DATE | Date action was taken |
| 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. |
| EXTRACT_DATE | Date | The System generated date when the data was last refreshed. Format: mm/dd/ccyy. |