PC_COST_SUMB_VW

(SQL View)
 Index Back

View of Sum Bud Cost/act

This view calculates the bud cost by Activity

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , B.DESCR , B.PROJECT_TYPE , B.AN_GRP_TOT_COSTS , B.AN_GRP_ACTV_BUD , B.PERCENT_COMPLETE , %Round(SUM(%DecMult(A.RESOURCE_AMOUNT, C.SIGNED_VALUE)), 3) , MAX(A.CURRENCY_CD) FROM PS_PC_ACTIVITY_SUM A , PS_PROJECT B , PS_PROJ_AN_GRP_MAP C , PS_SET_CNTRL_REC D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND C.ANALYSIS_GROUP = B.AN_GRP_ACTV_BUD AND D.RECNAME = 'PROJ_AN_GRP_MAP' AND D.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.SETID = D.SETID AND A.ANALYSIS_TYPE = C.ANALYSIS_TYPE GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID, A.ACTIVITY_ID, B.DESCR, B.PROJECT_TYPE, B.AN_GRP_TOT_COSTS, B.AN_GRP_ACTV_BUD, B.PERCENT_COMPLETE

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
6 AN_GRP_TOT_COSTS Character(5) VARCHAR2(5) NOT NULL Cost Analysis Group
7 AN_GRP_ACTV_BUD Character(5) VARCHAR2(5) NOT NULL Budget Analysis Group
8 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete
9 PC_COST_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total cost for a project.
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code