GP_PYGRP_CAL_VW

(SQL View)
 Index Back

Paygroup/Calendar View

Displays the paygroups that are associated with a calendar. Used as a prompt on the GP_PYE_RUN (Payee Calendar Group) page.

SELECT PE.COUNTRY , PG.GP_PAYGROUP , PG.DESCR FROM PS_GP_PYENT PE , PS_GP_PYGRP PG WHERE PE.PAY_ENTITY = PG.PAY_ENTITY AND EXISTS ( SELECT 1 FROM PS_GP_CALENDAR CAL WHERE PG.GP_PAYGROUP = CAL.GP_PAYGROUP)

  • Related Language Record: GP_CAL_PYGRP_LV

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