PC_MYPROJ_ACTS(SQL View) |
Index Back |
---|---|
My Project ActivitiesView of all activities from projects on My Projects list. |
SELECT A.OPRID , A.BUSINESS_UNIT , B.ACTIVITY_ID , MAX(B.DESCR) FROM PS_PC_OPRID_PRJACT A , PS_PROJ_ACTIVITY B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.COSTING_ACT_SW = 'Y' AND B.EFF_STATUS <> 'T' GROUP BY A.OPRID, A.BUSINESS_UNIT, B.ACTIVITY_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_SRCH |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |