PSPRSM_SRCH_VW

index back

Portal Registry Search 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_ISPUBLIC WHEN 0 THEN '0' WHEN 1 THEN '1:' %Concat A.OPRID WHEN 2 THEN '2' END , CASE WHEN B.NODE_TYPE='ICT' OR B.NODE_TYPE='EX' OR A.PORTAL_CREF_URLT='UEXT' THEN 'e/?url=' ELSE '' END , CASE WHEN A.PORTAL_EXPIRE_DT IS NULL THEN 'N' ELSE 'Y' END , A.NODE_ITEMNAME , B.URI_TEXT , CASE WHEN A.PORTAL_CREF_URLT='UEXT' AND B.LOCALDEFAULTFLG = 'Y' THEN A.PORTAL_NAME %Concat '/' %Concat A.NODE_ITEMNAME %Concat '/' ELSE '' END , A.URI_TEXT FROM (%Table(PSPRSM_TARG_VW) A LEFT OUTER JOIN %Table(PSNODEINFO_VW) B ON A.NODE_ITEMNAME = B.MSGNODENAME AND A.PORTAL_CNTPRV_NAM <> ' ' AND (A.PORTAL_CREF_URLT='UEXT' OR B.NODE_TYPE='ICT' OR B.NODE_TYPE='EX'))

  • Related language record: PSPRSRCHLANGVW
  • 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
    PORTAL_SECTYPECharacter(40)VARCHAR2(40) NOT NULLPortal Registry Security Holder: Public, Author Access or Permission List
    PORTAL_URLEXTCharacter(10)VARCHAR2(10) NOT NULLPT URL External Param
    PORTAL_EXPIRESCharacter(1)VARCHAR2(1) NOT NULLValues 'Y' or 'N'
    NODE_ITEMNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Item Name for Tree Nodes
    PT_URLTEXTLong CharacterCLOBEdit URL/URL
    PORTAL_NODENAMECharacter(65)VARCHAR2(65) NOT NULLPortal/Node
    PORTAL_BASE_URILong CharacterCLOBBase URI
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19