RB_WF_TRANS_LVW(SQL View) |
Index Back |
|---|---|
CRM Worklist transaction typeRelated Language View for CRM Worklist Transaction type |
| SELECT DISTINCT A.OPRID , A.WORKLISTNAME , B.LANGUAGE_CD , B.DESCR FROM PSWORKLIST A , PS_RB_WL_GRID_LANG B WHERE B.WORKLISTNAME = A.WORKLISTNAME AND A.INSTSTATUS <=2 AND A.BUSPROCNAME <> 'Administer Workflow' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Worklist Name | |
| 3 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |