PSWSDEFN_VW

index back

Web Service Defn View

A joint view on tables PSAUTHWS and PSOPERATION, used as main record for page - ACL_WS_OPR. Only service operations where IB_REST_SERVICE <> 1 can have permissions assigned.
SELECT DISTINCT A.CLASSID , C.IB_SERVICENAME FROM PSAUTHWS A , PSOPERATION B , PSSERVICEOPR C WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND B.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND B.IB_REST_SERVICE <> 1 AND B.IB_READONLY_PERM <> 1

PeopleSoft Field Name Field Type Column Type Description
CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).

Prompt Table: PSWSOPRDEFN_VW

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19