P6_WBS_EX_VW (SQL View)	Index Back
P6 WBS-Activity Export View PSFT Project Activity data available for extract

P6_WBS_EX_VW

(SQL View)

P6 WBS-Activity Export View

PSFT Project Activity data available for extract

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , B.ACTIVITY_ID , D.PARENT_ACTIVITY_ID , B.EFF_STATUS , B.DESCR , CASE WHEN C.ACTIVITY_STATUS IS NULL THEN ' ' ELSE C.ACTIVITY_STATUS END , B.PERCENT_COMPLETE , B.START_DT , B.END_DT , B.ACTUAL_START_DT , B.ACTUAL_FINISH_DT , B.EARLY_START_DT , B.EARLY_FINISH_DT , A.PC_CALC_METHOD , B.PC_MILESTONE_FLG , B.SUMMARY_ACT , B.P6_WBS_FLAG , B.LEVEL_NUM , 0 , D.ACTIVITY_OBJECTID , D.PARENT_OBJECTID FROM PS_PROJECT A , PS_PROJ_ACTIVITY B LEFT OUTER JOIN PS_PC_CUR_ACTST_VW C ON C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.PROJECT_ID = B.PROJECT_ID AND C.ACTIVITY_ID = B.ACTIVITY_ID , PS_P6_PARNT_OBJ_VW D WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PROJECT_ID = A.PROJECT_ID AND B.SUMMARY_ACT IN ('Y','N') AND D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.PROJECT_ID = B.PROJECT_ID AND D.ACTIVITY_ID = B.ACTIVITY_ID AND B.EFF_STATUS = 'A'

# 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 PARENT_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL An Activity that is the parent of another Activity within a WBS tree structure.

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

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

7 ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status

8 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete

9 START_DT Date(10) DATE Start Date

10 END_DT Date(10) DATE End Date

11 ACTUAL_START_DT Date(10) DATE Actual Start Date

12 ACTUAL_FINISH_DT Date(10) DATE Actual Finish Date

13 EARLY_START_DT Date(10) DATE Early Start Date

14 EARLY_FINISH_DT Date(10) DATE Early Finish Date

15 PC_CALC_METHOD Character(1) VARCHAR2(1) NOT NULL Calculation Method
A=Budget Amount
D=Duration
F=Forecast Amount
H=Forecast Hours
M=Manual
U=Budget Hours

16 PC_MILESTONE_FLG Character(1) VARCHAR2(1) NOT NULL Milestone Activity
N=No
Y=Yes

17 SUMMARY_ACT Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether an activity is summary or detail.
N=Detail Activity
Y=Summary Activity

18 P6_WBS_FLAG Character(1) VARCHAR2(1) NOT NULL A flag, when set to Y(es) indicates that an activity originated from a Primavera WBS.
N=Activity
Y=Work Breakdown Structure

19 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level

20 PROJECT_OBJECTID Number(10,0) DECIMAL(10) NOT NULL A unique ID that is the Project key to a corresponding table in an external system such as Primavera.

21 ACTIVITY_OBJECTID Number(10,0) DECIMAL(10) NOT NULL A unique ID that is the Activity key to a corresponding table in an external system such as Primavera.

22 PARENT_OBJECTID Number(10,0) DECIMAL(10) NOT NULL A unique ID that is the Activity key to a corresponding table in an external system such as Primavera.

#	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	PARENT_ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	An Activity that is the parent of another Activity within a WBS tree structure.
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	ACTIVITY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Activity Status
8	PERCENT_COMPLETE	Number(6,2)	DECIMAL(5,2) NOT NULL	% Complete
9	START_DT	Date(10)	DATE	Start Date
10	END_DT	Date(10)	DATE	End Date
11	ACTUAL_START_DT	Date(10)	DATE	Actual Start Date
12	ACTUAL_FINISH_DT	Date(10)	DATE	Actual Finish Date
13	EARLY_START_DT	Date(10)	DATE	Early Start Date
14	EARLY_FINISH_DT	Date(10)	DATE	Early Finish Date
15	PC_CALC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Calculation Method A=Budget Amount D=Duration F=Forecast Amount H=Forecast Hours M=Manual U=Budget Hours
16	PC_MILESTONE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Milestone Activity N=No Y=Yes
17	SUMMARY_ACT	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate whether an activity is summary or detail. N=Detail Activity Y=Summary Activity
18	P6_WBS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag, when set to Y(es) indicates that an activity originated from a Primavera WBS. N=Activity Y=Work Breakdown Structure
19	LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Level
20	PROJECT_OBJECTID	Number(10,0)	DECIMAL(10) NOT NULL	A unique ID that is the Project key to a corresponding table in an external system such as Primavera.
21	ACTIVITY_OBJECTID	Number(10,0)	DECIMAL(10) NOT NULL	A unique ID that is the Activity key to a corresponding table in an external system such as Primavera.
22	PARENT_OBJECTID	Number(10,0)	DECIMAL(10) NOT NULL	A unique ID that is the Activity key to a corresponding table in an external system such as Primavera.