P6_ACT_BUDGT_VW

(SQL View)
 Index Back

P6 Activity Budget Amt View

PSFT Project Activity total Budget amount, aggregated per (detail) Activity ID

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , B.ACTIVITY_ID , %Round(SUM(%DecMult(B.RESOURCE_AMOUNT, C.SIGNED_VALUE)),3) FROM PS_PROJECT A , PS_PC_SUMMARY_TBL B , PS_PROJ_AN_GRP_MAP C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PROJECT_ID = A.PROJECT_ID AND B.CURRENCY_CD = A.CURRENCY_CD AND C.SETID = ( SELECT I.SETID FROM PS_SET_CNTRL_REC I WHERE I.SETCNTRLVALUE = A.BUSINESS_UNIT AND I.REC_GROUP_ID = 'PC_01' AND I.RECNAME = 'PROJ_AN_GRP_MAP') AND C.ANALYSIS_GROUP = A.AN_GRP_ACTV_BUD AND C.ANALYSIS_TYPE = B.ANALYSIS_TYPE GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID, B.ACTIVITY_ID

# 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 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount