SPB_ADD_USR_VW2

(SQL View)
 Index Back

view of spro users to create

11/28/2008:new view SPB_ADD_USR_VW2 is created to filter users other than Service Administrators(Usertype 5)

SELECT A.OPRID , A.OPRDEFNDESC FROM PSOPRDEFN_VW A WHERE A.OPRID NOT IN ( SELECT OPRID FROM PS_SPB_USER_LIST WHERE SPB_USER_TYPE = '5')

# 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 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user