SP_MER_REVW_VW

(SQL View)
 Index Back

Merit Incr - Revw Type Prompt

Merit Increase by Group - Review Type Prompt Table. This table is used as prompt table for the Review Type.

SELECT DISTINCT M.GB_GROUP_ID , M.EP_REVIEW_TYPE , R.EP_REVW_DESCR FROM PS_SP_MER_INC_ELIG M , PS_EP_REVW_TYP_TBL R WHERE R.EP_REVIEW_TYPE = M.EP_REVIEW_TYPE AND R.EFF_STATUS = 'A' AND R.EFFDT = ( SELECT MAX(R1.EFFDT) FROM PS_EP_REVW_TYP_TBL R1 WHERE R1.EP_REVIEW_TYPE = M.EP_REVIEW_TYPE AND R1.EFFDT <= M.SP_FROM_DATE)

  • Related Language Record: SP_MER_REVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Prompt Table: GB_GROUP_TBL

    2 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

    Prompt Table: EP_REVW_TYP_VW

    3 EP_REVW_DESCR Character(30) VARCHAR2(30) NOT NULL Review description