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

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