WL_TEMPLATE

index back

Component Templates

Stores component templates for notifications.

  • Related language record: WL_TEMPLATE_LNG
  • PeopleSoft Field Name Field Type Column Type Description
    PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
    WL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template Name
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Worklist Priority
    1=1-High
    2=2-Medium
    3=3-Low
    WL_DEFAULT_TEMPL Character(1) VARCHAR2(1) NOT NULL Default template indicator. When 'Y' it indicates that the template is to be used as the default.
    N=No
    Y=Yes

    Default: N

    WL_SENDER Character(1) VARCHAR2(1) NOT NULL Notification Sender
    1=User
    2=System
    3=Other
    4=System-Blackberry

    Default: 1

    EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    WL_SUBJECT Character(254) VARCHAR2(254) NOT NULL Subject
    WL_INSTR_TXT Character(254) VARCHAR2(254) NOT NULL Instructional Text
    WL_RESPONSE_TXT Character(254) VARCHAR2(254) NOT NULL Response Text
    WL_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    WL_ADDED_DTTM DateTime(26) TIMESTAMP Date/Time Created
    WL_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By
    WL_LASTMANT_DTTM DateTime(26) TIMESTAMP Date Modified
    WL_MSG_TXT Long Character CLOB Message Text
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19