SAD_INSTRUCT_VW

(SQL View)
Index Back

Instructor Advisor View

Instructor Advisor View 08/07/05 - ICE1294210000 - SQL changes: personal_data replaced by people_srch (oprclass field added) and person_name removed ( replaced by hcr_person_nm_i in people_srch)

SELECT DISTINCT A.OPRCLASS , B.EMPLID , B.EFFDT , B.EFF_STATUS , B.ACAD_ORG , A.NAME , C.CAMPUS_ID , A.LAST_NAME_SRCH , A.FIRST_NAME_SRCH FROM PS_INSTR_ADVISOR B , PS_PEOPLE_SRCH A , PS_PERSON_SA C WHERE B.ADVISOR = 'Y' AND A.EMPLID = B.EMPLID AND C.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
8 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
9 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name