PTSF_URL_DEF_VW

(SQL View)
 Index Back

URL View of PTSF attachments


SELECT a.url_id ,b.descr ,b.url FROM PS_PTSF_URLDEFN a , psurldefn b WHERE a.url_id=b.url_id

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

Default Value: http://