- DATA VIEW NAME
- STDNT_INSTR_ADV_JOB
- OVERVIEW
- This view contains job information for each active instructor or advisor found in ISIS who has a current or future job in the University’s Human Resource System. An instructor or advisor will have one row for each active or future job.
- 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 job 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_Job 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 job 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
- 04/2011 – New view created.
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. |
| *Empl_Rcd | varchar2 (2) | Employee Record Number. Identifies each job. For most employees, the number iwll be zero. Employees with multiple concurrent jobs will have a unique record number for each job, assigned sequentially based on date of hire for each job (but could be reused over time). |
| Empl_Class | varchar2 (3) | Employee Class. A code assigned to a job record to group similar jobs. |
| Jobcode | varchar2 (5) | Job Code identifies the employee’s job classification/title. |
| UW_Jobcode_Descr | varchar2 (21) | Descriptive name for the job code. |
| Deptid | varchar2 (7) | Department ID is a code that identified the organizational department in which the person is employed. Also know as UDDS of the employing department. |
| UW_Deptid_Descr | varchar2 (39) | The long descriptive name for the Department ID. This will usually be the name of the department where the instructor or advisor is employed. |
| UW_Deptid_Comb_Descr | varchar2 (67) | This is the combined long name associated with the Department ID. Example: MSNL&SSOCIOLOGYGEN |
| Job_Start_Date | Date | Date the job was started based on actions of hire, rehire or transfer. |
| Job_End_Date | Date | Date the job has ended based on actions of termination or transfer. Will be NULL if the job has not ended.. |
| 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 |