- DATA VIEW NAME
- RETENTION_PLAN_HISTORY
- OVERVIEW
- This view contains a complete term-by-term history of all Programs, Plans and Subplans declared by each student enrolled since the summer term of 1984-85 academic year. (term 0856)
- LOAD FREQUENCY
- Prior three terms are replaced the 3rd of each month.
Note: Changes to Programs, Plans and Subplans are rarely retroactive. The rows in this view will rarely change as a result of the floating 3-term refresh/append strategy.
- 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 the InfoAccess Home Page
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- O4/2001 – New view created.
11/2002 – Load Frequency changed.
07/2011 – Fields Program_Advisor and Plan_Advisor have been cleared for all students except those with GRAD career. This is becasue this information is not kept historically in ISIS.
02/2012 – c4j Custodian Change
11/2014 – s8w Preferred name policy. - 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 |
|---|---|---|
| *Term | varchar2 (4) | The code for the academic year and semester. |
| Term_Descr | varchar2 (30) | Description of the code for the academic year and semester. |
| *ID | varchar2 (11) | A 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) | A unique student identifier (10 digits). Campus-ID may change occasionally at the student’s request. |
| 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 Fall 1999) |
| *Academic_Program_ Number |
varchar2 (2) | The number of a specific program in a sequence of programs. |
| *Academic_Program_Code | varchar2 (5) | The code for the student’s academic program. Formerly known as the Classification of the student’s program. Each student Plan is associated to a unique Program. |
| Academic_Program_Descr | varchar2 (30) | The description of the student’s academic program. |
| Academic_Group | varchar2 (5) | The Academic group (College or School) in which the student is enrolled in the given term. Each plan is part of a unique Program, and every Program is associated with a unique Academic Group. Join to the data view ACADEMIC_GROUP_CODES to retrieve the descriptions below. Values are: ALS = Agricultural and Life Sciences BUS = School of Business DCS = Division of Continuing Studies EDU = School of Education EGR = College of Engineering IES = Institute for Environmental Studies L&S = College of Letters & Science LAW = School of Law MED = School of Medicine NUR = School of Nursing PHM = School of Pharmacy VET = School of Veterinary Medicine CIC = Committee on Institutional Cooperation HEC = School of Human Ecology MSN = UW-Madison (indicates that the student’s Plan is linked to a career rather than a program. Most Certificates, Additional Majors, and Minors have MSN for Academic Group.) |
| Plan_Type | varchar2 (3) | The code for the type of plan.There are 6 plan types currently used (the other values listed below are active in ISIS, but not currently used). Values are: CAP = Capstone Certificate CRT = Certificate HON = Honors MAJ = Major MIN = Minor NON = No Plan Associated SP = Specialization TCH = Teaching Certification |
| *Plan_Code | varchar2 (10) | The code for the Academic Plan associated to the student’s academic program. For Plans of type MAJ this represents the student’s Major. |
| Plan_Descr | varchar2 (30) | A description of the Academic Plan. |
| Plan_Group | varchar2 (3) | Plan_Group aggregates all Plans into similar academic groups. For Plans of type MAJ and MIN, contains characters 5, 6, and 7 from the field PLAN_CODE. For Plans of type MAJ it is called the Major code. For Plans of type other than MAJ or MIN, Plan_Group is not populated. |
| Plan_Group_Descr | varchar2 (100) | A description of the Academic Plan Group. |
| Program_Advisor | varchar2 (50) | This field is only populated for students with Career = GRAD and contains the preferred name of the student’s advisor for the student’s academic program as of the end of the given term, starting in term 1142. Prior to the fall of 2014 it shows the primary/legal name. |
| Plan_Advisor | varchar2 (50) | This field is only populated for students with Career = GRAD and contains the preferred name of the student’s advisor for the student’s academic plan as of the end of the given term, starting in term 1142. Prior to the fall of 2014 it shows the primary/legal name. Not populated for students who have not declared a Plan. |
| *Subplan_Code | varchar2 (10) | The code for the student’s sub plan. Students may have zero or more Subplans associated with each Plan. |
| Subplan_Descr | varchar2 (30) | A description of the student’s sub plan. |
| Subplan_Type | varchar2 (3) | Subplan Type classifies Subplans by their relation to the Plan. Values are: TRK = Track OPT = Option HON = Honors |
| Major_Fte_Percent | number (5,3) | The Major FTE Percent is equal to 1 divided by the number of Plans of type MAJ that the student has declared as of the given term. Allows one to sum over a record set consisting of plans of type MAJ to get the FTE (Full-Time-Equivalent) number of majors. |
| Extract_Date_Time | Date | The date and time these data were extracted. |