PSPRSM_TARG_VW

index back

Portal Registry Target View

WHERE (A.PORTAL_CREF_USGT = 'TARG') AND (A.PORTAL_OBJNAME NOT IN ( SELECT B.PORTAL_OBJNAME FROM PSPRSMSYSATTRVL B WHERE B.PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV'))
SELECT A.PORTAL_NAME , A.PORTAL_REFTYPE , A.PORTAL_OBJNAME , A.PORTAL_PRNTOBJNAME , A.PORTAL_LABEL , A.PORTAL_CNTPRV_NAM , A.PORTAL_CREF_USGT , A.PORTAL_CREF_TMPT , A.PORTAL_CREF_STGT , A.PORTAL_CREF_URLT , A.DESCR254 , A.PORTAL_PRODUCT , A.OPRID , A.PORTAL_EFFDT , A.PORTAL_CREATION_DT , A.PORTAL_EXPIRE_DT , A.PORTAL_ISPUBLIC , A.LASTUPDOPRID , A.LASTUPDDTTM , A.PORTAL_URI_SEG1 , A.PORTAL_URI_SEG2 , A.PORTAL_URI_SEG3 , A.PORTAL_URI_SEG4 , A.PORTAL_URLTEXT , CASE A.PORTAL_CNTPRV_NAM WHEN 'LOCAL_NODE' THEN B.PORTAL_HOSTNODENAM WHEN ' ' THEN B.PORTAL_HOSTNODENAM ELSE A.PORTAL_CNTPRV_NAM END , B.URI_TEXT FROM %Table(PSPRSMDEFN) A ,%Table(PSPRDMNODES_VW) B WHERE (A.PORTAL_CREF_USGT = 'TARG') AND A.PORTAL_NAME=B.PORTAL_NAME AND (A.PORTAL_OBJNAME NOT IN ( SELECT C.PORTAL_OBJNAME FROM %Table(PSPRSMSYSATTRVL) C WHERE C.PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV'))

PeopleSoft Field NameField TypeColumn TypeDescription
PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
PORTAL_REFTYPECharacter(1)VARCHAR2(1) NOT NULLPortal Reference Type
C=Content
F=Folder
PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
PORTAL_PRNTOBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Parent Object Name
PORTAL_LABELCharacter(30)VARCHAR2(30) NOT NULLPortal Label
PORTAL_CNTPRV_NAMCharacter(30)VARCHAR2(30) NOT NULLContent Provider Name
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

Default: TARG

PORTAL_CREF_TMPTCharacter(4)VARCHAR2(4) NOT NULLContent Ref Template Type
FRAM=Frame template
HTML=HTML template
NONE=No template

Default: HTML

PORTAL_CREF_STGTCharacter(4)VARCHAR2(4) NOT NULLStorage Type
LOCL=Local (in HTML Catalog)
RMTE=Remote by URL

Default: RMTE

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

Default: UPGE

DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
PORTAL_PRODUCTCharacter(4)VARCHAR2(4) NOT NULLProduct for Foler or Content Reference
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
PORTAL_EFFDTDate(10)DATEPortal Effective Date
PORTAL_CREATION_DTDate(10)DATECreation date of folder or content reference
PORTAL_EXPIRE_DTDate(10)DATEExpiration date of folder or content reference
PORTAL_ISPUBLICNumber(1,0)SMALLINT NOT NULLIs Public
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
PORTAL_URI_SEG1Character(30)VARCHAR2(30) NOT NULLURI Segment 1
PORTAL_URI_SEG2Character(30)VARCHAR2(30) NOT NULLURI Segment 2
PORTAL_URI_SEG3Character(30)VARCHAR2(30) NOT NULLURI Segment 3
PORTAL_URI_SEG4Character(30)VARCHAR2(30) NOT NULLURI Segment 4
PORTAL_URLTEXTLong CharacterCLOBPortal URL Logical Text
NODE_ITEMNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Item Name for Tree Nodes
URI_TEXTLong CharacterCLOBURI Text
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19