PTPPB_FOOTER

(SQL Table)
 Index Back

Pagelet Wizard Footer

  • Related Language Record: PTPPB_FTR_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTPPB_FOOTER_ID Character(30) VARCHAR2(30) NOT NULL Footer ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    4 PTPPB_TEXT_TYPE Character(3) VARCHAR2(3) NOT NULL Text Type
    MSG=Message Catalog Entry
    TXT=Freeform Text/HTML
    5 HTMLAREA Long Character CLOB HTML Area
    6 MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
    7 MSGNUM Number(5,0) INTEGER NOT NULL Message Number
    8 PTPPB_CONTENT_SRC Character(3) VARCHAR2(3) NOT NULL Image Source
    EXT=External Source
    SYS=System Catalog
    9 PTPPB_IMGSRC Character(250) VARCHAR2(250) NOT NULL Image Source

    Prompt Table: %EDITTABLE3

    10 PTPPB_IMGALIGN Character(2) VARCHAR2(2) NOT NULL Alignment
    LT=Left
    RT=Right
    11 PTPPB_IMGHEIGHT Number(3,0) SMALLINT NOT NULL Height
    12 PTPPB_IMGWIDTH Number(3,0) SMALLINT NOT NULL Width
    13 PTPPB_IMGALT Character(100) VARCHAR2(100) NOT NULL Float Over Text
    14 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive

    Default Value: A

    15 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    16 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    17 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.
    18 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.