RB_FIDX_URL_VW

(SQL View)
 Index Back

URL for Search File Index

URL associated with a File Index collection that resides on an FTP server.

SELECT A.SEARCH_DEFN_NAME , A.URL_ID , B.URL FROM PS_RB_VRTY_PG_FIDX A , PSURLDEFN B WHERE A.URL_ID = B.URL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEARCH_DEFN_NAME Character(30) VARCHAR2(30) NOT NULL Search Definition Name
2 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).
3 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)