IB_SERVICENAMEIB_OPERATIONNAMEVERSIONNAMEA=Asynchronous - One Way
N=Synchronous Non-Blocking
R=Asynch Request/Response
S=Synchronous
X=Asynch to Synch
A=Active
I=Inactive
Y/N Table Edit
PSWSDLSVCOPR_VW(SQL View) |
Index Back |
|---|---|
Service Operation Lang ViewService Operation Lang View |
| SELECT A.IB_SERVICENAME , B.IB_OPERATIONNAME , B.VERSIONNAME , A.IB_ALIASNAME , A.RTNGTYPE , B.DESCR , B.ACTIVE_FLAG , C.IB_REQMSGNAME , C.INMSGVERSION , C.IB_RESPMSGNAME , C.OUTMSGVERSION , C.IB_FLTMSGNAME , C.FLTMSGVERSION , A.IB_USERPWDREQ FROM PSOPERATION A , PSOPRVERDFN B , PSOPRVERMSGS_VW C WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.DEFAULTVER = B.VERSIONNAME AND B.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND B.VERSIONNAME = C.VERSIONNAME AND A.RTNGTYPE IN ('A', 'R', 'S') AND EXISTS ( SELECT 'X' FROM PSRTGANYPARMVW X WHERE X.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND X.VERSIONNAME = B.VERSIONNAME) |
| # | 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 | VERSIONNAME |
Character(30) | VARCHAR2(30) NOT NULL | Service Operation Version |
| 4 | IB_ALIASNAME | Character(128) | VARCHAR2(128) NOT NULL | Service Alias |
| 5 | 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 |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive |
| 8 | IB_REQMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Name. Name of the Application Message Definition. |
| 9 | INMSGVERSION | Character(30) | VARCHAR2(30) NOT NULL | In Message Version |
| 10 | IB_RESPMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Name. Name of the Application Message Definition. |
| 11 | OUTMSGVERSION | Character(30) | VARCHAR2(30) NOT NULL | Out Message Version |
| 12 | IB_FLTMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Name. Name of the Application Message Definition. |
| 13 | FLTMSGVERSION | Character(30) | VARCHAR2(30) NOT NULL | Fault Message Version |
| 14 | IB_USERPWDREQ | Character(1) | VARCHAR2(1) NOT NULL |
User/Password Required
Y/N Table Edit |