PTPPB_GROUPLET

 index back

Grouplet Wizard Definition


  • Related language record: PTPPB_GPLT_LANG

  • Parent record of PTGPLT_PRMS_LAN PTGP_DS_SETTGS PTPPB_GPLT_PRMS

    • PeopleSoft Field Name Field Type Column Type Description
    PTPPB_GROUPLET_ID Character(30) VARCHAR2(30) NOT NULL Tile Name
    EVENT_NAME Character(30) VARCHAR2(30) NOT NULL Event Name
    GROUPLET_DISPLAYIN Character(3) VARCHAR2(3) NOT NULL Grouplet Display In
    0=Current Window
    1=New Window
    2=Modal
    3=Navigation Bar
    4=Reserved
    PTGPLT_GP_TARGET Character(4) VARCHAR2(4) NOT NULL Target
    0=Current Window
    1=New Window
    2=Modal Window
    GROUPLET_TYPE Number(2,0) SMALLINT NOT NULL Interactive
    1=With Style
    2=Without Style
    3=Interactive
    PTGPLT_PUBLISHED Character(1) VARCHAR2(1) NOT NULL Published

    Y/N Table Edit

    GROUPLET_RESIZEABL Character(1) VARCHAR2(1) NOT NULL Tile Resizeable

    Y/N Table Edit

    GROUPLET_AUTOSIZE Character(1) VARCHAR2(1) NOT NULL Tile Autosize

    Y/N Table Edit

    GROUPLET_TIMER Number(3,0) SMALLINT NOT NULL Refresh Timer (Seconds)
    PTGPLT_IMAGE Character(30) VARCHAR2(30) NOT NULL Image Name

    Prompt Table: PTBR_IMG_PVW

    PTGPLT_GP_HEIGHT Number(1,0) SMALLINT NOT NULL Tile Height

    Default: 1

    PTGPLT_GP_WIDTH Number(1,0) SMALLINT NOT NULL Tile Width

    Default: 1

    PORTAL_TILE_IN_HP Character(1) VARCHAR2(1) NOT NULL Homepage
    PORTAL_TILE_IN_DB Character(1) VARCHAR2(1) NOT NULL Dashboard
    PORTAL_TILE_IN_NB Character(1) VARCHAR2(1) NOT NULL NavBar
    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: PTGPLT_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

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

    Prompt Table: PT_GPLT_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

    GROUPLET_HS_DISABL Character(1) VARCHAR2(1) NOT NULL Disable Main Hotspot
    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
    MODAL_PARAMS Character(254) VARCHAR2(254) NOT NULL Modal Parameters
    GROUPLET_ALTHEIGHT Number(1,0) SMALLINT NOT NULL Alternate Height
    GROUPLET_ALTWIDTH Number(1,0) SMALLINT NOT NULL Alternate Width
    PTGPLT_TP_DESC Character(254) VARCHAR2(254) NOT NULL Long Description
    PTGPLT_TP_NAME Character(30) VARCHAR2(30) NOT NULL Target Page Name
    PTGPLT_TP_NAME_PG Character(30) VARCHAR2(30) NOT NULL Target Page Name
    PTGPLT_TP_NODE Character(30) VARCHAR2(30) NOT NULL Node Name
    PTGPLT_TP_OWNID Character(4) VARCHAR2(4) NOT NULL Owner ID
    MCD=Mobile Com Dir
    PPT=PeopleTools
    PPTD=PeopleTools Demo
    PTGPLT_TP_SEQNO Number(4,0) SMALLINT NOT NULL Sequence Number
    PTGPLT_TP_PARENT Character(30) VARCHAR2(30) NOT NULL Parent Folder
    PTGP_CREFLINK_NAME Character(30) VARCHAR2(30) NOT NULL CRef Link
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20