GRP_BUDGET_VW (SQL View)	Index Back
Grp Merit Increase Budget Vw GRP_BUDGET_VW is a view which retrieves only the budget values with a salary action type of 'PAY'. This allows the plan to be initialized to budget in the group plan panel, which only handles merit pay increases, not promotions or other types of actions for which budgets may be established.

GRP_BUDGET_VW

(SQL View)

Grp Merit Increase Budget Vw

GRP_BUDGET_VW is a view which retrieves only the budget values with a salary action type of 'PAY'. This allows the plan to be initialized to budget in the group plan panel, which only handles merit pay increases, not promotions or other types of actions for which budgets may be established.

SELECT A.GB_GROUP_ID ,A.BUDGET_START_DT ,A.BUDGET_ID ,A.CURR_BUDGET_PCT ,A.CURR_BUDGET_AMT ,A.BUDGET_APPROVED FROM PS_GRP_INCR_BUDGET A WHERE A.ACTION = 'PAY' AND A.ACTION_REASON = 'MER'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

2 BUDGET_START_DT Date(10) DATE Budget Period Start Date

3 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID

4 CURR_BUDGET_PCT Number(6,2) DECIMAL(5,2) NOT NULL Current Budget Percent

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

6 BUDGET_APPROVED Character(1) VARCHAR2(1) NOT NULL Budget Approved
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
2	BUDGET_START_DT	Date(10)	DATE	Budget Period Start Date
3	BUDGET_ID	Character(10)	VARCHAR2(10) NOT NULL	Budget ID
4	CURR_BUDGET_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Current Budget Percent
5	CURR_BUDGET_AMT	Number(19,3)	DECIMAL(18,3) NOT NULL	Current Budget Amount
6	BUDGET_APPROVED	Character(1)	VARCHAR2(1) NOT NULL	Budget Approved Default Value: N