GP_PYGRP_ABS_VW

(SQL View)
 Index Back

Paygroups w absence calendars

View of Paygroups that are associated with at least one absence calendar

SELECT PG.GP_PAYGROUP , PG.DESCR , PG.DESCRSHORT FROM PS_GP_PYGRP PG WHERE EXISTS ( SELECT 1 FROM PS_GP_CALENDAR CAL , PS_GP_RUN_TYPE RT WHERE CAL.GP_PAYGROUP=PG.GP_PAYGROUP AND CAL.RUN_TYPE=RT.RUN_TYPE AND RT.CALC_TYPE='A')

  • Related Language Record: GP_PYGRP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

    Prompt Table: %GP_EDIT_FLD2

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description