PY_TAX_CLASS_VW

(SQL View)
 Index Back

PeopleSoft U.S. Tax Class

This view contains delivered PeopleSoft tax classes for U.S. Payroll.

SELECT A.TAX_CLASS , A.PY_DESCR30 , A.PY_DESCR10 FROM PS_PY_TAX_CLASS A WHERE (%Substring(A.TAX_CLASS, 1, 1) NOT IN ('0', '1', '2', '3', '4', '5') OR (%Substring(A.TAX_CLASS, 1, 1) IN ('0', '1', '2', '3', '4', '5') AND LENGTH(A.TAX_CLASS) = 1))

  • Related Language Record: PY_TAXCLSVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class
    2 PY_DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
    3 PY_DESCR10 Character(10) VARCHAR2(10) NOT NULL Short Description