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 | 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 | 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 |