PSPRDMDEFN

index back

Portal Definition Table

Portal Registry Definition Table

  • Related language record: PSPRDMDEFNLANG
  • Parent record of PSPRDMDEFNLANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    PORTAL_TEMPL_NAMECharacter(30)VARCHAR2(30) NOT NULLTemplate Name
    PORTAL_REMOTECharacter(1)VARCHAR2(1) NOT NULLPortal Remote Flag
    PORTAL_HOSTNODENAMCharacter(30)VARCHAR2(30) NOT NULLPortal Host Node Name
    PORTAL_ISFOLDERNAVNumber(1,0)SMALLINT NOT NULLIs Folder Navigation Enabled

    Default: 0

    PORTAL_FLDR_NAVOBJCharacter(30)VARCHAR2(30) NOT NULLFolder Navigation Object Name
    PT_ABN_CHARTNAVOBJCharacter(30)VARCHAR2(30) NOT NULLChart Navigation Object Name
    PORTAL_TYPECharacter(20)VARCHAR2(20) NOT NULLPortal Type
    LOC=Local
    REM=Remote
    PORTAL_EFFDTDate(10)DATEPortal Effective Date
    PORTAL_EXPIRE_DTDate(10)DATEExpiration date of folder or content reference
    STATUSCharacter(1)VARCHAR2(1) NOT NULLStatus Indicator
    A=Active
    I=Inactive
    PORTAL_ADMROLECharacter(30)VARCHAR2(30) NOT NULLAdded in 8.46 as part of Collaborated Workspaces project.
    PORTAL_ISHPMODFYLKNumber(1,0)SMALLINT NOT NULLWhether to display Modify Content/Layout liknks on Portal HomePage . Added in 8.46 as part of Collaborated Workspaces project.

    Default: 0

    PORTAL_LABELCharacter(30)VARCHAR2(30) NOT NULLPortal Label
    PORTAL_CATEGORYCharacter(30)VARCHAR2(30) NOT NULLPortal Name
    PORTAL_CREATEDFROMCharacter(30)VARCHAR2(30) NOT NULLPortal Name
    CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    CREATEDTTMDateTime(26)TIMESTAMPDateTime of Query Creation
    DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
    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_WELCOMETEXTLong CharacterCLOBPortal Welcome Text
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19