SPCL_ERN_LNG_VW

(SQL View)
 Index Back

Related Lang - SPCL_EARNS_VW

This view lists earnings codes grouped by special accumulator earnings codes.

SELECT a.erncd_spcl ,b.erncd ,c.language_cd ,c.descr ,c.descrshort FROM ps_earnings_spcl a ,PS_EARNINGS_TBL b ,ps_earnings_lang c WHERE b.erncd = a.erncd AND b.eff_status = 'A' AND a.effdt = b.effdt AND b.effdt = ( SELECT MAX(effdt) FROM PS_EARNINGS_TBL c WHERE c.erncd = b.erncd AND c.eff_status = 'A') AND b.erncd = c.erncd AND b.effdt = c.effdt

  • Related Language Record for SPCL_EARNS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ERNCD_SPCL Character(3) VARCHAR2(3) NOT NULL Special Accumulator Code
    2 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    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