RC_SLADHC_APR_V

(SQL View)
 Index Back

Sol adhoc approver view

Solution Adhoc Approver View to show details of the approver

SELECT A.OPRID , A.PERSON_ID , c.Last_name , c.first_name , C.BO_NAME_DISPLAY , d.email_addr FROM PSOPRALIAS A LEFT OUTER JOIN PS_RD_PERSON B ON (A.PERSON_ID=B.PERSON_ID) LEFT OUTER JOIN PS_BO_NAME C ON ( B.BO_ID=C.BO_ID) LEFT OUTER JOIN PS_BO_PRI_EMAIL_VW D ON ( B.BO_ID=D.BO_ID AND role_type_id=86)

# 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
6 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.