PSOPERATION_VW4 (SQL View)	Index Back
IB Non-default versions. View of non-default service operation versions currently defined in the IB system.

PSOPERATION_VW4

(SQL View)

IB Non-default versions.

View of non-default service operation versions currently defined in the IB system.

SELECT a.ib_operationname FROM psoperation a WHERE a.ib_rest_service = 1 AND NOT EXISTS ( SELECT 'X' FROM PSSERVICE b WHERE a.ib_servicename = b.ib_servicename and b.pt_open_api = 1)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).