PSIBWSDL2_VW (SQL View)	Index Back
IB View of the WSDL repository Shows the list of WSDLs in the repository but ignoring the multiple records that could be found there.

PSIBWSDL2_VW

(SQL View)

IB View of the WSDL repository

Shows the list of WSDLs in the repository but ignoring the multiple records that could be found there.

SELECT A.IB_SERVICENAME , A.IB_WSDLNAME , A.IB_WSDL_DEFAULT , A.LASTUPDDTTM FROM PSIBWSDLDFN A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).

2 IB_WSDLNAME Character(70) VARCHAR2(70) NOT NULL WSDL Name (see PSIBWSDLDFN).

3 IB_WSDL_DEFAULT Number(1,0) SMALLINT NOT NULL WSDL Default Indicator

4 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IB_SERVICENAME	Character(30)	VARCHAR2(30) NOT NULL	Service (see PSSERVICE).
2	IB_WSDLNAME	Character(70)	VARCHAR2(70) NOT NULL	WSDL Name (see PSIBWSDLDFN).
3	IB_WSDL_DEFAULT	Number(1,0)	SMALLINT NOT NULL	WSDL Default Indicator
4	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.