BUSPROCNAMEPrompt Table: PSBUSPROCDEFN
ACTIVITYNAMEPrompt Table: PSACTIVITYDEFN
EVENTNAMEPrompt Table: PSEVENTDEFN
WORKLISTNAMEPrompt Table: WORKLIST_PRMPT
WORKLIST_SEARCH(SQL View) |
Index Back |
|---|
| SELECT A.OBJNAME , A.COMPNAME , B.EVENTNAME , B.ROUTENAME , B.WLRECNAME FROM PSBUSPROCITEM A , PSEVENTROUTE B WHERE A.COMPNAME = B.ACTIVITYNAME AND A.OBJTYPE = 0 AND B.ROUTETYPE = 3 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: PSBUSPROCDEFN |
| 2 | ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: PSACTIVITYDEFN |
| 3 | EVENTNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
Prompt Table: PSEVENTDEFN |
| 4 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Worklist Name
Prompt Table: WORKLIST_PRMPT |
| 5 | WLRECNAME | Character(15) | VARCHAR2(15) NOT NULL | WorkList Record Name |