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_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_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 (NOT EXISTS( SELECT C.PORTAL_OBJNAME FROM %Table(PSPRSMSYSATTRVL) C WHERE A.PORTAL_NAME=C.PORTAL_NAME AND (A.PORTAL_OBJNAME=C.PORTAL_OBJNAME OR A.PORTAL_PRNTOBJNAME='PT_TOOLS_HIDDEN') AND C.PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV')) AND (A.PORTAL_OBJNAME NOT IN ( SELECT D.PORTAL_OBJNAME FROM %Table(PSPRSMNUI) D WHERE A.PORTAL_NAME=D.PORTAL_NAME AND A.PORTAL_REFTYPE=D.PORTAL_REFTYPE AND A.PORTAL_OBJNAME=D.PORTAL_OBJNAME AND D.GROUPLET_DISPLAY=3))

PeopleSoft Field Name Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder
PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
PORTAL_PRNTOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Parent Object Name
PORTAL_LINKOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Linked Object Name
PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
PORTAL_CNTPRV_NAM Character(30) VARCHAR2(30) NOT NULL Content Provider Name
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
TARG=Target

Default: TARG

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

Default: HTML

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

Default: RMTE

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: UPGE

DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
PORTAL_PRODUCT Character(4) VARCHAR2(4) NOT NULL Product for Foler or Content Reference
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PORTAL_EFFDT Date(10) DATE Portal Effective Date
PORTAL_CREATION_DT Date(10) DATE Creation date of folder or content reference
PORTAL_EXPIRE_DT Date(10) DATE Expiration date of folder or content reference
PORTAL_ISPUBLIC Number(1,0) SMALLINT NOT NULL Is Public
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.
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.
PORTAL_URI_SEG1 Character(30) VARCHAR2(30) NOT NULL URI Segment 1
PORTAL_URI_SEG2 Character(30) VARCHAR2(30) NOT NULL URI Segment 2
PORTAL_URI_SEG3 Character(30) VARCHAR2(30) NOT NULL URI Segment 3
PORTAL_URI_SEG4 Character(30) VARCHAR2(30) NOT NULL URI Segment 4
PORTAL_URLTEXT Long Character CLOB Portal URL Logical Text
NODE_ITEMNAME Character(30) VARCHAR2(30) NOT NULL Menu Item Name for Tree Nodes
URI_TEXT Long Character CLOB URI Text
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20