TAX_YEARCOMPANYEMPLIDCOUNTRYINCOME_CD_104212=Royalties
15=Scholarship/Fellowship Grants
16=Independent Personal Services
17=Dependent Personal Services
18=Teaching
19=Studying and Training
50=Other Income
TAX_RTR_TAX951LD(SQL Table) |
Index Back |
|---|---|
YE 1042S work recordYE 1042S work record - for 1042-S Loading |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TAX_YEAR |
Signed Number(5,0) | DECIMAL(4) NOT NULL | Tax Year |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 5 | INCOME_CD_1042 |
Character(2) | VARCHAR2(2) NOT NULL |
Income Code (for 1042-S)
12=Royalties 15=Scholarship/Fellowship Grants 16=Independent Personal Services 17=Dependent Personal Services 18=Teaching 19=Studying and Training 50=Other Income |
| 6 | TAX_RT |
Signed Number(12,10) | DECIMAL(10,10) NOT NULL | Tax Rate (after form) |
| 7 | PY_FORM_ID | Number(10,0) | DECIMAL(10) NOT NULL | 1042S Unique Form Identifier |
| 8 | 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. |
| 9 | PY_NEW_FORM | Character(1) | VARCHAR2(1) NOT NULL | New Form ID |