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 E.EMPLID ,E.EMPL_RCD ,B.DEDCD ,B.LANGUAGE_CD ,B.DESCR ,B.DESCRSHORT ,E.COMPANY FROM PS_GDED_COM_DEF A , PS_DEDUCTION_LANG B , PS_JOB_EMPLRCD_VW E WHERE A.DEDCD= B.DEDCD AND E.COMPANY = A.COMPANY 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

    Prompt Table: DED_TBL_GNL_VW2

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 COMPANY Character(3) VARCHAR2(3) NOT NULL Company