GP_PYENT1_VW

(SQL View)
 Index Back

Pay Entity by Country

Used for prompting on Pay Entity where country is present and available for filtering down to PEs associated with that country

SELECT COUNTRY , PAY_ENTITY , DESCR FROM PS_GP_PYENT

  • Related Language Record: GP_PYENT1_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    2 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description