AV_STF_EMAIL_VW

(SQL View)
Index Back

Staff Operator Id

Provides all operator id's for staff members and their corresponding emailid's.

SELECT DISTINCT B.INSTITUTION , A.OPRID , A.EMPLID , C.NAME , A.EMAILID FROM PSOPRDEFN A , PS_AV_STAFF B , PS_HCR_PERSON_NM_I C WHERE A.EMPLID=B.STAFF_ID AND A.EMPLID = C.EMPLID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_AV_STAFF B1 WHERE B1.INSTITUTION=B.INSTITUTION AND B1.STAFF_ID = B.STAFF_ID AND B1.STAFF_TYPE = B.STAFF_TYPE AND B1.EFFDT <= %CurrentDateIn ) AND B.EFF_STATUS = 'A' AND A.EMAILID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 AV_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address