PC_MYPROJ_ACTS

(SQL View)
Index Back

My Project Activities

View 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