GP_PYGRP5_VW

(SQL View)
 Index Back

Paygroups in a identified Run

View of Paygroups that are found in a run that has been identified

SELECT DISTINCT PG.GP_PAYGROUP , PG.DESCR , PG.DESCRSHORT FROM PS_GP_PYGRP PG , PS_GP_CAL_RUN_DTL CRD WHERE PG.GP_PAYGROUP = CRD.GP_PAYGROUP AND CRD.CAL_RUN_ID IN ( SELECT CAL_RUN_ID FROM PS_GP_CAL_RUN_STRM WHERE STRM_IDNT_IND='Y')

  • 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