GP_UNFIN_PG_VW

(SQL View)
 Index Back

Unfinalized Calendar(Paygroup)

This view selects Paygroups from calendars that have not yet been finalized.

SELECT DISTINCT A.PAY_ENTITY , A.GP_PAYGROUP , A.DESCR FROM PS_GP_PYGRP A , PS_GP_CALENDAR B , PS_GP_RUN_TYPE C WHERE A.GP_PAYGROUP = B.GP_PAYGROUP AND B.RUN_TYPE = C.RUN_TYPE AND C.CALC_TYPE='P' AND NOT EXISTS ( SELECT 'X' FROM PS_GP_CAL_RUN_DTL A1 WHERE A1.GP_PAYGROUP = B.GP_PAYGROUP AND A1.CAL_ID = B.CAL_ID AND A1.CAL_FINAL_TS IS NOT NULL)

  • Related Language Record: GP_UNFIN_PG_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    2 TRGT_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Pay group to which retro deltas are targeted or forwarded
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description