SP_MER_INC_SRCH (SQL View)	Index Back
Merit Incr by Grp Search Rec Merit Increase by Group Search Record. The user can see the groups in the Merit Group Definition depending on the security of the group

SP_MER_INC_SRCH

(SQL View)

Merit Incr by Grp Search Rec

Merit Increase by Group Search Record. The user can see the groups in the Merit Group Definition depending on the security of the group

SELECT B.GB_GROUP_ID , A.GB_OPRID , B.PNLGRPNAME , M.EP_REVIEW_TYPE , M.SP_FROM_DATE , M.SP_TO_DATE FROM PS_GB_SECGRPOPR_TB A , PS_GB_SECPNLG_TBL B , PS_SP_MER_INC_ELIG M WHERE A.GB_GROUP_ID = B.GB_GROUP_ID AND A.GB_OPRID = B.GB_OPRID AND A.EFFDT = B.EFFDT AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GB_SECGRPOPR_TB WHERE A.GB_GROUP_ID = GB_GROUP_ID AND A.GB_OPRID = GB_OPRID AND EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND M.GB_GROUP_ID = B.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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

4 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type
Prompt Table: EP_REVW_TYP_VW

5 SP_FROM_DATE Date(10) DATE From Date - used in Salary Planning

6 SP_TO_DATE Date(10) DATE To Date - used in Salary Planning

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
4	EP_REVIEW_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Review type Prompt Table: EP_REVW_TYP_VW
5	SP_FROM_DATE	Date(10)	DATE	From Date - used in Salary Planning
6	SP_TO_DATE	Date(10)	DATE	To Date - used in Salary Planning