INC_ERVWNLD_LNG

(SQL View)
Index Back

Inc hourly earnings (I,B)

Incidental earningstypes, only payment type H(ours only).

SELECT A.ERNCD , A.LANGUAGE_CD , A.EFFDT , A.DESCR FROM PS_EARNINGS_LANG A

  • Related Language Record for INC_EARH_VW_NLD INC_EARN_VW_NLD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description