- DATA VIEW NAME
- STDNT_PLAN_MULTITERM
- OVERVIEW
- This view contains academic plan information, for each student registered, for the two prior terms, the current term and up to two future terms. A student can have more than one plan. Withdrawn or deceased students are included but are identified accordingly.
- LOAD FREQUENCY
- For Fall and Spring, the data is refreshed daily from the first day of the term through the second full week of the classes. From the third week until the end of the term, the data is refreshed each weekend. For Summer, the data is refreshed daily from the first day of the term until the end of the term.
- DATA CUSTODIAN
- Registrar’s Office
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 - For demographic information such as Gender or the FERPA Indicator, link this view to UW_STUDENT_DEMOGRAPHIC.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 09/2001 – New view created.
09/2004 – Added field Plan Declaration Date
07/2011 – Remove fields Plan_Advisor and Advisor_Emplid
02/2012 – Custodian Change c4j
06/2012 – Change population to include all active subplans regardless of enrolled career. Also, added Career field to view
11/2014 – Preferred name policy s8w . - 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 |
|---|---|---|
| Term | Varchar2(4) | The ISIS code for the academic year and semester. |
| ID | Varchar2(11) | ISIS 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) | ID number assigned to ISIS to be used by student. Only ten characters are used. |
| Name | Varchar2(50) | Student’s preferred name (last, first, middle with no space between last and first names). |
| Withdrew_Ind | Varchar2(1) | Indicates if a student has withdrawn in the given term. Y = Student withdrew otherwise null. |
| 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 all 1999) |
| Academic_Program_Code | Varchar2(5) | The code for the student’s academic program. 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. |
| Plan_Type | Varchar2(3) | There are six plan types 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. |
| Degree_Objective | Varchar2(4) | |
| Plan_Group | Varchar2(3) | For PLans of type MAJ and MIN, this field consists of characters 5, 6, and 7 from the field Plan_Code. It aggregates all Plans into similar academic groups. For Plans of type MAJ it is called the Major code. Fpr PLans of type MIN it is called the minor code. For Plans other than MAJ and MIN it is null. |
| Certificate_Code | Varchar2(3) | For Plans of type CRT, this field consists of characters 5, 6, anf 7 from the field Plan_Code. It aggregates all Plans of type CRT into similar academic groups. For Plans of types other than CRT it is null. |
| Plan_Descr | Varchar2(30) | A description of the student’s subplan. |
| Transcript_Descr | Varchar2(100) | The official name of the Plan as it appears on the transcript. |
| Plan_Declaration_Date | Date | The date on which the student entered the cademic Plan associated to the student’s academic program. For Plans of type MAJ this represents the date the student declared their Major. |
| Extract_Date_Time | Date | The date and time these data were extracted from ISIS. Format : YYYYMMDD HH24:MI:SS. |