INSTR_ORG_VW

(SQL View)
Index Back

Instr Advisor View - Subjects

Instructor Edit in the Academic Organization Table indicates if Class Instructor ID should prompt on Personal Data or Instructor Advisor Table. This view is used as the prompt table for Class Instructor ID if Instructor Edit is set to Instructor Advisor Table and NO checkboxes are on. Instructors who are defined as Advisors Only are excluded.

SELECT C.ACAD_ORG , B.EMPLID , B.EFFDT , C.CRSE_ID , C.CRSE_OFFER_NBR , C.CAMPUS , B.INSTR_AVAILABLE , B.INSTR_TYPE , B.EFF_STATUS , A.NAME , D.CAMPUS_ID , A.LAST_NAME_SRCH , A.FIRST_NAME_SRCH FROM PS_SCC_CUR_NM_VW2 A , PS_INSTR_ADVISOR B , PS_INSTR_CRSE C , PS_SCC_PERS_SA_VW D WHERE B.INSTR_TYPE <> 'ADV' AND A.EMPLID = B.EMPLID AND B.EMPLID = C.EMPLID AND C.EMPLID = D.EMPLID AND B.EFFDT=C.EFFDT AND B.INSTITUTION=C.INSTITUTION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

Prompt Table: ACAD_ORG_TBL

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EFFDT Date(10) DATE Effective Date
4 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
5 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
6 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
7 INSTR_AVAILABLE Character(2) VARCHAR2(2) NOT NULL Instructor Available
A=Available
S=Sabbatical
U=Unavailable
8 INSTR_TYPE Character(4) VARCHAR2(4) NOT NULL Instructor Type
ADJ=Adjunct Professor
ADV=Advisor Only
ASSC=Associate Professor
ASST=Assistant Professor
EMRT=Emeritus
INST=Instructor
LECT=Lecturer
PROF=Professor
TA=Teaching Assistant
UNDF=Undefined
VLEC=Visiting Lecturer
VPRF=Visiting Professor
9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
10 NAME Character(50) VARCHAR2(50) NOT NULL Name
11 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
12 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
13 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name