GRP_PLAN_VW (SQL View)	Index Back
Select Vw for Salary Planning GRP_PLAN_VW finds employees in a department eligible for salary increases as of the planning start date. It is used as a SelectRecord for ScrollSelect in the Salary Planning application. When the "Initialize Plan" checkbox is selected for the group salary plan, all eligible employees are automatically brought into the screen using this record.

GRP_PLAN_VW

(SQL View)

Select Vw for Salary Planning

GRP_PLAN_VW finds employees in a department eligible for salary increases as of the planning start date. It is used as a SelectRecord for ScrollSelect in the Salary Planning application. When the "Initialize Plan" checkbox is selected for the group salary plan, all eligible employees are automatically brought into the screen using this record.

SELECT C.GB_GROUP_ID ,C.BUDGET_START_DT ,C.BUDGET_ID ,P.EMPLID ,P.EMPL_RCD ,C.EFFDT ,C.EFFSEQ ,C.ACTION ,C.ACTION_REASON ,B.EFFDT ,B.EFFSEQ ,B.COMPRATE ,B.ANNUAL_RT FROM PS_PER_ORG_ASGN_VW P ,PS_JOB B ,PS_GRP_INCR_BUDGET C ,PS_GROUP_INCR_CNTL I ,PS_SAL_PLN_GRP_RES G WHERE I.GB_GROUP_ID = C.GB_GROUP_ID AND I.BUDGET_START_DT = C.BUDGET_START_DT AND C.EFFDT >= I.BUDGET_START_DT AND C.GB_GROUP_ID = G.GB_GROUP_ID AND P.EMPLID = G.EMPLID AND P.EMPL_RCD = G.EMPL_RCD AND P.PER_ORG = 'EMP' AND B.EMPLID = P.EMPLID AND B.EMPL_RCD = P.EMPL_RCD AND B.EFFDT = G.JOB_EFFDT AND B.EFFSEQ = G.JOB_EFFSEQ AND B.EFFDT = ( SELECT MAX(R1.EFFDT) FROM PS_JOB R1 WHERE B.EMPLID = R1.EMPLID AND B.EMPL_RCD = R1.EMPL_RCD AND R1.EFFDT <= I.SAL_PLAN_START_DT) AND B.EFFSEQ = ( SELECT MAX(R3.EFFSEQ) FROM PS_JOB R3 WHERE B.EMPLID = R3.EMPLID AND B.EMPL_RCD = R3.EMPL_RCD AND B.EFFDT = R3.EFFDT) AND C.EFFDT >= G.JOB_EFFDT AND B.HR_STATUS = 'A' AND I.NEW_HIRE_ELIG_DT >= P.HIRE_DT AND G.VERSIONGBQDM = ( SELECT MAX(G2.VERSIONGBQDM) FROM PS_SAL_PLN_GRP_RES G2 WHERE G.GB_GROUP_ID = G2.GB_GROUP_ID)

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

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

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

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

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

10 JOB_EFFDT Date(10) DATE Job Effective Date

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

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

13 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual 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 Period 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 Rcd Nbr
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
8	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
9	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
10	JOB_EFFDT	Date(10)	DATE	Job Effective Date
11	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
12	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
13	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate