PC_GETCOST_ACT (SQL View)	Index Back
Retrieve the costing activity This view will select the costing level activity for any activity based on the project's work breakdown structure. This view will only retrieve rows where the project's charging level is set to level 1, 2, or 3 of the wbs. This view is not applicable for project's with charging level set to 'D' for detail, since all detail activities are available for charging.

PC_GETCOST_ACT

(SQL View)

Retrieve the costing activity

This view will select the costing level activity for any activity based on the project's work breakdown structure. This view will only retrieve rows where the project's charging level is set to level 1, 2, or 3 of the wbs. This view is not applicable for project's with charging level set to 'D' for detail, since all detail activities are available for charging.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , B.ACTIVITY_ID FROM PS_PROJ_ACTIVITY A , PS_PROJ_ACTIVITY B , PS_PROJECT C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND ((C.CHARGING_LEVEL = '1' AND B.LEVEL_NUM = 1 AND A.LEVEL1 = B.LEVEL1) OR (C.CHARGING_LEVEL = '2' AND B.LEVEL_NUM = 2 AND A.LEVEL1 = B.LEVEL1 AND A.LEVEL2 = B.LEVEL2) OR (C.CHARGING_LEVEL = '3' AND B.LEVEL_NUM = 3 AND A.LEVEL1 = B.LEVEL1 AND A.LEVEL2 = B.LEVEL2 AND B.LEVEL3 = A.LEVEL3))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

4 COST_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL This field identifies the costing level activity id when the Project's charging level is set to either level 1, 2, or 3 of the work breakdown structure (wbs).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
4	COST_ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	This field identifies the costing level activity id when the Project's charging level is set to either level 1, 2, or 3 of the work breakdown structure (wbs).