PT_IQ_VWLNG

index back

SELECT D.PORTAL_NAME , D.PORTAL_PRNTOBJNAME , D.PORTAL_OBJNAME , E.LANGUAGE_CD , D.PORTAL_CNTPRV_NAM , D.PORTAL_PRODUCT , D.PORTAL_TEMPL_NAME , D.PORTAL_CREF_URLT , D.PORTAL_CREF_USGT , D.PORTAL_ISPUBLIC , D.OPRID , D.PORTAL_SEQ_NUM , E.PORTAL_LABEL , E.DESCR254 , D.PORTAL_URLTEXT FROM PSPRSMDEFN D , PSPRSMDEFNLANG E WHERE D.PORTAL_REFTYPE = 'C' AND E.PORTAL_NAME = D.PORTAL_NAME AND E.PORTAL_OBJNAME = D.PORTAL_OBJNAME

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
LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
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