SETID_ACTIVITYPROJ_ROLEACTIVITY_IDLANGUAGE_CDSPF_WO_ACT_LG_V(SQL View) |
Index Back |
|---|---|
Work Order Activitiesthis view fetches the services activities |
| SELECT DISTINCT D.SETID AS SETID_ACTIVITY , D.PROJ_ROLE , L.ACTIVITY_ID , L.LANGUAGE_CD , L.DESCR FROM PS_SPB_SRC_ACT D , PS_FS_ACTIVITY_TBL B , PS_FS_ACTIVITY_LNG L , PS_SET_CNTRL_GROUP C WHERE C.SETCNTRLVALUE = D.SETID AND C.REC_GROUP_ID = 'FS_43' AND B.SETID = C.SETID AND B.SETID = L.SETID AND B.ACTIVITY_ID = L.ACTIVITY_ID AND B.ACT_USE_SP = 'Y' AND D.ACTIVITY_ID = B.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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |