EOPMWSDEFN_VW (SQL View)	Index Back
Web Service Defn View A joint view on tables PSAUTHWS and PSOPERATION, used to find permission lists referencing the same object Only service operations where IB_REST_SERVICE <> 1 can have permissions assigned.

EOPMWSDEFN_VW

(SQL View)

Web Service Defn View

A joint view on tables PSAUTHWS and PSOPERATION, used to find permission lists referencing the same object 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 AND C.IB_SERVICENAME > ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

2 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
Prompt Table: PSWSOPRDEFN_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN).
2	IB_SERVICENAME	Character(30)	VARCHAR2(30) NOT NULL	Service (see PSSERVICE). Prompt Table: PSWSOPRDEFN_VW