GPNZ_RCPGRP2_VW

(SQL View)
Index Back

Paygroup View

Paygroup View

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

  • Related Language Record: GP_PYE_STAT3_VL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    2 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description