WORKLISTNAMECS_CW_DWLSN_VW1(SQL View) |
Index Back |
|---|---|
Signature Related WL - ContracSCMT003 - for SCMT Docs -- Signature Related Worklists -- CONTRACT |
| SELECT DISTINCT a.worklistname , a.eoawdescr , %Substring(a.eoawdescr ,10, 5) , %Substring(a.eoawdescr ,34 ,25) , %Substring(a.eoawdescr ,75 ,1) FROM PS_EOAW_WL A , PSWORKLIST B WHERE A.EOAWPRCS_ID = 'Document' AND b.busprocname = a.busprocname AND b.activityname = a.activityname AND b.eventname = a.eventname AND b.worklistname = a.worklistname AND b.instanceid = a.instanceid AND b.inststatus IN (0,1) AND b.oprid = %OperatorId |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 2 | EOAWDESCR | Character(254) | VARCHAR2(254) NOT NULL | Descr |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 5 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |