GP_PYENT_OPR_VW

(SQL View)
 Index Back

View of PYENT based on OPR PRF

View of GP PYENT that limits user to the see PAY ENTITY s for the country of their user profile (unless their profile is for "ALL Countries"

SELECT P.PAY_ENTITY , OP.OPRID , P.DESCR , P.COUNTRY FROM PS_GP_PYENT P , PS_GP_OPR_RULE_PRF OP WHERE P.COUNTRY = OP.COUNTRY OR OP.USED_BY = 'A'

  • Related Language Record: GP_PYENT_OPR_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    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