PT_IQREGITEM

index back

Registry Content View

Portal Registry Content Reference View
SELECT PORTAL_NAME , PORTAL_OBJNAME , PORTAL_LABEL , PORTAL_PRNTOBJNAME , PORTAL_SEQ_NUM , PORTAL_PRODUCT , PORTAL_CNTPRV_NAM , PORTAL_CREF_USGT , PORTAL_CREF_URLT , DESCR254 , OPRID , PORTAL_TEMPL_NAME , PORTAL_ISPUBLIC , %textIn(PORTAL_URLTEXT) FROM PSPRSMDEFN WHERE PORTAL_REFTYPE = 'C' AND PORTAL_CREF_URLT NOT IN ('UPHP' ,'UPTM') AND PORTAL_PRNTOBJNAME NOT IN ('PORTAL_USERS' ,'PORTAL_TEMPLATES')

  • Related language record: PT_IQRGVWLNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
    PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    PORTAL_LABELCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    PORTAL_PRNTOBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Parent Object Name
    PORTAL_SEQ_NUMNumber(4,0)SMALLINT NOT NULLSequence number
    PORTAL_PRODUCTCharacter(4)VARCHAR2(4) NOT NULLProduct for Foler or Content Reference
    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_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
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    PORTAL_TEMPL_NAMECharacter(30)VARCHAR2(30) NOT NULLTemplate Name
    PORTAL_ISPUBLICNumber(1,0)SMALLINT NOT NULLIs Public

    1/0 Table Edit (1=True, 0=False)

    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