GROUP_INCR_CNTL (SQL Table)	Index Back
Sal Plan by Grp Default Values GROUP_INCR_CNTL is a control record for the Salary Planning application. It contains information regarding each budget period being planned and the start date of the planning process for each group participating in the plan. When a new salary planning cycle begins, this record must be entered during plan setup to establish the new control dates for the planning period. It is not possible to create a salary plan for a group for a particular planning period without this record.

GROUP_INCR_CNTL

(SQL Table)

Sal Plan by Grp Default Values

GROUP_INCR_CNTL is a control record for the Salary Planning application. It contains information regarding each budget period being planned and the start date of the planning process for each group participating in the plan. When a new salary planning cycle begins, this record must be entered during plan setup to establish the new control dates for the planning period. It is not possible to create a salary plan for a group for a particular planning period without this record.

Parent Record Of GRP_ANNIV2_TBL GRP_ANNIV_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
Prompt Table: GB_GROUP_TBL

2 BUDGET_START_DT Date(10) DATE NOT NULL Budget Start Date

3 BUDGET_END_DT Date(10) DATE NOT NULL Budget End Date

4 SAL_PLAN_START_DT Date(10) DATE NOT NULL Salary Planning Start Date

5 ANNIVERSARY_SW Character(1) VARCHAR2(1) NOT NULL Employee Anniversary Raises
Y/N Table Edit

6 NEW_HIRE_ELIG_DT Date(10) DATE New Hire Eligibility Date

7 SAL_PLAN_EFFDT Date(10) DATE Salary Plan Effective Date

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

9 EXCHNG_TO_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
Prompt Table: RT_TYPE_TBL

10 CONTROL_ID Character(5) VARCHAR2(5) NOT NULL Plan Default ID
Prompt Table: CONTROL_TBL_VW

11 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
Prompt Table: COMP_FREQ_VW

12 USE_MATRIX_MEX Character(2) VARCHAR2(2) NOT NULL Increment Budget Method
BU=Increment Budget Method
MA=Increment Matrix Method
Default Value: BU

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID. Prompt Table: GB_GROUP_TBL
2	BUDGET_START_DT	Date(10)	DATE NOT NULL	Budget Start Date
3	BUDGET_END_DT	Date(10)	DATE NOT NULL	Budget End Date
4	SAL_PLAN_START_DT	Date(10)	DATE NOT NULL	Salary Planning Start Date
5	ANNIVERSARY_SW	Character(1)	VARCHAR2(1) NOT NULL	Employee Anniversary Raises Y/N Table Edit
6	NEW_HIRE_ELIG_DT	Date(10)	DATE	New Hire Eligibility Date
7	SAL_PLAN_EFFDT	Date(10)	DATE	Salary Plan Effective Date
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
9	EXCHNG_TO_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: RT_TYPE_TBL
10	CONTROL_ID	Character(5)	VARCHAR2(5) NOT NULL	Plan Default ID Prompt Table: CONTROL_TBL_VW
11	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency. Prompt Table: COMP_FREQ_VW
12	USE_MATRIX_MEX	Character(2)	VARCHAR2(2) NOT NULL	Increment Budget Method BU=Increment Budget Method MA=Increment Matrix Method Default Value: BU