WL_TEMPL_RESP(SQL Table) |
Index Back |
|---|---|
Component template responsesUsed to log responses to RIM pager notifications. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(18) | VARCHAR2(18) NOT NULL | Component Name | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Market | |
| 3 | Character(30) | VARCHAR2(30) NOT NULL | Template Name | |
| 4 | Number(5,0) | INTEGER NOT NULL | Sequence Number | |
| 5 | WL_FWD_TOSENDER | Character(1) | VARCHAR2(1) NOT NULL |
Forward notification to sender indicator.
N=No Y=Yes |
| 6 | WL_FWD_WORKLIST | Character(1) | VARCHAR2(1) NOT NULL |
Forward to Sender indicator
N=No Y=Yes |
| 7 | WL_RESPONSE | Character(30) | VARCHAR2(30) NOT NULL | Response Name |
| 8 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
Prompt Table: WL_AEAPP_LIB_VW |
| 9 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL |
Section
Prompt Table: PSAESECTDEFN |
| 10 | WL_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 11 | WL_ADDED_DTTM | DateTime(26) | TIMESTAMP | Date/Time Created |
| 12 | WL_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By |
| 13 | WL_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | Date Modified |