WL_FEED_PARAMETERSLANGUAGE_CDPSWLWLIST_LVW(SQL View) |
Index Back |
|---|---|
Worklist Name Search RecordWorklist Name Search Record - Language View |
| SELECT DISTINCT(A.ROUTENAME) , C.LANGUAGE_CD , C.DESCR60 FROM PSEVENTROUTE A , PSBUSPROCITEM B , PSBUSPITEMLANG C WHERE ( B.COMPTYPE = 8 OR B.COMPTYPE = 9) AND A.ROUTENAME = B.COMPNAME AND B.COMPNAME = C.COMPNAME AND B.COMPTYPE = C.COMPTYPE |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |