- 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 (Workday). 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 - 07/2025 – Data sources changed to Workday
- – Fields Removed:
-
- EMPL_RCD
- EMPL_CLASS
- JOBCODE
- UW_JOBCODE_DESCR
- DEPTID
- UW_DEPT_DESCR
- UW_DEPT_ID_COMB_DESCR
- – Fields Added:
-
- POSITION_ID
- JOB_CODE
- JOB_TITLE
- BUSINESS_TITLE
- JOB_CATEGORY
- DEPARTMENT_ID
- DEPARTMENT_NAME
- SUPERVISORY_ORG_ID
- SUPERVISORY_ORG_COMB_DESCR
- COST_CENTER_ID
- COST_CENTER_NAME
- 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 |
|---|---|---|
| PVI | VARCHAR2(9) | Publicly Visible Identifier |
| INSTRUCTOR_ID | VARCHAR2(10) | SIS 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. |
| POSITION_ID | VARCHAR2(10) | A number associated with the position/job. |
| JOB_CODE | VARCHAR2(10) | Identifies the employees job classification/title. |
| JOB_TITLE | VARCHAR2(80) | Descriptive name/title for the job code. |
| BUSINESS_TITLE | VARCHAR2(80) | Business title for the position. |
| JOB_CATEGORY | VARCHAR2(20) | A code assigned to a job to group similar jobs. |
| DEPARTMENT_ID | VARCHAR2(10) | A code that represents an academic or administrative department. Also known as the cost center hierarchy level 7 (CCHL7). |
| DEPARTMENT_NAME | VARCHAR2(80) | Descriptive name associated with the Department_ID. |
| 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.. |
| SUPERVISORY_ORG_ID | VARCHAR2(10) | A code representing the supervisory organization. |
| SUPERVISORY_ORG_COMB_DESCR | VARCHAR2(80) | Combination of Supervisory Org Code + Supervisory Org Name associated with the position. |
| COST_CENTER_ID | VARCHAR2(10) | A code representing the default Cost Center assigned to the supervisory organization. |
| COST_CENTER_NAME | VARCHAR2(80) | The name for the default Cost Center assigned to the supervisory organization. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted from ISIS. Format : YYYYMMDD HH24:MI:SS |