PC_ETC_HRS_VW

(SQL View)
 Index Back

View of Remaining Hours

View of Forecasted Remaining Hours by Project / Activity

SELECT A.BUSINESS_UNIT_PC , A.PROJECT_ID , A.ACTIVITY_ID , D.PROJECT_TYPE , SUM(A.TOTAL_HOURS + A.REMAINING_HRS) FROM PS_FC_TIME_DTL A , PS_FC_TIME_HDR B , PS_PC_HORIZON_VW C , PS_PROJECT D WHERE A.EMPLID = B.EMPLID AND A.BEGIN_DT = B.BEGIN_DT AND B.BUSINESS_UNIT_GL = C.BUSINESS_UNIT_GL AND B.BEGIN_DT = C.BEGIN_DT AND A.BUSINESS_UNIT_PC = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID GROUP BY A.BUSINESS_UNIT_PC, A.PROJECT_ID, D.PROJECT_TYPE, 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 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
5 PC_ETC_HRS Signed Number(16,2) DECIMAL(14,2) NOT NULL Forecast to Complete Hours