PNLGRPNAMEMARKETWL_TEMPLATE_ID1=1-High
2=2-Medium
3=3-Low
N=No
Y=Yes
Default Value: N
1=User
2=System
3=Other
4=System-Blackberry
Default Value: 1
WL_TEMPLATE(SQL Table) |
Index Back |
|---|---|
Component TemplatesStores component templates for notifications. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | WL_TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | WL_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Worklist Priority
1=1-High 2=2-Medium 3=3-Low |
| 6 | 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 Value: N |
| 7 | WL_SENDER | Character(1) | VARCHAR2(1) NOT NULL |
Notification Sender
1=User 2=System 3=Other 4=System-Blackberry Default Value: 1 |
| 8 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 9 | WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 10 | WL_INSTR_TXT | Character(254) | VARCHAR2(254) NOT NULL | Instructional Text |
| 11 | WL_RESPONSE_TXT | Character(254) | VARCHAR2(254) NOT NULL | Response Text |
| 12 | WL_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 13 | WL_ADDED_DTTM | DateTime(26) | TIMESTAMP | Date/Time Created |
| 14 | WL_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By |
| 15 | WL_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | Date Modified |
| 16 | WL_MSG_TXT | Long Character | CLOB | Message Text |