SFAERNGSVWILNG

(SQL View)
 Index Back

Interface View - EARNINGS_TBL

Campus Solutions interface view for payroll table EARNINGS_TBL.

SELECT ERNCD , EFFDT , LANGUAGE_CD , DESCR FROM PS_EARNINGS_LANG

  • Related Language Record for SFA_ERNGS_VW_I

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

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description