PSPRSM_SRCH_VW

(SQL View)
 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_LINKOBJNAME , 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 , A.PT_COMPONENT 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 Name PeopleSoft Field Type Database Column Type Description
    1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    2 PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
    C=Content
    F=Folder
    3 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    4 PORTAL_PRNTOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Parent Object Name
    5 PORTAL_LINKOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Linked Object Name
    6 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    7 PORTAL_CNTPRV_NAM Character(30) VARCHAR2(30) NOT NULL Content Provider Name
    8 PORTAL_CREF_USGT Character(4) VARCHAR2(4) NOT NULL Usage Type
    FRMT=Frame template
    GRPT=Fluid Homepage
    HPGC=Pagelet
    HPGT=Homepage tab
    HTMT=HTML template
    IFRM=Inline frame template
    LINK=Content Reference Link
    SECT=Section template
    TARG=Target

    Default Value: TARG

    9 PORTAL_CREF_TMPT Character(4) VARCHAR2(4) NOT NULL Content Ref Template Type
    FRAM=Frame template
    HTML=HTML template
    NONE=No template

    Default Value: HTML

    10 PORTAL_CREF_STGT Character(4) VARCHAR2(4) NOT NULL Storage Type
    LOCL=Local (in HTML Catalog)
    RMTE=Remote by URL

    Default Value: RMTE

    11 PORTAL_CREF_URLT Character(4) VARCHAR2(4) NOT NULL URL Type
    NONE=None
    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 Value: UPGE

    12 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    13 PORTAL_PRODUCT Character(4) VARCHAR2(4) NOT NULL Product for Foler or Content Reference
    14 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    15 PORTAL_EFFDT Date(10) DATE Portal Effective Date
    16 PORTAL_CREATION_DT Date(10) DATE Creation date of folder or content reference
    17 PORTAL_EXPIRE_DT Date(10) DATE Expiration date of folder or content reference
    18 PORTAL_ISPUBLIC Number(1,0) SMALLINT NOT NULL Is Public
    19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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.
    20 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
    21 PORTAL_URI_SEG1 Character(30) VARCHAR2(30) NOT NULL URI Segment 1
    22 PORTAL_URI_SEG2 Character(30) VARCHAR2(30) NOT NULL URI Segment 2
    23 PORTAL_URI_SEG3 Character(30) VARCHAR2(30) NOT NULL URI Segment 3
    24 PORTAL_URI_SEG4 Character(30) VARCHAR2(30) NOT NULL URI Segment 4
    25 PORTAL_URLTEXT Long Character CLOB Portal URL Logical Text
    26 PORTAL_SECTYPE Character(40) VARCHAR2(40) NOT NULL Portal Registry Security Holder: Public, Author Access or Permission List
    27 PORTAL_URLEXT Character(10) VARCHAR2(10) NOT NULL PT URL External Param
    28 PORTAL_EXPIRES Character(1) VARCHAR2(1) NOT NULL Values 'Y' or 'N'
    29 NODE_ITEMNAME Character(30) VARCHAR2(30) NOT NULL Menu Item Name for Tree Nodes
    30 PT_URLTEXT Long Character CLOB Edit URL/URL
    31 PORTAL_NODENAME Character(65) VARCHAR2(65) NOT NULL Portal/Node
    32 PORTAL_BASE_URI Long Character CLOB Base URI
    33 PT_COMPONENT Character(1) VARCHAR2(1) NOT NULL Cref Component type