POS_BDGT_CTX_VW (SQL View)	Index Back
Current CTX 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_CTX_VW

(SQL View)

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