GDED_COMNLD_LNG

(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.LANGUAGE_CD ,B.DESCR ,B.DESCRSHORT FROM PS_GDED_COM_DEF A , PS_DEDUCTION_LANG B WHERE A.DEDCD= B.DEDCD 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 for GDED_COMDEF_NLD

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description