PY_GDEDCOM_LNG

(SQL View)
 Index Back

Genl deductions for a company

This record contains the related language general deduction detail for a company

SELECT DISTINCT A.COMPANY , A.DEDCD , B.LANGUAGE_CD , B.DESCR FROM PS_GDED_COM_DEF A , PS_DEDUCTION_LANG B WHERE A.DEDCD=B.DEDCD AND B.PLAN_TYPE = '00' AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_DEDUCTION_LANG WHERE PLAN_TYPE = B.PLAN_TYPE AND DEDCD = B.DEDCD AND LANGUAGE_CD = B.LANGUAGE_CD)

  • Related Language Record for PY_GDED_COM_VW

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