PSAUTHWS_VW

(SQL View)
 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 Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
3 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).