SETID_ACTIVITYPROJ_ROLEACTIVITY_IDSPF_WO_ACT_VW(SQL View) |
Index Back |
|---|---|
Work Order Activitiesthis view fetches the services activities |
| SELECT DISTINCT A.SETID AS SETID_ACTIVITY , A.PROJ_ROLE , A.ACTIVITY_ID , C.DESCR FROM PS_SPB_SRC_ACT A , PS_FS_ACTIVITY_TBL C , PS_SET_CNTRL_GROUP S WHERE S.SETCNTRLVALUE = A.SETID AND S.REC_GROUP_ID = 'FS_43' AND S.SETID = C.SETID AND A.ACTIVITY_ID = C.ACTIVITY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_ACTIVITY |
Character(5) | VARCHAR2(5) NOT NULL | Activity SetID |
| 2 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |