IB_SERVICENAMEIB_OPERATIONNAMEVERSIONNAMELANGUAGE_CDPSIBWSDLOPR_LVW(SQL View) |
Index Back |
|---|---|
IB WSDL rel. language. |
| SELECT T.IB_SERVICENAME , B.IB_OPERATIONNAME , C.VERSIONNAME , D.LANGUAGE_CD , D.DESCR FROM PSSERVICE A , PSOPERATION B , PSSERVICEOPR T , PSOPRVERDFN C , PSOPERATIONLANG D WHERE T.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.IB_SERVICENAME = B.IB_SERVICENAME AND B.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND B.DEFAULTVER = C.VERSIONNAME AND B.IB_OPERATIONNAME = D.IB_OPERATIONNAME AND A.IB_REST_SERVICE = 0 |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |