GRP_ANNIV_TBL (SQL Table)	Index Back
Anniversary Date table GRP_ANNIV_TBL finds employees in a department eligible for salary increases based on the month and day of their hire or rehire date. It is different from the GRP_PLAN_VW since it does not check for new hire eligibility date and it uses the substring function to check for hire/rehire month & day from JOB to verify it is within the budget period. There is peoplecode in SALARY_PLAN.EFFDT that determines the appropriate year (budget start or end date year) to attach to the EFFDT. It is used as a SelectRecord for ScrollSelect in the Salary Planning application. When the anniversary switch is "Y", all eligible employees are automatically brought into the panel using this record.

GRP_ANNIV_TBL

(SQL Table)

Anniversary Date table

GRP_ANNIV_TBL finds employees in a department eligible for salary increases based on the month and day of their hire or rehire date. It is different from the GRP_PLAN_VW since it does not check for new hire eligibility date and it uses the substring function to check for hire/rehire month & day from JOB to verify it is within the budget period. There is peoplecode in SALARY_PLAN.EFFDT that determines the appropriate year (budget start or end date year) to attach to the EFFDT. It is used as a SelectRecord for ScrollSelect in the Salary Planning application. When the anniversary switch is "Y", all eligible employees are automatically brought into the panel using this record.

Parent record: GROUP_INCR_CNTL

# 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 Start Date

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

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

6 EFFDT Date(10) DATE Effective Date
Default Value: %date

7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

8 JOB_EFFDT Date(10) DATE Job Effective Date

9 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence

10 HIRE_DT Date(10) DATE First Start Date

11 REHIRE_DT Date(10) DATE Rehire Date

12 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: ACTION_TBL

13 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

14 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate

#	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 Start Date
3	BUDGET_ID	Character(10)	VARCHAR2(10) NOT NULL	Budget ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
8	JOB_EFFDT	Date(10)	DATE	Job Effective Date
9	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
10	HIRE_DT	Date(10)	DATE	First Start Date
11	REHIRE_DT	Date(10)	DATE	Rehire Date
12	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
13	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
14	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate