GM_PT_PRJ_FA_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT_PC , A.PROJECT_ID , B.ACTIVITY_ID , C.FA_RATE_TYPE , C.FA_BASE_ID , D.FA_FUNDED_RATE_PCT FROM PS_GM_PT_PROJECT A , PS_PROJ_ACTIVITY B , PS_GM_PRJ_ACT_FA C , PS_GM_PRJ_ACT_FA3 D WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT_PC AND B.PROJECT_ID = A.PROJECT_ID AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.PROJECT_ID = B.PROJECT_ID AND C.ACTIVITY_ID = B.ACTIVITY_ID AND D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.PROJECT_ID = C.PROJECT_ID AND D.ACTIVITY_ID = C.ACTIVITY_ID AND D.FA_RATE_TYPE = C.FA_RATE_TYPE AND D.RATE_EFFDT = ( SELECT MAX(D1.RATE_EFFDT) FROM PS_GM_PRJ_ACT_FA3 D1 WHERE D.BUSINESS_UNIT = D1.BUSINESS_UNIT AND D.PROJECT_ID = D1.PROJECT_ID AND D.ACTIVITY_ID = D1.ACTIVITY_ID AND D.FA_RATE_TYPE = D1.FA_RATE_TYPE AND D1.RATE_EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC 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 FA_RATE_TYPE Character(5) VARCHAR2(5) NOT NULL FA_RATE_TYPE
5 FA_BASE_ID Character(5) VARCHAR2(5) NOT NULL FA_BASE_ID
6 FA_RATE_PCT Number(6,2) DECIMAL(5,2) NOT NULL FA_RATE_PCT