GDED_COMDEF_NLD

(SQL View)
 Index Back

Genl ded by company view - NLD

This view contains the general deduction detail for a company used within DEFINE_GENERAL_DATA_(NLD)

SELECT A.COMPANY ,B.DEDCD ,B.DESCR ,B.DESCRSHORT FROM PS_GDED_COM_DEF A , PS_DEDUCTION_TBL B WHERE A.DEDCD= B.DEDCD AND (B.PERMANENCY_NLD = 'P' OR B.PERMANENCY_NLD = 'B') AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_DEDUCTION_TBL WHERE PLAN_TYPE = B.PLAN_TYPE AND DEDCD = B.DEDCD AND EFFDT <= A.EFFDT)

  • Related Language Record: GDED_COMNLD_LNG

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

    Prompt Table: DED_TBL_GNL_VW2

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description