SAL_PLN_CONTROL (SQL Table)	Index Back
Salary Plan Control SAL_PLN_CONTROL is a control record for the Salary Planning application. It contains the default values which are brought into the GROUP_INCR_CNTL record, which is by group. It contains information regarding the budget period being planned and the start date of the planning process. When a new salary planning cycle begins, this is the first record which must be changed during plan setup to establish the new defaults for the planning period.

SAL_PLN_CONTROL

(SQL Table)

Salary Plan Control

SAL_PLN_CONTROL is a control record for the Salary Planning application. It contains the default values which are brought into the GROUP_INCR_CNTL record, which is by group. It contains information regarding the budget period being planned and the start date of the planning process. When a new salary planning cycle begins, this is the first record which must be changed during plan setup to establish the new defaults for the planning period.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTROL_ID Character(5) VARCHAR2(5) NOT NULL Plan Default ID
Prompt Table: CONTROL_TBL

2 BUDGET_START_DT Date(10) DATE NOT NULL Budget Period 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
Default Value: N

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
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL

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

10 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

11 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	CONTROL_ID	Character(5)	VARCHAR2(5) NOT NULL	Plan Default ID Prompt Table: CONTROL_TBL
2	BUDGET_START_DT	Date(10)	DATE NOT NULL	Budget Period 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 Default Value: N
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 Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
9	EXCHNG_TO_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_RT_TYPE Prompt Table: RT_TYPE_TBL
10	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
11	USE_MATRIX_MEX	Character(2)	VARCHAR2(2) NOT NULL	Increment Budget Method BU=Increment Budget Method MA=Increment Matrix Method Default Value: BU