GP_PYGRP_OPR_VW

(SQL View)
 Index Back

View of PYGRP based on OPR PRF

View of GP PYGRP that limits the user to see PYGRPs for the country of their user profile (unless their profile is for "ALL Countries")

SELECT PG.GP_PAYGROUP ,OP.OPRID ,PG.DESCR ,PE.COUNTRY FROM PS_GP_PYGRP PG , PS_GP_PYENT PE , PS_GP_OPR_RULE_PRF OP WHERE (PG.PAY_ENTITY=PE.PAY_ENTITY AND PE.COUNTRY=OP.COUNTRY) OR (PG.PAY_ENTITY=PE.PAY_ENTITY AND OP.USED_BY='A')

  • Related Language Record: GP_PYGRP_OPR_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country