PGM_ED_PLBUD_VW

(SQL View)
 Index Back

Project Discovery Planned Budg

Planned budget by project activities used for Project Discovery. Includes only pending projects.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , D.ACTIVITY_ID , SUM(D.FOREIGN_AMOUNT) AS PLANNED_BUDGET FROM PS_PROJECT A , PS_PC_BUD_PLAN BP , PS_PC_BUD_DETAIL D , PS_BUS_UNIT_TBL_PC P WHERE A.BUSINESS_UNIT = P.BUSINESS_UNIT AND A.EFF_STATUS = 'P' AND A.BUSINESS_UNIT = BP.BUSINESS_UNIT AND A.PROJECT_ID = BP.PROJECT_ID AND BP.PC_BUDGET_STATUS = '1' AND BP.PC_BUD_TYPE = 'C' AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID AND BP.PC_BUDGET_ID = D.PC_BUDGET_ID AND D.FOREIGN_CURRENCY = P.CURRENCY_CD GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID, D.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 BUDGET_ESTIMATE Signed Number(28,3) DECIMAL(26,3) NOT NULL Budget Estimate Amount