PROCESS_INSTANCEN=No
Y=Yes
N=No
Y=Yes
WL_RIMRESP_AET(SQL Table) |
Index Back |
|---|---|
AET file for WL_RIMRESP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 5 | ERRNUM | Number(5,0) | INTEGER NOT NULL | Error Number |
| 6 | WL_RIMNUMERR | Number(3,0) | SMALLINT NOT NULL | Number of Errors |
| 7 | WL_RIMNUMPROC | Number(3,0) | SMALLINT NOT NULL | Number Processed |
| 8 | WL_RIMNUMREAD | Number(3,0) | SMALLINT NOT NULL | Number Read |
| 9 | UIDL | Character(70) | VARCHAR2(70) NOT NULL | UIDL |
| 10 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 11 | NOTIFY_GUID | Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| 12 | EMAIL_FROM | Character(254) | VARCHAR2(254) NOT NULL | Email From |
| 13 | EMAIL_SENDER | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_SENDER |
| 14 | WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 15 | WL_RESPONSE | Character(30) | VARCHAR2(30) NOT NULL | Response Name |
| 16 | WL_PROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Process Flag |
| 17 | WL_MAXSEQ | Number(5,0) | INTEGER NOT NULL | Maximum Sequence Number |
| 18 | WL_FOUND | Character(1) | VARCHAR2(1) NOT NULL | Found |
| 19 | WL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Operator ID |
| 20 | WL_RESPONSE2 | Character(30) | VARCHAR2(30) NOT NULL | Response Name |
| 21 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 22 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 23 | WL_FWD_TOSENDER | Character(1) | VARCHAR2(1) NOT NULL |
Forward notification to sender indicator.
N=No Y=Yes |
| 24 | WL_FWD_WORKLIST | Character(1) | VARCHAR2(1) NOT NULL |
Forward to Sender indicator
N=No Y=Yes |
| 25 | EMAIL_TEXTLONG | Long Character | CLOB | Message Text |