PT_IQ_VW

index back

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 NameField TypeColumn TypeDescription
PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
PORTAL_PRNTOBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Parent Object Name
PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
PORTAL_CNTPRV_NAMCharacter(30)VARCHAR2(30) NOT NULLContent Provider Name
PORTAL_PRODUCTCharacter(4)VARCHAR2(4) NOT NULLProduct for Foler or Content Reference
PORTAL_TEMPL_NAMECharacter(30)VARCHAR2(30) NOT NULLTemplate Name
PORTAL_CREF_URLTCharacter(4)VARCHAR2(4) NOT NULLURL 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_USGTCharacter(4)VARCHAR2(4) NOT NULLUsage Type
FRMT=Frame template
GRPT=Landing page
HPGC=Pagelet
HPGT=Homepage tab
HTMT=HTML template
IFRM=Inline frame template
LINK=Content Reference Link
TARG=Target
PORTAL_ISPUBLICNumber(1,0)SMALLINT NOT NULLIs Public
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PORTAL_SEQ_NUMNumber(4,0)SMALLINT NOT NULLSequence number
PORTAL_LABELCharacter(30)VARCHAR2(30) NOT NULLPortal Label
DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
PORTAL_URLTEXTLong CharacterCLOBPortal URL Logical Text
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19