HRS_APRV_USR_VW

(SQL View)
 Index Back

Approver Users

Approver Users

SELECT A.OPRID , A.EMPLID ,B.LAST_NAME ,B.FIRST_NAME ,B.NAME_DISPLAY ,C.EMAIL_ADDR , D.COUNTRY_CODE , D.PHONE , D.EXTENSION ,E.COUNTRY_CODE , E.PHONE FROM PSOPRDEFN A , PS_PERSON_NAME B LEFT OUTER JOIN PS_PERSON_EMAIL C ON C.EMPLID = B.EMPLID LEFT OUTER JOIN PS_PERSON_PHONE D ON D.EMPLID = B.EMPLID LEFT OUTER JOIN PS_PERS_PHONE_CELL E ON E.EMPLID = B.EMPLID WHERE B.EMPLID = A.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
6 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
7 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
8 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
9 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension
10 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code
11 MOBILE Character(24) VARCHAR2(24) NOT NULL Mobile phone number.