- DATA VIEW NAME
- STDNT_PROGRAM_MULTITERM
- OVERVIEW
- This view contains academic program 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 program. 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
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 09/2001 – New view created
07/2011 – Removed fields Program_Advisor and Advisor_Emplid
02/2012 0 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. |
| Academic_Program_Short_Descr | Varchar2(10) | The name of the student’s academic program truncated to 10 characters. |
| Academic_Program_Descr | Varchar2(30) | The name of the student’s academic program. For undergraduates it is a description of what was formerly known as the student’s classification, e.g., General Course BA/BS Degree. For graduate students it’s the name of their major, e.g., Chemistry. |
| Extract_Date_Time | Varchar2(17) | The date and time these data were extracted from ISIS. |