WL_TEMPLATE

index back

Component Templates

Stores component templates for notifications.

  • Related language record: WL_TEMPLATE_LNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
    MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
    WL_TEMPLATE_IDCharacter(30)VARCHAR2(30) NOT NULLTemplate Name
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    WL_PRIORITYCharacter(1)VARCHAR2(1) NOT NULLWorklist Priority
    1=1-High
    2=2-Medium
    3=3-Low
    WL_DEFAULT_TEMPLCharacter(1)VARCHAR2(1) NOT NULLDefault template indicator. When 'Y' it indicates that the template is to be used as the default.
    N=No
    Y=Yes

    Default: N

    WL_SENDERCharacter(1)VARCHAR2(1) NOT NULLNotification Sender
    1=User
    2=System
    3=Other
    4=System-Blackberry

    Default: 1

    EMAILIDCharacter(70)VARCHAR2(70) NOT NULLA user's E-mail address
    WL_SUBJECTCharacter(254)VARCHAR2(254) NOT NULLSubject
    WL_INSTR_TXTCharacter(254)VARCHAR2(254) NOT NULLInstructional Text
    WL_RESPONSE_TXTCharacter(254)VARCHAR2(254) NOT NULLResponse Text
    WL_ADDED_OPRIDCharacter(30)VARCHAR2(30) NOT NULLAdded By
    WL_ADDED_DTTMDateTime(26)TIMESTAMPDate/Time Created
    WL_LASTMANT_OPRIDCharacter(30)VARCHAR2(30) NOT NULLLast Maintained By
    WL_LASTMANT_DTTMDateTime(26)TIMESTAMPDate Modified
    WL_MSG_TXTLong CharacterCLOBMessage Text
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19