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 NameField TypeColumn TypeDescription
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).

    Default: MOBILE

    PORTAL_REFTYPECharacter(1)VARCHAR2(1) NOT NULLPortal Reference Type
    C=Content
    F=Folder

    Default: F

    PORTAL_OBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Object Name
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    PORTAL_URL_CHKSUMNumber(10,0)DECIMAL(10) NOT NULLURL CheckSum

    Default: 0

    PORTAL_PRNTOBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Parent Object Name

    Default: MOBILE

    PORTAL_SEQ_NUMNumber(4,0)SMALLINT NOT NULLSequence number
    PORTAL_LABELCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    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_TMPTCharacter(4)VARCHAR2(4) NOT NULLContent Ref Template Type
    FRAM=Frame template
    HTML=HTML template
    NONE=No template

    Default: HTML

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

    Default: RMTE

    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
    PORTAL_PRODUCTCharacter(4)VARCHAR2(4) NOT NULLProduct for Foler or Content Reference
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    PORTAL_EFFDTDate(10)DATEPortal Effective Date
    PORTAL_CREATION_DTDate(10)DATECreation date of folder or content reference

    Default: %date

    PORTAL_EXPIRE_DTDate(10)DATEExpiration date of folder or content reference
    PORTAL_TEMPL_NAMECharacter(30)VARCHAR2(30) NOT NULLTemplate Name
    PORTAL_STG_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Registry Storage Name
    PORTAL_ISPUBLICNumber(1,0)SMALLINT NOT NULLIs Public
    PORTAL_LINKOBJNAMECharacter(30)VARCHAR2(30) NOT NULLPortal Linked Object Name
    PORTAL_LINK_PORTALCharacter(30)VARCHAR2(30) NOT NULLLinked Portal Name
    LASTUPDOPRIDCharacter(30)VARCHAR2(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.
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    PORTAL_URI_SEG1Character(30)VARCHAR2(30) NOT NULLURI Segment 1
    PORTAL_URI_SEG2Character(30)VARCHAR2(30) NOT NULLURI Segment 2
    PORTAL_URI_SEG3Character(30)VARCHAR2(30) NOT NULLURI Segment 3
    PORTAL_URI_SEG4Character(30)VARCHAR2(30) NOT NULLURI Segment 4
    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