EP_EMAIL_TXT_VW

(SQL View)
 Index Back

EPF- Email Notify

Email Notify Search record

SELECT WL_TEMPLATE_ID , DESCR , WL_PRIORITY , WL_SENDER , EMAILID , WL_SUBJECT , WL_INSTR_TXT , WL_RESPONSE_TXT , WL_ADDED_OPRID , WL_ADDED_DTTM , WL_LASTMANT_OPRID , WL_LASTMANT_DTTM , WL_MSG_TXT FROM PS_WL_TEMPLATE_GEN

  • Related Language Record: WL_TEMPLATE_GLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Worklist Priority
    1=1-High
    2=2-Medium
    3=3-Low

    Default Value: 2

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

    Default Value: 1

    5 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    6 WL_SUBJECT Character(254) VARCHAR2(254) NOT NULL Subject
    7 WL_INSTR_TXT Character(254) VARCHAR2(254) NOT NULL Instructional Text
    8 WL_RESPONSE_TXT Character(254) VARCHAR2(254) NOT NULL Response Text
    9 WL_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    10 WL_ADDED_DTTM DateTime(26) TIMESTAMP Date/Time Created
    11 WL_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By
    12 WL_LASTMANT_DTTM DateTime(26) TIMESTAMP Date Modified
    13 WL_MSG_TXT Long Character CLOB Message Text