PC_ALL_ACTS (SQL View)	Index Back
My Project Activities View of all activities from projects on My Projects list.

PC_ALL_ACTS

(SQL View)

My Project Activities

View of all activities from projects on My Projects list.

SELECT A.BUSINESS_UNIT , A.ACTIVITY_ID , MAX(A.DESCR) FROM PS_PROJ_ACTIVITY A WHERE A.COSTING_ACT_SW = 'Y' AND A.EFF_STATUS <> 'T' GROUP BY A.BUSINESS_UNIT, A.ACTIVITY_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: PROJ_ACT_SRCH

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: PROJ_ACT_SRCH
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description