INSTR_ADVSR_VW

(SQL View)
 Index Back

Instructor Advisor View

This view is used as the edit table for Advisor ID in Student Advisor if the Advisor Edit in the student's Academic Program is set to Advisors Only.

SELECT C.OPRCLASS , B.EMPLID , B.EFFDT , B.EFF_STATUS , B.ACAD_ORG , C.COUNTRY , C.NATIONAL_ID_TYPE , D.DESCRSHORT , C.NATIONAL_ID , C.NATIONAL_ID_MSK , E.NAME , A.CAMPUS_ID , E.LAST_NAME_SRCH , E.FIRST_NAME_SRCH , B.INSTITUTION FROM PS_SCC_PERS_SA_VW A , PS_INSTR_ADVISOR B , PS_PERS_NID_MSK_VW C , PS_NID_TYPE_TBL D , PS_HCR_PERSON_NM_I E WHERE B.ADVISOR = 'Y' AND A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.EMPLID = E.EMPLID AND D.COUNTRY = C.COUNTRY AND D.NATIONAL_ID_TYPE = C.NATIONAL_ID_TYPE

# 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
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 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
7 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

Prompt Table: NID_TYPE_TBL
Set Control Field: NID_COUNTRY

8 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description
9 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
10 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID
11 NAME Character(50) VARCHAR2(50) NOT NULL Name
12 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
13 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
14 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
15 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL