WL_FEED_PARAMETERSPSWLWLIST_SRCH(SQL View) |
Index Back |
|---|---|
Worklist Name Search RecordWorklist Name Search Record |
| SELECT DISTINCT(A.ROUTENAME) , B.DESCR60 FROM PSEVENTROUTE A , PSBUSPROCITEM B WHERE ( B.COMPTYPE = 8 OR B.COMPTYPE = 9) AND A.ROUTENAME = B.COMPNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WL_FEED_PARAMETERS |
Character(30) | VARCHAR2(30) NOT NULL | Field to store worklist feed parameter name like priority, status, timed out and worklist name in worklist feed related search records. |
| 2 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |