SFA_ERNGS_VW_I

(SQL View)
Index Back

Interface View - EARNINGS_TBL

Campus Solutions interface view for payroll table EARNINGS_TBL.

SELECT ERNCD , EFFDT , DESCR FROM PS_EARNINGS_TBL

  • Related Language Record: SFAERNGSVWILNG
  • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description