PC_SUM_HRS_VW

(SQL View)
 Index Back

Summarized Project Hours


SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , B.PROJECT_TYPE , A.ANALYSIS_TYPE , A.ACCOUNTING_DT , A.UNIT_OF_MEASURE , D.CONVERSION_RATE , %Round(SUM(%DecMult(A.RESOURCE_QUANTITY, D.CONVERSION_RATE)), 2) FROM PS_PC_SUMMARY_TBL A , PS_PROJECT B , PS_BUS_UNIT_TBL_PC C , PS_UNITS_CVT_TBL D 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 GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID, A.ACTIVITY_ID, B.PROJECT_TYPE, A.ANALYSIS_TYPE, A.ACCOUNTING_DT, A.UNIT_OF_MEASURE, D.CONVERSION_RATE

# 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