DOC_UIDSERVICENAMEWPORTNAMEPORTTYPENAMEOPERATION_UIDPSWSOPS_VW(SQL View) |
Index Back |
|---|---|
WSDL Service Operations View |
| SELECT DISTINCT A.DOC_UID ,A.SERVICENAMEW ,A.PORTNAME ,B.PORTTYPENAME ,B.OPERATION_UID ,B.OPERATIONNAME ,B.BINDINGPROTOCOL ,B.TRANSPORT ,B.SOAPACTION ,B.OPERATIONSTYLE FROM PSWSENDPOINT A , PSWSBINDOPS B WHERE A.DOC_UID = B.DOC_UID AND B.BINDINGNAME = A.BINDINGNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DOC_UID |
Character(40) | VARCHAR2(40) NOT NULL | WSDL Name |
| 2 | SERVICENAMEW |
Character(60) | VARCHAR2(60) NOT NULL | Service Name |
| 3 | PORTNAME |
Character(60) | VARCHAR2(60) NOT NULL | Port Name |
| 4 | PORTTYPENAME |
Character(60) | VARCHAR2(60) NOT NULL | PortType Name |
| 5 | OPERATION_UID |
Character(40) | VARCHAR2(40) NOT NULL | Operation Id |
| 6 | OPERATIONNAME | Character(60) | VARCHAR2(60) NOT NULL | Operation |
| 7 | BINDINGPROTOCOL | Character(20) | VARCHAR2(20) NOT NULL | Binding Protocol |
| 8 | TRANSPORT | Character(60) | VARCHAR2(60) NOT NULL | Transport |
| 9 | SOAPACTION | Character(120) | VARCHAR2(120) NOT NULL | Soap Action |
| 10 | OPERATIONSTYLE | Character(10) | VARCHAR2(10) NOT NULL | Binding Style |