PC_SUM_HRSB_VW

(SQL View)
 Index Back

Sum Actual Project Hours


SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , B.PROJECT_TYPE , ' ' , %DateNull , ' ' , 0 , %Round(SUM(%DecMult(%DecMult(A.RESOURCE_QUANTITY, E.QUANTITY_MULTIPLY), D.CONVERSION_RATE)), 2) FROM PS_PC_SUMMARY_TBL A , PS_PROJECT B , PS_BUS_UNIT_TBL_PC C , PS_UNITS_CVT_TBL D , PS_PROJ_AN_GRP_MAP E , PS_SET_CNTRL_REC F WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.UNIT_OF_MEASURE = D.UNIT_OF_MEASURE AND D.UNIT_OF_MEASURE_TO = C.UOM_HOURS AND E.ANALYSIS_GROUP = B.AN_GRP_ACTV_BUD AND E.SETID = F.SETID AND E.ANALYSIS_TYPE = A.ANALYSIS_TYPE AND F.RECNAME = 'PROJ_AN_GRP_MAP' AND F.SETCNTRLVALUE = A.BUSINESS_UNIT GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID, A.ACTIVITY_ID, B.PROJECT_TYPE

# 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 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
5 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
6 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
7 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
8 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
9 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity