BUSPROCNAMEPrompt Table: PSBUSPROCDEFN
ACTIVITYNAMEPrompt Table: PSACTIVITYDEFN
EVENTNAMEPrompt Table: PSEVENTDEFN
WORKLISTNAMEPrompt Table: WORKLIST_PRMPT
WORKLIST_SEARCH |
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 | Field Type | Column Type | Description |
|---|---|---|---|
| BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: PSBUSPROCDEFN |
| ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: PSACTIVITYDEFN |
| EVENTNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
Prompt Table: PSEVENTDEFN |
| WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Worklist Name
Prompt Table: WORKLIST_PRMPT |
| WLRECNAME | Character(15) | VARCHAR2(15) NOT NULL | WorkList Record Name |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |