INC_CD_1042_TBL

(SQL Table)
 Index Back

1042-S Income Code Table

This record is used to store long and short descriptions of 1042-S income codes.

  • Related Language Record: INC_CD_1042_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INCOME_CD_1042 Character(2) VARCHAR2(2) NOT NULL PeopleSoft Income Code
    12=Royalties
    15=Scholarship/Fellowship Grants
    16=Independent Personal Services
    17=Dependent Personal Services
    18=Teaching
    19=Studying and Training
    50=Other Income
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 NRA_DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 NRA_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 IRS_INCOME_CD_1042 Character(2) VARCHAR2(2) NOT NULL This field is to store the income code associated with the tax 1042 earnings. This income code is required on 1042S form.
    7 MAINT_RESPONSBLTY Character(1) VARCHAR2(1) NOT NULL Maintenance Responsibility
    C=Customer
    P=PeopleSoft

    Default Value: P