PC_ED_BUD_VW (SQL View)	Index Back
View of Project Budget This view will summarize the active cost budget for each project from the Projects summary table. Only budget data within the last 5 years will be selected. Used to compare against last 5 years of Expense spending in Endeca.

PC_ED_BUD_VW

(SQL View)

View of Project Budget

This view will summarize the active cost budget for each project from the Projects summary table. Only budget data within the last 5 years will be selected. Used to compare against last 5 years of Expense spending in Endeca.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , %Round(SUM(%DecMult(A.RESOURCE_AMOUNT, B.SIGNED_VALUE)), 3) , A.CURRENCY_CD FROM PS_PC_SUMMARY_TBL A , PS_PROJ_AN_GRP_MAP B , PS_SET_CNTRL_REC CNTRL , PS_PROJECT C , PS_EID_ETL_LASTRUN LR WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND CNTRL.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.SETID = CNTRL.SETID AND CNTRL.RECNAME = 'PROJ_AN_GRP_MAP' AND B.ANALYSIS_GROUP = C.AN_GRP_ACTV_BUD AND A.ANALYSIS_TYPE = B.ANALYSIS_TYPE AND %DateDiff(A.ACCOUNTING_DT, %CurrentDateIn) < 1826 AND LR.EID_DS_ID = 'Expenses' AND A.DTTM_STAMP >= LR.LAST_RUN_DTM GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID, A.CURRENCY_CD

# 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 BUDGET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Projects Budget Amount

4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	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	BUDGET_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Projects Budget Amount
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code