PT_IQ_VW

Platform	View Text
Default	SELECT A.PORTAL_NAME , A.PORTAL_PRNTOBJNAME , A.PORTAL_OBJNAME , A.PORTAL_CNTPRV_NAM , A.PORTAL_PRODUCT , A.PORTAL_TEMPL_NAME , A.PORTAL_CREF_URLT , A.PORTAL_CREF_USGT , A.PORTAL_ISPUBLIC , A.OPRID , A.PORTAL_SEQ_NUM , A.PORTAL_LABEL , A.DESCR254 , A.PORTAL_URLTEXT FROM PSPRSMDEFN A WHERE A.PORTAL_REFTYPE = 'C'

PeopleSoft Field Name	Description
PORTAL_NAME	Portal Name
PORTAL_PRNTOBJNAME	Portal Parent Object Name
PORTAL_OBJNAME	Portal Object Name
PORTAL_CNTPRV_NAM	Content Provider Name
PORTAL_PRODUCT	Product for Foler or Content Reference
PORTAL_TEMPL_NAME	Template Name
PORTAL_CREF_URLT	URL Type UEXT=Non-PeopleSoft URL UGEN=PeopleSoft Generic URL UMPG=PeopleSoft Mobile Page UPGE=PeopleSoft Component UPHP=PeopleSoft Portal Homepage Tab UPTM=PeopleSoft Portal Template USCR=PeopleSoft Script WRKL=PeopleSoft Worklist URL
PORTAL_CREF_USGT	Usage Type FRMT=Frame template HPGC=Pagelet HPGT=Homepage tab HTMT=HTML template LINK=Content Reference Link TARG=Target
PORTAL_ISPUBLIC	Is Public
OPRID	A user's ID
PORTAL_SEQ_NUM	Sequence number
PORTAL_LABEL	Portal Label
DESCR254	Description of length 254
PORTAL_URLTEXT	Portal URL Logical Text

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010