WL_TEMPLATE_IDSEQNODefault Value: 1
WL_TEMPL_GEN_TK(SQL Table) |
Index Back |
|---|---|
Generic TokensHolds the tokens for the generic template used in notifications. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WL_TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 2 | SEQNO |
Number(5,0) | INTEGER NOT NULL |
Sequence Number
Default Value: 1 |
| 3 | WL_TOKENID | Character(10) | VARCHAR2(10) NOT NULL | Value |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | WL_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 6 | WL_ADDED_DTTM | DateTime(26) | TIMESTAMP | Date/Time Created |
| 7 | WL_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By |
| 8 | WL_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | Date Modified |