- DATA VIEW NAME
- STDNT_MILESTONES
- OVERVIEW
- This view contains student milestone information and includes UW-Madison undergraduate, graduate, and professional careers. Milestones are unique to ISIS and did not exist in the legacy system.
The view contains milestones from non-GRAD careers beginning with Spring 1999 (Term 0994), including remedial English, remedial math, School of Pharmacy immunization records, etc.
GRAD milestones were created from conversion of the 3270 GASP system (graduate academic satisfactory progress). The view contains GRAD milestones earned since Summer 1985 (Term 0856). Please note that prior to Summer 1999 (Term 0996), some graduate students may have incomplete milestone data. Also, some milestones types were inactivated after Summer 1999.
- LOAD FREQUENCY
- Data is replaced daily Monday – Friday.
- DATA CUSTODIAN
- Office of the Registrar
- 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 - There are no special considerations.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 06/2002 – New view created.
02/2012 – Custodian Change
12/2014 – Preferred name policy - 09/2017 – Added Milestone Effective Date
- 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 |
|---|---|---|
| *ID | varchar2 (11) | Personal Identifier. ID will never change 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) | A unique student identifier (10 digits). The ID may change occasionally at the student’s request. |
| NAME | varchar2(50) | The student’s preferred name. Format is preferred Last, preferred First preferred Middle. |
| *MILESTONE_CAREER | varchar2 (4) | The type of academic career in which the student was enrolled when earning the milestone. 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 Fall 1999) |
| *MILESTONE_ACADEMIC_ PROGRAM_CD |
varchar2(5) | The code for the student’s academic program in which the student earned the milestone. For undergraduates it was formerly known as the student’s classification, e.g., BA, BS, BUS, HEC, EGR.
For graduate students program includes their departments, e.g., G153 is a graduate student in Chemistry. Some Graduate majors can be offered in more than one school/college. For them you’ll see a single character college code at the end of the Academic_Program_Code. |
| MILESTONE_EFFECTIVE_DATE | DATE | The date the milestone took effect. |
| *MILESTONE_PLAN_CODE | varchar2 (10) | The code for academic plan associated with the student’s academic program in which the student earned the milestone. For plans of type MAJ, this represents the student’s major, and for plans of type MIN, this represents the student’s minor. |
| MILESTONE_PLAN_CODE_ DESCR |
varchar2(30) | The description of the milestone plan code. |
| MILESTONE | varchar2 (10) | The designation for each milestone. For grad school, active milestones are: GDISSTATUS Grad Dissertator Status GPHDMAJREQ Grad PhD/DMA Major Reqmts Comp GPHDMINOR Grad PhD Minor Progr Completed GPHDTHESAP Grad PhD Dissertation Approved GPRLEXAM Grad Preliminary Exam Passed GPRLEXMEXT Grad Prelim Exam Ext Approved GPRLEXMRET Grad Prelim Exam Retake Pass MCOMPFEEPD Masters Degree Comp Fee Paid |
| MILESTONE_TITLE | varchar2 (254) | For grad school, Milestone Title is used only with the milestone GPHDTHESAP, and it contains the student’s PhD dissertation title. |
| MILESTONE_COMPLETE_IND | varchar2 (1) | Indicates if the milestone is complete. Y=Yes, N=No |
| MILESTONE_DESCR | varchar2(10) | The short description of the milestone. |
| MILESTONE_COMPLETED_DATE | date | The date the milestone was completed. |
| MILESTONE_COMPLETION_TERM | varchar2 (4) | The term in which the milestone was completed. |
| EXTRACT_DATE_TIME | date | The date and time these data were extracted from the source system. |