WF_ACT_WL_VW(SQL View) |
Index Back |
---|---|
WF Activity / WL View |
SELECT OBJNAME, COMPNAME FROM PSBUSPROCITEM WHERE OBJTYPE = 1 AND COMPTYPE = 8 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
2 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |