- DATA VIEW NAME
- STDNT_ADVISOR_ASSIGNMENTS
- OVERVIEW
- All students with advisor assignments on the ps_stdnt_advr_hist record. This is different from the typical multiterm data view because this population is not tied to enrollment in one of the terms on the multiterm data views.
- LOAD FREQUENCY
- The data is refreshed nightly.
- 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
- SPECIAL
CONSIDERATIONS - This data view is designed for staff who need to manage/maintain advisor assignments. The information in the data view can mean slightly different things for undergraduates and graduate students. For undergraduates, it only contains CURRENT advising assignments. When a change is made to a student’s advisor assignment, the effective date of all assignments is changed to the same effective date. This practice means that advisor data cannot be used to determine how long students have been assigned to a particular advisor. Advisor history is not maintained and all advising records are deleted when a student graduates. This practice means that the full advising history of a student is not available in this data view (and in ISIS). For graduate students, this dataview may contain both current and historical advisor assignments.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 09/2012 – New view created.
- 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 |
|---|---|---|
| ID | varchar2(11) | ISIS personal Identifier. It 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. |
| 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) |
| Campus_ID | varchar2(16) | This is simply a unique student identifier (10 digits). It may change occasionally at the student’s request. |
| Name | varchar2(50) | Student’s primary name (last, first, middle with no space between last and first names). |
| Advisor_ID | varchar2(11) | ISIS personal Identifier of the advisor. This will be the committee member’s ID if advising is done by committee. This ID will never be changed throughout the individual’s relationship with the University. Only 10 characters are in use. |
| Advisor_Name | varchar2(50) | Advisor’s primary name (last, first, middle with no space between last and first names). |
| Advisor_Role_Code | varchar2(4) | The code for the role of the advisor. |
| Advisor_Role_Descr | varchar2(30) | The description of the advisor role. |
| Committee_ID | varchar2(6) | A code identifying the committee. Committee members as reported to the Graduate School on the degree warrant are not reflected in this data view. |
| Committee_Descr | varchar2(30) | Description of the committee. |
| Committee_Type | varchar2(10) | Type of committee |
| Committee_Role_Code | varchar2(4) | Role of the member of the committee |
| Committee_Role_Descr | varchar2(30) | The description of the committee role. |
| Advising_Level | varchar2(10) | This indicates whether or not the advisor is a program advisor or a plan advisor. Valid values: Program Plan |
| Advisee_Program_Code | varchar2(5) | The code for the student’s academic program on the advisor record. This is the program that the advisor assignment was based on and may not reflect the student’s current program. This is one field that can be used to identify advisor assignment discrepancies by comparing a student’s current program to this field. |
| Advisee_Program_Descr | varchar2(30) | The name of the student’s academic program matching the advisor record. This is the description of the program that the advisor assignment was based on. |
| Advisee_Program_Short_Descr | varchar2(10) | The name of the student’s academic program matching the advisor record truncated to 10 characters. This is the short description of the program that the advisor assignment was based on. |
| Advisee_Plan_Code | Varchar2 (10) | The code for the academic plan matching the advisor record. This is the plan that the advisor assignment was based on and may not reflect the student’s current plan. This is a second field that can be used to identify advisor assignment discrepancies by comparing a student’s current plan to this field. This field will be null if the advisor assignment was made at the program level. |
| Advisee_Plan_Descr | Varchar2(30) | The Academic Plan long description matching the advisor record. This is the description of the plan that the advisor assignment was based on. This field will be null if the advisor assignment was made at the program level. |
| Advisee_Plan_Short_Descr | varchar2(10) | The Academic Plan short description on the advisor record. This is the short description of the plan that the advisor assignment was based on. This field will be null if the advisor assignment was made at the program level. |
| Advisee_Plan_Transcript_Descr | varchar2(100) | The official name of the Plan as it would appear on a transcript. This is the transcript description of the plan that the advisor assignment was based on. This field will be null if the advisor assignment was made at the program level. |
| Last_Term_Enrolled | varchar2 (4) | The ISIS code for the most recent academic year and semester that the student was enrolled. Note that this can be in a future term if the enrollment period for that term is active. This field can be used to identify students who are not currently enrolled whose advisor assignment need to be changed. |
| Extract_Date_Time | Date | The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS |