PT_IQREGITEM

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
    1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    3 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    4 PORTAL_PRNTOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Parent Object Name
    5 PORTAL_SEQ_NUM Number(4,0) SMALLINT NOT NULL Sequence number
    6 PORTAL_PRODUCT Character(4) VARCHAR2(4) NOT NULL Product for Foler or Content Reference
    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_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

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

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

    14 PORTAL_URLTEXT Long Character CLOB Portal URL Logical Text