PSIBWSDLSVCVW

(SQL View)
 Index Back

View for Default WSDL


SELECT DISTINCT A.IB_SERVICENAME , A.VERSION , A.IB_NAMESPACE , A.IB_ALIASNAME , A.IB_PSOFTSERVICE , A.OBJECTOWNERID , A.DESCR FROM PSSERVICE A , PSIBWSDLDFN B WHERE A.IB_SERVICENAME = B.IB_SERVICENAME AND B.IB_WSDLURL=' ' AND B.IB_WSDL_DEFAULT = 1 AND A.IB_REST_SERVICE = 0

  • Related Language Record: PSIBWSDLSVC_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default Value: 1

    3 IB_NAMESPACE Character(254) VARCHAR2(254) NOT NULL Service Namespace
    4 IB_ALIASNAME Character(128) VARCHAR2(128) NOT NULL Service Alias
    5 IB_PSOFTSERVICE Character(1) VARCHAR2(1) NOT NULL Restricted Service

    Y/N Table Edit

    Default Value: N

    6 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description