ERN_PROG_DSCLNG

(SQL View)
 Index Back

Earnings Codes by Ern Pgm Lang

This view lists earnings codes by earnings program for related language.

SELECT A.Ern_Program ,A.EffDt ,A.Erncd ,CL.Language_Cd ,CL.Descr ,CL.Descrshort FROM PS_Ern_Program_Def A, PS_ERN_PROGRAM_TBL B, PS_Earnings_Lang CL WHERE A.Ern_Program = B.Ern_Program AND A.Effdt = B.Effdt AND B.Eff_Status = 'A' AND CL.Erncd = A.Erncd AND CL.EffDt = (SELECT MAX(DL.EffDt) FROM PS_Earnings_Lang DL WHERE DL.Erncd = CL.Erncd AND DL.Language_cd = CL.Language_Cd AND DL.EffDt <= A.EffDt)

  • Related Language Record for ERN_PROG_DESCR

  • Parent record: ERN_PROGRAM_TBL

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

    Default Value: %date

    3 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    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