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 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
2 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |