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

POS_BDGT_ERN_VW

(SQL View)

Current Earns Budget by Posn #

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

SELECT ERN.POSITION_NBR ,SUM(ERN.BUDGET_AMT) ,SUM(ERN.DIST_PCT) FROM PS_DEPT_BUDGET_ERN ERN WHERE ERN.EFFDT = (SELECT MAX(DTB.EFFDT) FROM PS_DEPT_BUDGET DTB WHERE DTB.SETID = ERN.SETID AND DTB.DEPTID = ERN.DEPTID AND DTB.FISCAL_YEAR = ERN.FISCAL_YEAR AND DTB.EFFDT <= %CURRENTDATEIN) AND EXISTS (SELECT 'X' FROM PS_DEPT_BUDGET DTB1 WHERE DTB1.SETID = ERN.SETID AND DTB1.DEPTID = ERN.DEPTID AND DTB1.FISCAL_YEAR = ERN.FISCAL_YEAR AND DTB1.EFFDT = ERN.EFFDT AND DTB1.EFF_STATUS = 'A') AND EXISTS (SELECT 'X' FROM PS_DEPT_BUDGET_DT DT WHERE DT.SETID = ERN.SETID AND DT.DEPTID = ERN.DEPTID AND DT. FISCAL_YEAR = ERN.FISCAL_YEAR AND DT.BUDGET_BEGIN_DT <= %CURRENTDATEIN AND DT.BUDGET_END_DT >= %CURRENTDATEIN) GROUP BY ERN.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