GVT_DED_DIST_VW

(SQL View)
 Index Back

GVT Gen Ded Dist View

This view is used to selectively review general deductions.

SELECT A.DEDCD ,A.EFFDT ,A.DESCR FROM PS_DEDUCTION_TBL A , PS_GENL_DED_TBL B WHERE A.PLAN_TYPE = '00' AND B.DEDCD = A.DEDCD AND B.EFFDT = ( SELECT MAX (EFFDT) FROM PS_GENL_DED_TBL C WHERE C.DEDCD = B.DEDCD AND C.EFFDT <= %CurrentDateIn)

  • Related Language Record: GVT_DEDW_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description