TL_PAY_SYS_VW

(SQL View)
 Index Back

SELECT A.PAY_SYSTEM ,A.DESCR FROM PS_TL_PAYSYS_TBL A , PS_INSTALLATION B WHERE A.PAY_SYSTEM NOT IN ('NA','GP') OR (A.PAY_SYSTEM = 'NA' AND B.INSTALLED_PAY_NA = 'Y') OR (A.PAY_SYSTEM = 'GP' AND B.INSTALLED_PAY_GBL = 'Y')

  • Related Language Record: TL_PAYSYS_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_SYSTEM Character(4) VARCHAR2(4) NOT NULL Payroll System
    GP=Global Payroll
    NA=Payroll for North America
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description