POS_BDGT_DED_VW (SQL View)	Index Back
Current Ded Budget by Posn # The POS_BDGT_DED_VW sums the deduction distribution percentages and amounts currently budgeted to a position and displays the amounts on POSITION_DATA3 panel.

POS_BDGT_DED_VW

(SQL View)

Current Ded Budget by Posn #

The POS_BDGT_DED_VW sums the deduction distribution percentages and amounts currently budgeted to a position and displays the amounts on POSITION_DATA3 panel.

SELECT DED.POSITION_NBR ,SUM(DED.BUDGET_AMT) ,SUM(DED.DIST_PCT) FROM PS_DEPT_BUDGET_DED DED WHERE DED.EFFDT = (SELECT MAX(DTB.EFFDT) FROM PS_DEPT_BUDGET DTB WHERE DTB.SETID = DED.SETID AND DTB.DEPTID = DED.DEPTID AND DTB.FISCAL_YEAR = DED.FISCAL_YEAR AND DTB.EFFDT <= %CURRENTDATEIN) AND EXISTS (SELECT 'X' FROM PS_DEPT_BUDGET DTB1 WHERE DTB1.SETID = DED.SETID AND DTB1.DEPTID = DED.DEPTID AND DTB1.FISCAL_YEAR = DED.FISCAL_YEAR AND DTB1.EFFDT = DED.EFFDT AND DTB1.EFF_STATUS = 'A') AND EXISTS (SELECT 'X' FROM PS_DEPT_BUDGET_DT DT WHERE DT.SETID = DED.SETID AND DT.DEPTID = DED.DEPTID AND DT. FISCAL_YEAR = DED.FISCAL_YEAR AND DT.BUDGET_BEGIN_DT <= %CURRENTDATEIN AND DT.BUDGET_END_DT >= %CURRENTDATEIN) GROUP BY DED.POSITION_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA

2 CURR_BUDGET_AMT Number(19,3) DECIMAL(18,3) NOT NULL Current Budget Amount

3 DIST_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percent of Distribution

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
2	CURR_BUDGET_AMT	Number(19,3)	DECIMAL(18,3) NOT NULL	Current Budget Amount
3	DIST_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Percent of Distribution