PSSERVPERM4_VW

(SQL View)
 Index Back

Perms for Serv Operations

Service operations that have been assigned to at least one permission list.

SELECT DISTINCT A.IB_SERVICENAME , A.IB_OPERATIONNAME , C.IB_INTGROUPNAME , C.IB_INTGROUPSUBNAME FROM PSSERVICEOPR A , PSAUTHWS B , PS_PSIBALSRVGRP_VW C WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.IB_SERVICENAME = C.IB_SERVICENAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
2 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
3 IB_INTGROUPNAME Character(30) VARCHAR2(30) NOT NULL Integration Group Name (see PSIBGROUPDEFN).
4 IB_INTGROUPSUBNAME Character(30) VARCHAR2(30) NOT NULL Integration Subgroup Name