AM_ED_BUDGET

(SQL View)
 Index Back

Holds Summary Budget Data

This record is populated by the PC_BUD_SUM application engine. The Budget data comes from PC_BUD_DETAIL, while the actuals info comes from PROJ_RESOURCE.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , MIN(A.CURRENCY_CD) , MIN(A.CURRENCY_CD_PC) , SUM(A.BUDGET_AMOUNT) , SUM(A.PC_BUDGET_AMOUNT) FROM PS_PC_BUD_SUMMARY A WHERE A.PC_BUD_TYPE = 'C' GROUP BY A.BUSINESS_UNIT , A.PROJECT_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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
4 CURRENCY_CD_PC Character(3) VARCHAR2(3) NOT NULL Projects BU Currency
5 BUDGET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Projects Budget Amount
6 PC_BUDGET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The budget amount in the currency of the Projects business unit.