GP_PYGRP7_VW

(SQL View)
 Index Back

Payroll paygroup in Cal Group

Used as prompt to retrieve the Pay Groups attached to a particular GP Calendar Group, where the Calendar is for a Payroll (not Absence)

SELECT DISTINCT A.CAL_RUN_ID , A.GP_PAYGROUP , B.DESCR FROM PS_GP_CAL_RUN_DTL A , PS_GP_PYGRP B WHERE A.GP_PAYGROUP = B.GP_PAYGROUP AND EXISTS ( SELECT 1 FROM PS_GP_CALENDAR CAL , PS_GP_RUN_TYPE RT WHERE CAL.GP_PAYGROUP=A.GP_PAYGROUP AND CAL.CAL_ID=A.CAL_ID AND CAL.RUN_TYPE=RT.RUN_TYPE AND RT.CALC_TYPE='P')

  • Related Language Record: GP_PYGRP7_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