ACTIVITYNAMESP_WF_NOTIFY(SQL View) |
Index Back |
|---|
| SELECT ac.OBJNAME AS ACTIVITYNAME ,ac.DESCR60 AS DESCR60 ,em.ACTIVE AS USE_EMAIL ,wl.ACTIVE AS USE_WORKLIST FROM PSBUSPROCITEM ac ,PSEVENTDEFN em ,PSEVENTDEFN wl WHERE em.ACTIVITYNAME = ac.OBJNAME AND em.EVENTNAME = 'EM' AND wl.ACTIVITYNAME = ac.OBJNAME AND wl.EVENTNAME = 'WL' AND ac.COMPTYPE=6 AND ac.OBJNAME IN ( SELECT DISTINCT(bp.SRCNAME) FROM PSBUSPROCITEM bp WHERE bp.COMPTYPE = 1 AND bp.OBJNAME LIKE 'SP%') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| 2 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 3 | USE_EMAIL | Number(5,0) | INTEGER NOT NULL | Active |
| 4 | USE_WORKLIST | Number(5,0) | INTEGER NOT NULL | Active |