PSWSOPRDEFN_VW

(SQL View)
 Index Back

Web Service Operation Def View

Used as prompt table for PSWSDEFN_VW.IB_SERVICENAME.

SELECT DISTINCT A.IB_SERVICENAME , A.DESCR FROM PSSERVICE A , PSOPERATION B WHERE A.IB_SERVICENAME = B.IB_SERVICENAME AND B.IB_REST_SERVICE <> 1 AND B.IB_READONLY_PERM <> 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).

Prompt Table: PSSERVICE

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description