GP_CAL_PYGRP_VW

(SQL View)
 Index Back

Paygroups in Calendar view

Used for prompting in CAL_RUN_DTL. Selects Pay Groups from Calendar table where the calendar has not previously been associated with a Calendar Group

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 AND NOT EXISTS ( SELECT 1 FROM PS_GP_CAL_RUN_DTL D , PS_GP_CAL_RUN E WHERE D.GP_PAYGROUP = CAL.GP_PAYGROUP AND D.CAL_ID = CAL.CAL_ID AND E.CAL_RUN_ID = D.CAL_RUN_ID AND E.USE_AS_TMPLT_IND <> 'Y'))

  • Related Language Record: GP_CAL_PYGRP_LV

  • Parent Record Of GP_CAL_PYGRP_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    2 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

    Prompt Table: %GP_EDIT_FLD2

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description