PTPPB_PAGELET

index back

Pagelet Wizard Definition


  • Related language record: PTPPB_PGLT_LANG
  • Parent record of PTPPB_DS_SETTGS PTPPB_PGLT_PRMS PTPPB_PRMS_LANG PTPPB_SOAP_REQ
  • PeopleSoft Field Name Field Type Column Type Description
    PTPPB_PAGELET_ID Character(30) VARCHAR2(30) NOT NULL Pagelet ID
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    PTPPB_DATA_SOURCE Character(254) VARCHAR2(254) NOT NULL Data Source

    Prompt Table: %EDITTABLE

    PTPPB_DATATYPE_ID Character(30) VARCHAR2(30) NOT NULL Data Type

    Prompt Table: PTPPB_DATATYPE

    PTPPB_DISPFRMT_ID Character(30) VARCHAR2(30) NOT NULL Display Format ID

    Prompt Table: PTPPB_DISP_FRMT

    PTPPB_HEADER_ID Character(30) VARCHAR2(30) NOT NULL Header ID

    Prompt Table: PTPPB_HEADER

    PTPPB_FOOTER_ID Character(30) VARCHAR2(30) NOT NULL Footer ID

    Prompt Table: PTPPB_FOOTER

    PTPPB_PGLT_CATG_ID Character(30) VARCHAR2(30) NOT NULL Category ID

    Prompt Table: PTPPB_PGLT_CATG

    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values

    Default: PTPP_OPTIONS.OBJECTOWNERID

    PTPPB_OPENTXTTYPE Character(3) VARCHAR2(3) NOT NULL Opening Text Type
    MSG=Message Catalog Entry
    TXT=Freeform Text/HTML

    Default: TXT

    PTPPB_OPENTXT Character(254) VARCHAR2(254) NOT NULL Opening Text
    PTPPB_OPENMSGSET Number(5,0) INTEGER NOT NULL Opening Message Set
    PTPPB_OPENMSGNBR Number(5,0) INTEGER NOT NULL Opening Message Number
    PTPPB_CLOSETXTTYPE Character(3) VARCHAR2(3) NOT NULL Closing Text Type
    MSG=Message Catalog Entry
    TXT=Freeform Text/HTML

    Default: TXT

    PTPPB_CLOSETXT Character(254) VARCHAR2(254) NOT NULL Closing Text
    PTPPB_CLOSEMSGSET Number(5,0) INTEGER NOT NULL Closing Message Set
    PTPPB_CLOSEMSGNBR Number(5,0) INTEGER NOT NULL Closing Message Number
    PTPPB_VIEW_SOURCE Character(1) VARCHAR2(1) NOT NULL Show "View Source Data" Link

    Y/N Table Edit

    Default: N

    PTPPB_CUSTOM_FLAG Character(1) VARCHAR2(1) NOT NULL Customized

    Y/N Table Edit

    Default: N

    PTPPB_ORIG_DISP_ID Character(30) VARCHAR2(30) NOT NULL Original Display Format
    STYLESHEETNAME Character(30) VARCHAR2(30) NOT NULL Style Sheet Name (see PSSTYLSHEETDEFN).
    PTPPB_EMBEDDABLE Character(1) VARCHAR2(1) NOT NULL API Accessible

    Y/N Table Edit

    Default: N

    PTPPB_PERSTXT Character(254) VARCHAR2(254) NOT NULL Text
    PTPPB_REQ_PERS Character(1) VARCHAR2(1) NOT NULL Requires Personalization

    Y/N Table Edit

    Default: N

    PTPPB_KEY_BEHAV Character(3) VARCHAR2(3) NOT NULL Template Pagelet Behavior
    DEF=Use Specified Defaults
    HID=Hide Pagelet
    MSG=Display Message

    Default: DEF

    PTPPB_SEC_TYPE Character(4) VARCHAR2(4) NOT NULL Security Type
    PUBL=Public Access
    SECR=Select Security Access
    SYNC=Allow Data Source Sync

    Default: PUBL

    PTPPB_AUTH_ACCESS Character(1) VARCHAR2(1) NOT NULL Author Access

    Y/N Table Edit

    Default: N

    CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    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.
    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.
    PTPPB_SRCH_OPTION Character(3) VARCHAR2(3) NOT NULL Search Options
    BL=Bottom Left
    BR=Bottom Right
    NON=No Search Box
    TL=Top Left
    TR=Top Right
    XSL=Inline XSL

    Default: NON

    PTPPB_SRCH_NEWWIN Character(1) VARCHAR2(1) NOT NULL Display results in new window

    Y/N Table Edit

    Default: N

    PTPPB_SRCH_AP_PKG Character(30) VARCHAR2(30) NOT NULL Package Name
    PTPPB_SRCH_AP_PATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
    PTPPB_SRCH_APCLASS Character(30) VARCHAR2(30) NOT NULL Application Class ID
    PTPPB_HELP_URL Long Character CLOB Pagelet Help URL
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19