PSAUTHWS_VW

index back

Authorized Web Services View

This query view prompts for PeopleSoft User ID.
SELECT B.OPRID , C.IB_SERVICENAME , A.IB_OPERATIONNAME FROM PSAUTHWS A , PSOPRCLS B , PSWSDEFN_VW C WHERE A.CLASSID = B.OPRCLASS AND A.CLASSID = C.CLASSID

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19