GP_PYENT1_VL

(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 B.COUNTRY , A.PAY_ENTITY , A.LANGUAGE_CD , A.DESCR FROM PS_GP_PYENT_LANG A , PS_GP_PYENT B WHERE A.PAY_ENTITY=B.PAY_ENTITY

  • Related Language Record for GP_PYENT1_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description