ERN_PROG_DESCR2

(SQL View)
 Index Back

Earnings Codes by Ern Pgm Vw 2

This view lists earnings codes by earnings program.

SELECT D.Company ,D.Paygroup ,A.Ern_Program ,A.EffDt ,A.Erncd ,C.Descr ,C.Descrshort FROM PS_PAYGROUP_TBL D, PS_Ern_Program_Def A, PS_Ern_Program_Tbl B, PS_Earnings_Tbl C WHERE D.ERN_PROGRAM = A.ERN_PROGRAM AND A.ERN_PROGRAM = B.ERN_PROGRAM And A.EFFDT = (Select max(A1.EFFDT) from PS_ERN_PROGRAM_DEF A1 Where A1.ERN_PROGRAM = D.ERN_PROGRAM and A1.EFFDT <= D.EFFDT) AND A.Effdt = B.Effdt AND B.Eff_Status = 'A' AND C.Erncd = A.Erncd AND C.EffDt = (SELECT MAX(D.EffDt) FROM PS_Earnings_Tbl D WHERE D.Erncd = C.Erncd AND D.EffDt <= A.EffDt)

  • Related Language Record: ERN_PG_DES2_LNG

  • Parent record: ERN_PROGRAM_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    3 ERN_PROGRAM Character(3) VARCHAR2(3) NOT NULL Earnings Program ID
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description