TRN_VAL_PAY_VW

(SQL View)
 Index Back

Training Pay Group View

This View is used to Retrieve the Paygroup Based on the Employee.

SELECT B.EMPLID , B.EMPL_RCD , B.GP_PAYGROUP ,D.DESCR FROM PS_JOB B ,PS_GP_PYGRP D WHERE B.GP_PAYGROUP=D.GP_PAYGROUP AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_JOB D WHERE D.EMPLID = B.EMPLID AND D.EMPL_RCD = B.EMPL_RCD AND D.EFFDT <= %CurrentDateIn) AND B.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT = B.EFFDT)

  • Related Language Record: TRN_VPAY_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description