- DATA VIEW NAME
- STDNT_SUBPLAN_MULTITERM
- OVERVIEW
- This view contains academic sub-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
- Data will be refreshed nightly (Monday through Friday).
- 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. ISIS does not require every student to have a sub-plan. Joining this view to other views, such as UW_STUDENT_DEMOGRAPHIC, using an equal join (the default) will produce only the students with sub-plans. To display all students, including those without sub-plans, an outer join (or its equivalent) must be used.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 09/2001 – New view created.
09/2004 – Added field Subplan Declaration Date
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 be changed throughout the individual’s relatioship with the University. This is not the same as Campus_ID. Only ten characters are in use. |
| Campus_ID | Varchar2(16) | ID number assigned ti ISIS to be used by students. 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 claasification, e.g., BA, BS, BUS,HEC,EGR. The graduate student’s 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_Code | Varchar2(10) | The code for Academic Plan associated to the student’s academic program. For Plans of type MAJ this represents the student’s Major. |
| Subplan_Type | Varchar2(3) | Subplans are grouped by their relation to the Plan. Some Plans may offer multiple types of Subplans. Values are: TRK = Track OPT = Option HON = Honors |
| Subplan_Code | Varchar2(10) | The code for the student’s subplan. Students may have zero or more Subplans associated with each Plan. This field will be null if no Subplan is associated with a Plan. |
| Subplan_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. |
| Subplan_Declaration_Date | Date | The date on which the student entered the Academic SubPlan associated with the student’s plan. For plans of type MAJ this represents the date the student declared their Option (official sub-plan) or Track (unofficial sub-plan) for that Major. |
| Extract_Date_Time | Date | The date and time these data were extracted. Format: YYYYMMDD HH24:MI:SS |