P6_WBS_HRSWK_VW

(SQL View)
 Index Back

P6 WBS-Activity Hrs Worked Vw

PSFT Project Activity total Hours Worked, aggregated per Activity ID (level 1 view)

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , %Round(SUM(%DecMult(A.RESOURCE_QUANTITY, D.CONVERSION_RATE)), 2) FROM PS_PC_SUMMARY_TBL A , PS_BUS_UNIT_TBL_PC B , PS_BUS_UNIT_OPT_PC C , PS_UNITS_CVT_TBL D , PS_PROJ_AN_GRP_MAP E WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.UNIT_OF_MEASURE = A.UNIT_OF_MEASURE AND D.UNIT_OF_MEASURE_TO = B.UOM_HOURS AND E.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 E.ANALYSIS_GROUP = C.AN_GRP_LABOR AND E.ANALYSIS_TYPE = A.ANALYSIS_TYPE GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID, A.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_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity