PSPRDMDEFN

index back

Portal Definition Table

Portal Registry Definition Table

  • Related language record: PSPRDMDEFNLANG
  • Parent record of PSPRDMDEFNLANG
  • PeopleSoft Field Name Field Type Column Type Description
    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    PORTAL_TEMPL_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
    PORTAL_REMOTE Character(1) VARCHAR2(1) NOT NULL Portal Remote Flag
    PORTAL_HOSTNODENAM Character(30) VARCHAR2(30) NOT NULL Portal Host Node Name
    PORTAL_ISFOLDERNAV Number(1,0) SMALLINT NOT NULL Is Folder Navigation Enabled

    Default: 0

    PORTAL_FLDR_NAVOBJ Character(30) VARCHAR2(30) NOT NULL Folder Navigation Object Name
    PT_ABN_CHARTNAVOBJ Character(30) VARCHAR2(30) NOT NULL Chart Navigation Object Name
    PORTAL_TYPE Character(20) VARCHAR2(20) NOT NULL Portal Type
    LOC=Local
    REM=Remote
    PORTAL_EFFDT Date(10) DATE Portal Effective Date
    PORTAL_EXPIRE_DT Date(10) DATE Expiration date of folder or content reference
    STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    PORTAL_ADMROLE Character(30) VARCHAR2(30) NOT NULL Added in 8.46 as part of Collaborated Workspaces project.
    PORTAL_ISHPMODFYLK Number(1,0) SMALLINT NOT NULL Whether to display Modify Content/Layout liknks on Portal HomePage . Added in 8.46 as part of Collaborated Workspaces project.

    Default: 0

    PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    PORTAL_CATEGORY Character(30) VARCHAR2(30) NOT NULL Portal Name
    PORTAL_CREATEDFROM Character(30) VARCHAR2(30) NOT NULL Portal Name
    CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    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_WELCOMETEXT Long Character CLOB Portal Welcome Text
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19