PSPRSMDEFN

Return to Index

Portal Registry Structure Definition Table

  • Related language record: PSPRSMDEFNLANG
  • Parent record of PSPRSMDEFNLANG PSPRSMDEFN_LVW PSPRSMSYNC PTAL_PAGE
  • PeopleSoft Field NameField TypeDescription
    PORTAL_NAMEVARCHAR2(30) NOT NULLPortal Name
    PORTAL_REFTYPEVARCHAR2(1) NOT NULLPortal Reference Type
    C=Content
    F=Folder
    PORTAL_OBJNAMEVARCHAR2(30) NOT NULLPortal Object Name
    VERSIONDECIMAL(10) NOT NULLVersion
    PORTAL_URL_CHKSUMDECIMAL(10) NOT NULLURL CheckSum
    PORTAL_PRNTOBJNAMEVARCHAR2(30) NOT NULLPortal Parent Object Name
    PORTAL_SEQ_NUMSMALLINT NOT NULLSequence number
    PORTAL_LABELVARCHAR2(30) NOT NULLPortal Label
    PORTAL_CNTPRV_NAMVARCHAR2(30) NOT NULLContent Provider Name
    PORTAL_CREF_USGTVARCHAR2(4) NOT NULLUsage Type
    FRMT=Frame template
    HPGC=Pagelet
    HPGT=Homepage tab
    HTMT=HTML template
    IFRM=Inline frame template
    LINK=Content Reference Link
    TARG=Target

    Default: TARG

    PORTAL_CREF_TMPTVARCHAR2(4) NOT NULLContent Ref Template Type
    FRAM=Frame template
    HTML=HTML template
    NONE=No template

    Default: HTML

    PORTAL_CREF_STGTVARCHAR2(4) NOT NULLStorage Type
    LOCL=Local (in HTML Catalog)
    RMTE=Remote by URL

    Default: RMTE

    PORTAL_CREF_URLTVARCHAR2(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

    DESCR254VARCHAR2(254) NOT NULLDescription of length 254
    PORTAL_PRODUCTVARCHAR2(4) NOT NULLProduct for Foler or Content Reference
    OPRIDVARCHAR2(30) NOT NULLA user's ID
    PORTAL_EFFDTDATEPortal Effective Date
    PORTAL_CREATION_DTDATECreation date of folder or content reference
    PORTAL_EXPIRE_DTDATEExpiration date of folder or content reference
    PORTAL_TEMPL_NAMEVARCHAR2(30) NOT NULLTemplate Name
    PORTAL_STG_NAMEVARCHAR2(30) NOT NULLPortal Registry Storage Name
    PORTAL_ISPUBLICSMALLINT NOT NULLIs Public
    PORTAL_LINKOBJNAMEVARCHAR2(30) NOT NULLPortal Linked Object Name
    PORTAL_LINK_PORTALVARCHAR2(30) NOT NULLLinked Portal Name
    LASTUPDOPRIDVARCHAR2(30) NOT NULLSpecifies 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.
    LASTUPDDTTMDATESpecifies 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.
    OBJECTOWNERIDVARCHAR2(4) NOT NULLObject owner identifier translate values
    PORTAL_URI_SEG1VARCHAR2(30) NOT NULLURI Segment 1
    PORTAL_URI_SEG2VARCHAR2(30) NOT NULLURI Segment 2
    PORTAL_URI_SEG3VARCHAR2(30) NOT NULLURI Segment 3
    PORTAL_URI_SEG4VARCHAR2(30) NOT NULLURI Segment 4
    PORTAL_URLTEXTLONG VARCHARPortal URL Logical Text

    Author: PeopleTools 8.52

    Return to Index

    © David Kurtz  Last updated 01 August 2015