EP_EMAIL_TXT_VW(SQL View) |
Index Back |
---|---|
EPF- Email NotifyEmail 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 |
# | 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 |