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 NameField TypeColumn TypeDescription
    PTPPB_PAGELET_IDCharacter(30)VARCHAR2(30) NOT NULLPagelet ID
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
    PTPPB_DATA_SOURCECharacter(254)VARCHAR2(254) NOT NULLData Source

    Prompt Table: %EDITTABLE

    PTPPB_DATATYPE_IDCharacter(30)VARCHAR2(30) NOT NULLData Type

    Prompt Table: PTPPB_DATATYPE

    PTPPB_DISPFRMT_IDCharacter(30)VARCHAR2(30) NOT NULLDisplay Format ID

    Prompt Table: PTPPB_DISP_FRMT

    PTPPB_HEADER_IDCharacter(30)VARCHAR2(30) NOT NULLHeader ID

    Prompt Table: PTPPB_HEADER

    PTPPB_FOOTER_IDCharacter(30)VARCHAR2(30) NOT NULLFooter ID

    Prompt Table: PTPPB_FOOTER

    PTPPB_PGLT_CATG_IDCharacter(30)VARCHAR2(30) NOT NULLCategory ID

    Prompt Table: PTPPB_PGLT_CATG

    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values

    Default: PTPP_OPTIONS.OBJECTOWNERID

    PTPPB_OPENTXTTYPECharacter(3)VARCHAR2(3) NOT NULLOpening Text Type
    MSG=Message Catalog Entry
    TXT=Freeform Text/HTML

    Default: TXT

    PTPPB_OPENTXTCharacter(254)VARCHAR2(254) NOT NULLOpening Text
    PTPPB_OPENMSGSETNumber(5,0)INTEGER NOT NULLOpening Message Set
    PTPPB_OPENMSGNBRNumber(5,0)INTEGER NOT NULLOpening Message Number
    PTPPB_CLOSETXTTYPECharacter(3)VARCHAR2(3) NOT NULLClosing Text Type
    MSG=Message Catalog Entry
    TXT=Freeform Text/HTML

    Default: TXT

    PTPPB_CLOSETXTCharacter(254)VARCHAR2(254) NOT NULLClosing Text
    PTPPB_CLOSEMSGSETNumber(5,0)INTEGER NOT NULLClosing Message Set
    PTPPB_CLOSEMSGNBRNumber(5,0)INTEGER NOT NULLClosing Message Number
    PTPPB_VIEW_SOURCECharacter(1)VARCHAR2(1) NOT NULLShow "View Source Data" Link

    Y/N Table Edit

    Default: N

    PTPPB_CUSTOM_FLAGCharacter(1)VARCHAR2(1) NOT NULLCustomized

    Y/N Table Edit

    Default: N

    PTPPB_ORIG_DISP_IDCharacter(30)VARCHAR2(30) NOT NULLOriginal Display Format
    STYLESHEETNAMECharacter(30)VARCHAR2(30) NOT NULLStyle Sheet Name (see PSSTYLSHEETDEFN).
    PTPPB_EMBEDDABLECharacter(1)VARCHAR2(1) NOT NULLAPI Accessible

    Y/N Table Edit

    Default: N

    PTPPB_PERSTXTCharacter(254)VARCHAR2(254) NOT NULLText
    PTPPB_REQ_PERSCharacter(1)VARCHAR2(1) NOT NULLRequires Personalization

    Y/N Table Edit

    Default: N

    PTPPB_KEY_BEHAVCharacter(3)VARCHAR2(3) NOT NULLTemplate Pagelet Behavior
    DEF=Use Specified Defaults
    HID=Hide Pagelet
    MSG=Display Message

    Default: DEF

    PTPPB_SEC_TYPECharacter(4)VARCHAR2(4) NOT NULLSecurity Type
    PUBL=Public Access
    SECR=Select Security Access
    SYNC=Allow Data Source Sync

    Default: PUBL

    PTPPB_AUTH_ACCESSCharacter(1)VARCHAR2(1) NOT NULLAuthor Access

    Y/N Table Edit

    Default: N

    CREATEDTTMDateTime(26)TIMESTAMPDateTime of Query Creation
    CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    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.
    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.
    PTPPB_SRCH_OPTIONCharacter(3)VARCHAR2(3) NOT NULLSearch Options
    BL=Bottom Left
    BR=Bottom Right
    NON=No Search Box
    TL=Top Left
    TR=Top Right
    XSL=Inline XSL

    Default: NON

    PTPPB_SRCH_NEWWINCharacter(1)VARCHAR2(1) NOT NULLDisplay results in new window

    Y/N Table Edit

    Default: N

    PTPPB_SRCH_AP_PKGCharacter(30)VARCHAR2(30) NOT NULLPackage Name
    PTPPB_SRCH_AP_PATHCharacter(127)VARCHAR2(127) NOT NULLQualified Package/Class Path
    PTPPB_SRCH_APCLASSCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID
    PTPPB_HELP_URLLong CharacterCLOBPagelet Help URL
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19