IB_SERVICENAMEIB_OPERATIONNAMEY/N Table Edit
Default Value: N
PSSERVPERM5_VW(SQL View) |
Index Back |
|---|---|
Service Operation PermissionsUsed in the service administration component to retrieve defined service operations that are not Rest services with a value of 1. These do not require permissions to be set. |
| SELECT A.IB_SERVICENAME , A.IB_OPERATIONNAME , C.IB_INTGROUPNAME , C.IB_INTGROUPSUBNAME , ' ' , ' ' , B.IB_REST_SERVICE FROM PSSERVICEOPR A , PSOPERATION B , PS_PSIBALSRVGRP_VW C WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.IB_SERVICENAME = C.IB_SERVICENAME AND B.IB_REST_SERVICE <> 1 |
| # | 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 |
| 5 | IB_NOPERMISSIONS | Character(1) | VARCHAR2(1) NOT NULL |
No Permissions Exist
Y/N Table Edit Default Value: N |
| 6 | IB_SERVICESECURITY | Character(1) | VARCHAR2(1) NOT NULL | Service Operation Security |
| 7 | IB_REST_SERVICE | Number(1,0) | SMALLINT NOT NULL | REST Service Type |