PTPPB_GROUPLET

(SQL Table)
 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 PeopleSoft Field Type Database Column Type Description
    1 PTPPB_GROUPLET_ID Character(30) VARCHAR2(30) NOT NULL Tile Name
    2 EVENT_NAME Character(30) VARCHAR2(30) NOT NULL Event Name
    3 GROUPLET_DISPLAYIN Character(3) VARCHAR2(3) NOT NULL Grouplet Display In
    0=Current Window
    1=New Window
    2=Modal
    3=Navigation Bar
    4=Reserved
    4 PTGPLT_GP_TARGET Character(4) VARCHAR2(4) NOT NULL Target
    0=Current Window
    1=New Window
    2=Modal Window
    5 GROUPLET_TYPE Number(2,0) SMALLINT NOT NULL Interactive
    1=With Style
    2=Without Style
    3=Interactive
    6 PTGPLT_PUBLISHED Character(1) VARCHAR2(1) NOT NULL Published

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Prompt Table: PTBR_IMG_PVW

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

    Default Value: 1

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

    Default Value: 1

    13 PORTAL_TILE_IN_HP Character(1) VARCHAR2(1) NOT NULL Homepage
    14 PORTAL_TILE_IN_DB Character(1) VARCHAR2(1) NOT NULL Dashboard
    15 PORTAL_TILE_IN_NB Character(1) VARCHAR2(1) NOT NULL NavBar
    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    18 PTPPB_DATA_SOURCE Character(254) VARCHAR2(254) NOT NULL Data Source

    Prompt Table: %EDITTABLE

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

    Prompt Table: PTGPLT_DATATYPE

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

    Prompt Table: PTPPB_DISP_FRMT

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

    Prompt Table: PTPPB_HEADER

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

    Prompt Table: PTPPB_FOOTER

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

    Prompt Table: PT_GPLT_CATG

    24 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

    Default Value: PTPP_OPTIONS.OBJECTOWNERID

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

    Default Value: TXT

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

    Default Value: TXT

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    35 GROUPLET_HS_DISABL Character(1) VARCHAR2(1) NOT NULL Disable Main Hotspot
    36 PTPPB_ORIG_DISP_ID Character(30) VARCHAR2(30) NOT NULL Original Display Format
    37 STYLESHEETNAME Character(30) VARCHAR2(30) NOT NULL Style Sheet Name (see PSSTYLSHEETDEFN).
    38 PTPPB_EMBEDDABLE Character(1) VARCHAR2(1) NOT NULL API Accessible

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: DEF

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

    Default Value: PUBL

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

    Y/N Table Edit

    Default Value: N

    44 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    45 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    46 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.
    47 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.
    48 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 Value: NON

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

    Y/N Table Edit

    Default Value: N

    50 PTPPB_SRCH_AP_PKG Character(30) VARCHAR2(30) NOT NULL Package Name
    51 PTPPB_SRCH_AP_PATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
    52 PTPPB_SRCH_APCLASS Character(30) VARCHAR2(30) NOT NULL Application Class ID
    53 PTPPB_HELP_URL Long Character CLOB Pagelet Help URL
    54 MODAL_PARAMS Character(254) VARCHAR2(254) NOT NULL Modal Parameters
    55 GROUPLET_ALTHEIGHT Number(1,0) SMALLINT NOT NULL Alternate Height
    56 GROUPLET_ALTWIDTH Number(1,0) SMALLINT NOT NULL Alternate Width
    57 PTGPLT_TP_DESC Character(254) VARCHAR2(254) NOT NULL Long Description
    58 PTGPLT_TP_NAME Character(30) VARCHAR2(30) NOT NULL Target Page Name
    59 PTGPLT_TP_NAME_PG Character(30) VARCHAR2(30) NOT NULL Target Page Name
    60 PTGPLT_TP_NODE Character(30) VARCHAR2(30) NOT NULL Node Name
    61 PTGPLT_TP_OWNID Character(4) VARCHAR2(4) NOT NULL Owner ID
    MCD=Mobile Com Dir
    PPT=PeopleTools
    PPTD=PeopleTools Demo
    62 PTGPLT_TP_SEQNO Number(4,0) SMALLINT NOT NULL Sequence Number
    63 PTGPLT_TP_PARENT Character(30) VARCHAR2(30) NOT NULL Parent Folder
    64 PTGP_CREFLINK_NAME Character(30) VARCHAR2(30) NOT NULL CRef Link