INSTR_IND_I_VW

(SQL View)
Index Back

Instructor Advisor View

This Instructor Advisor view is used as the prompt table for independent studies Instructor ID if a given course is assigned an Instructor/Advisor Table Edit.

SELECT DISTINCT B.EMPLID , B.EFFDT , B.EFF_STATUS , A.NID_COUNTRY , A.NATIONAL_ID_TYPE , A.NID_DESCRSHORT , A.NATIONAL_ID , A.SEX , A.NAME , A.CAMPUS_ID , A.LAST_NAME_SRCH , A.FIRST_NAME_SRCH FROM PS_PEOPLE_SRCH A , PS_INSTR_ADVISOR B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EFFDT Date(10) DATE Effective Date
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
5 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

Prompt Table: NID_TYPE_TBL
Set Control Field: NID_COUNTRY

6 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description
7 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
8 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
9 NAME Character(50) VARCHAR2(50) NOT NULL Name
10 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
11 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
12 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name