AS OF 4/15/11 THIS VIEW IS NO LONGER UPDATED. Information is from Legacy HR (IADS) and view will be phased out. Please use Stdnt_Instr_Adv_Job which is populated from HRS data.
- DATA VIEW NAME
- STDNT_INSTR_ADV_APPOINTMENT
- OVERVIEW
- This view contains appointment information for each active instructor or advisor found in ISIS who has a current or future appointment in the University’s Human Resource System. An instructor or advisor will have one row for each active or future appointment.
- LOAD FREQUENCY
- This view is refreshed each week day morning.
- 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 the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - It is advised that you use this data view in conjunction with term specific data views such as Stdnt_Timetable_Multiterm or Stdnt_Course_Roster_Mulitterm to get appointment information on instructors currently teaching. You may also wish to use the Stdnt_Instr_Adv_Directory data view for additional information not carried in the Stdnt_Instr_Adv_Appointment data view.
The population of instructors and advisors comes from the ISIS student information system, which keeps records active for a three year period. Currently, if an instructor has not taught in the past three years, that instructor record is inactivated in ISIS and eliminated from this data view upon refresh. Instructors may also be eliminated from this data view if their appointment in the Human Resources System has ended.
See data definition for Major Dept UDDS for additional special considerations.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 07/2004 – New view created.
06/2008 – Data Custodian change. C4j
1/2010 – Data Custodian Change C4j
09/2012 – Data Custodian Contact changed from Karen Hanson to Kim Alling - 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 |
|---|---|---|
| *Instructor_Id | varchar2 (11) | ISIS emplid. This never changes throughout the individual’s relationship with the University. This is not the same as Campus_ID. Only 10 characters are in use. |
| *Appt_ID | varchar2 (8) | Appointment ID from the Human Resource System |
| Appt_Type | varchar2 (2) | Code from the Human Resource System indicating the type of appointment. |
| Title_Code | varchar2 (5) | Code from the Human Resource System indicating the type of title held by employee. |
| Title_Name | varchar2 (21) | Descriptive name for the title code. |
| Major_Dept_UDDS | varchar2 (7) | UDDS of the employing department from the Human Resource System. Note that an individual can have more than one appointment in different Major Dept UDDS codes. UDDS codes are those codes used in the Human Resource System. An understanding of the UDDS schemata will aid the user if attempting to select specific departments’ instructors or advisors. |
| Major_Dept_UDDS_Long_Name | varchar2 (39) | The long descriptive name for the udds code. This will usually be the name of the department where the instructor or advisor is appointed. |
| Major_Dept_UDDS_Comb_Name | varchar2 (67) | This is the combined long name: Example: MSNL&SSOCIOLOGYGEN |
| Appt_Begin_Date | Date | Begin date for the appointment from the Human Resource System. |
| Appt_End_Date | Date | End date for the appointment from the Human Resource System. Can be NULL. |
| PVI_Number | varchar2 (9) | Publicly Visible Identifier |
| Extract_Date_Time | Date | The date and time these data were extracted from ISIS. Format : YYYYMMDD HH24:MI:SS |