GPHK_RCPGRP1_VW

(SQL View)
 Index Back

Paygroup View

Used in GP_CAL_RUN_DTL.GP_PAYGROUP

SELECT DISTINCT B.PAY_ENTITY , B.GP_PAYGROUP , B.DESCR FROM PS_GP_PYE_PRC_STAT A , PS_GP_PYGRP B WHERE B.PAY_ENTITY = A.PAY_ENTITY

  • Related Language Record: GPHK_RCPGRP1_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    2 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description