GP_CAL_PGRP2_VW

(SQL View)
 Index Back

Paygroups in Calendar view

Used for prompting in PI BULK SSN. Selects Pay Groups from Calendar table.

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

    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