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

POS_BDGT_TAX_VW

(SQL View)

Current Tax Budget by Posn #

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

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