GP_ED_PYENT_VW

(SQL View)
Index Back

Pay Entity by Country

Use on Payee Assignment By Element when prompting for paygroup.

SELECT COUNTRY , PAY_ENTITY , DESCR FROM PS_GP_PYENT UNION SELECT DISTINCT ' ' , PAY_ENTITY , DESCR FROM PS_GP_PYENT

  • Related Language Record: GP_ED_PYENT_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description