- DATA VIEW NAME
- STDNT_GRAD_DECISIONS
- OVERVIEW
- Admissions decisions for applicants to Graduate School from the online Graduate School Application Management System, GWIS. Be sure to pull only applicants to your program (major) so you won’t get more records than you want.
- LOAD FREQUENCY
- The data are refreshed nightly.
- DATA CUSTODIAN
- Graduate School
Contact: Katie Bourassa - 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 - Be sure to pull only applicants to your program (major) so you won’t get more records than you want.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 12/1998 New data view.
03/2002 Created view using varchar2
09/2004 Data Custodian change
01/2013 Documentation updated
11/2014 Preferred name policy s8w. - DATA FORMATS
- 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 |
|---|---|---|
| EMPLID | VARCHAR2(11) | The ISIS system’s unique identifier. (This is not the campus or student ID). |
| CAMPUS_ID | VARCHAR2(16) | Formerly known as “Student ID”, this is the number that goes on the student’s ID card. |
| LAST_NAME | VARCHAR2(30) | Applicant’s preferred last name. |
| FIRST_NAME | VARCHAR2(30) | Applicant’s preferred first name. |
| MIDDLE_NAME | VARCHAR2(30) | Applicant’s preferred middle name. |
| ACAD_CAREER | VARCHAR2(4) | The type of academic career in which the student is currently enrolled. This field is always “GRAD” in this dataview. |
| ADM_APPL_NBR | VARCHAR2(8) | Application Number. |
| APPL_PROG_NBR | NUMBER (3.0) | Sequence of programs to which the applicant applied beginning with zero. If the applicant applied to multiple programs, each will have it’s own number. |
| EFFECTIVE_DATE | DATE | Date the program action is effective. |
| EFFECTIVE_SEQ | NUMBER (3.0) | Sequence in which action codes are entered within a given program action date. |
| ACAD_PROG | VARCHAR2(5) | Program (major) code (i.e. G###, DNP, or AUD). |
| PROG_ACTION | VARCHAR2(4) | Category of program reason. ADMT = Admit APPL = Applied DDEF = Decision deferred DENY = Denied, refused, rejected, turned away RECN = Department wants applicant to be reconsidered WADM = Administrative Withdrawal WAPP = Applicant withdrawal ADRV = Admission Revoked (entered by Registrar’s Office) DEFR = Defer Enrollment MATR = Matriculation PRGC = Program Change (entered by Registrar’s Office) More information on the codes can be found in GWIS. http://www.grad.wisc.edu/education/admissions/gwis/deccodes.html , http://www.grad.wisc.edu/education/admissions/gwis/gs_deccodes.html |
| ACTION_DATE | DATE | Date the program action was submitted in GWIS. |
| PROG_REASON | VARCHAR2(4) | See GWIS for a list of codes, the program action category each falls into, and the description: http://www.grad.wisc.edu/education/admissions/gwis/deccodes.html http://www.grad.wisc.edu/education/admissions/gwis/gs_deccodes.html |
| PROG_REASON_DESCR | VARCHAR2(30) | Description of the program reason. |
| ADMIT_TERM | VARCHAR2(4) | The term for which the applicant has applied for admission. This field uses the term codes from ISIS: First digit is century (0 for 20th, 1 for twenty-first). Second and third digits are last two digits of the fiscal year (13 for fall, 2012; spring 2013, and summer 2013). Fourth digit is the term (2 = fall, 4 = spring, 6 = summer). Example: Fall, 2012 = 1132 Spring, 2013 = 1134 Summer, 2013 = 1136 |
| REQ_TERM | VARCHAR2(4) | |
| LOADDATE | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |