PY_GENL_DED_VW

(SQL View)
 Index Back

General Deduction view

This view is used to selectively review general deductions.

SELECT DISTINCT A.DEDCD ,A.DESCR FROM PS_DEDUCTION_TBL A WHERE A.PLAN_TYPE='00'

  • Related Language Record: PY_GENL_DED_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description