PSPRSMDEFN_VW

 index back

Portal Structure Defn Tbl

Portal Registry Structure Definition Table
SELECT PORTAL_NAME , PORTAL_REFTYPE , PORTAL_OBJNAME , VERSION , PORTAL_URL_CHKSUM , PORTAL_PRNTOBJNAME , PORTAL_SEQ_NUM , PORTAL_LABEL , PORTAL_CNTPRV_NAM , PORTAL_CREF_USGT , PORTAL_CREF_TMPT , PORTAL_CREF_STGT , PORTAL_CREF_URLT , DESCR254 , PORTAL_PRODUCT , OPRID , PORTAL_EFFDT , PORTAL_CREATION_DT , PORTAL_EXPIRE_DT , PORTAL_TEMPL_NAME , PORTAL_STG_NAME , PORTAL_ISPUBLIC , PORTAL_LINKOBJNAME , PORTAL_LINK_PORTAL , LASTUPDOPRID , LASTUPDDTTM , OBJECTOWNERID , PORTAL_URI_SEG1 , PORTAL_URI_SEG2 , PORTAL_URI_SEG3 , PORTAL_URI_SEG4 , PORTAL_URLTEXT FROM PSPRSMDEFN WHERE PORTAL_NAME = 'MOBILE' AND PORTAL_REFTYPE = 'F'

  • Related language record: PSPRSMDEFN_LVW

    • PeopleSoft Field Name Field Type Column Type Description
    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

    Default: MOBILE

    PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
    C=Content
    F=Folder

    Default: F

    PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    PORTAL_URL_CHKSUM Number(10,0) DECIMAL(10) NOT NULL URL CheckSum

    Default: 0

    PORTAL_PRNTOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Parent Object Name

    Default: MOBILE

    PORTAL_SEQ_NUM Number(4,0) SMALLINT NOT NULL Sequence number
    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

    Default: %date

    PORTAL_EXPIRE_DT Date(10) DATE Expiration date of folder or content reference
    PORTAL_TEMPL_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
    PORTAL_STG_NAME Character(30) VARCHAR2(30) NOT NULL Portal Registry Storage Name
    PORTAL_ISPUBLIC Number(1,0) SMALLINT NOT NULL Is Public
    PORTAL_LINKOBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Linked Object Name
    PORTAL_LINK_PORTAL Character(30) VARCHAR2(30) NOT NULL Linked Portal Name
    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.
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    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
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20