PSSERVICE_VW(SQL View) |
Index Back |
|---|---|
IB services view. |
| SELECT DISTINCT B.IB_SERVICENAME , A.IB_OPERATIONNAME , A.RTNGTYPE , A.DEFAULTVER , A.IB_ALIASNAME , A.DESCR FROM PSSERVICEOPR B , PSOPERATION A WHERE B.IB_OPERATIONNAME = A.IB_OPERATIONNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Service (see PSSERVICE). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Service Operation (see PSOPERATION). | |
| 3 | RTNGTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Routing Type
A=Asynchronous - One Way N=Synchronous Non-Blocking R=Asynch Request/Response S=Synchronous X=Asynch to Synch |
| 4 | DEFAULTVER | Character(30) | VARCHAR2(30) NOT NULL | Default Application Message Version |
| 5 | IB_ALIASNAME | Character(128) | VARCHAR2(128) NOT NULL | Service Alias |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |