IB_WSDLNAMEIB_SERVICENAMEIB_OPERATIONNAMEVERSIONNAMEC=Changed After Export
E=Exported
N=Not Exported
PSSRVOPRWSDL_VW(SQL View) |
Index Back |
|---|---|
IB WSDL ViewView displays when WSDL exists for a given message/version combination. |
| SELECT DISTINCT a.ib_wsdlname , b.ib_servicename , b.ib_operationname , c.versionname , c.ib_exportstatus , d.msgname , d.ib_msgversion FROM psibwsdldfn a , psserviceopr b , PSOPRVERDFN c , PSOPRVERDFNparm d WHERE a.ib_servicename = b.ib_servicename AND b.ib_operationname = c.ib_operationname AND c.ib_operationname = d.ib_operationname AND c.versionname = d.versionname |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IB_WSDLNAME |
Character(70) | VARCHAR2(70) NOT NULL | WSDL Name (see PSIBWSDLDFN). |
| 2 | IB_SERVICENAME |
Character(30) | VARCHAR2(30) NOT NULL | Service (see PSSERVICE). |
| 3 | IB_OPERATIONNAME |
Character(30) | VARCHAR2(30) NOT NULL | Service Operation (see PSOPERATION). |
| 4 | VERSIONNAME |
Character(30) | VARCHAR2(30) NOT NULL | Service Operation Version |
| 5 | IB_EXPORTSTATUS | Character(1) | VARCHAR2(1) NOT NULL |
Export Status
C=Changed After Export E=Exported N=Not Exported |
| 6 | MSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN). |
| 7 | IB_MSGVERSION | Character(30) | VARCHAR2(30) NOT NULL | Message Version |