P6_PROJ_INTG_VW

(SQL View)
 Index Back

P6 Project Integration View

PSFT Projects designated eligible for P6 integration, with their corresponding Synch Template element/option settings

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.P6_TEMPLATE_ID , B.PROJ_HDR_EXP_FLG , B.PROJ_HDR_IMP_FLG , B.WBS_ACT_EXP_FLG , B.WBS_ACT_IMP_FLG , B.PROJ_TEAM_EXP_FLG , B.PROJ_TEAM_IMP_FLG , B.RSRC_ASGN_EXP_FLG , B.RSRC_ASGN_IMP_FLG , B.BUDGT_EXP_FLG , B.BUDGT_IMP_FLG , B.HRS_WRKD_EXP_FLG , B.HRS_WRKD_IMP_FLG , B.ACT_COST_EXP_FLG , B.ACT_COST_IMP_FLG , A.P6_WBS_LVL , B.ALL_WBS , B.WBS_PC_EXP_FLG , B.WBS_PC_IMP_FLG , B.WBS_PC_SOURCE , B.CMTMNT_EXP_FLG , B.CMTMNT_IMP_FLG FROM PS_PROJECT A , PS_P6_SYNC_TMPLT B WHERE A.EFF_STATUS IN ('A','I') AND A.P6_INCL_INTGRTN = 'Y' AND B.P6_TEMPLATE_ID = A.P6_TEMPLATE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

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

Prompt Table: PROJECT_VW

3 P6_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL P6 Synchronization Template Id

Prompt Table: P6_SYNC_TMPLT

4 PROJ_HDR_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Project Header Export Flag

Y/N Table Edit

5 PROJ_HDR_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Project Header Import Flag

Y/N Table Edit

6 WBS_ACT_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Work Breakdown / Activity Export Flag

Y/N Table Edit

7 WBS_ACT_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Work Breakdown / Activity Import Flag

Y/N Table Edit

8 PROJ_TEAM_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Project Team Export Flag

Y/N Table Edit

9 PROJ_TEAM_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Project Team Import Flag

Y/N Table Edit

10 RSRC_ASGN_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Resource Assignment Export Flag

Y/N Table Edit

11 RSRC_ASGN_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Resource Assignment Import Flag

Y/N Table Edit

12 BUDGT_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Budget Export Flag

Y/N Table Edit

13 BUDGT_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Budget Import Flag

Y/N Table Edit

14 HRS_WRKD_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Hours Worked Export Flag

Y/N Table Edit

15 HRS_WRKD_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Hours Worked Import Flag

Y/N Table Edit

16 ACT_COST_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Actual Cost Export Flag

Y/N Table Edit

17 ACT_COST_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Actual Cost Import Flag

Y/N Table Edit

18 P6_WBS_LVL Number(2,0) SMALLINT NOT NULL Work Breakdown Structure Level
19 ALL_WBS Character(1) VARCHAR2(1) NOT NULL Entire WBS
N=Work Breakdown Level
Y=Entire Work Breakdown

Y/N Table Edit

20 WBS_PC_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Percent Complete Export Flag

Y/N Table Edit

21 WBS_PC_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Percent Complete Import Flag

Y/N Table Edit

22 WBS_PC_SOURCE Character(1) VARCHAR2(1) NOT NULL Percent Complete Source
D=Duration Percent Complete
P=Performance Percent Complete
U=Unit Percent Complete
23 CMTMNT_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Commitment Export Flag

Y/N Table Edit

24 CMTMNT_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Commitment Import Flag

Y/N Table Edit