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 Name Field Type Column Type Description
    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    PORTAL_PRNTOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Parent Object Name
    PORTAL_SEQ_NUM Number(4,0) SMALLINT NOT NULL Sequence number
    PORTAL_PRODUCT Character(4) VARCHAR2(4) NOT NULL Product for Foler or Content Reference
    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=Landing page
    HPGC=Pagelet
    HPGT=Homepage tab
    HTMT=HTML template
    IFRM=Inline frame template
    LINK=Content Reference Link
    TARG=Target

    Default: TARG

    PORTAL_CREF_URLT Character(4) VARCHAR2(4) NOT NULL URL 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

    DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    PORTAL_TEMPL_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
    PORTAL_ISPUBLIC Number(1,0) SMALLINT NOT NULL Is Public

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

    PORTAL_URLTEXT Long Character CLOB Portal URL Logical Text
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19