PY_1042S_REFVW(SQL View) |
Index Back |
|---|---|
1042-S Tax Data View1042-S Tax Data View |
| SELECT A.TAX_YEAR , A.EMPLID , A.COMPANY , A.COUNTRY , A.IRS_INCOME_CD_1042 , A.TAX_RT , T.PY_REVIEW_MSG , A.PY_FORM_ID , A.INCOME_CD_1042 , A.COUNTRY_CD_1042 , A.PY_IN_PROGRESS FROM PS_PY_1042S_XREF A , PS_PY_1042S_YE_TAX T WHERE A.TAX_YEAR = T.TAX_YEAR AND A.PY_FORM_ID = T.PY_FORM_ID AND T.PY_AMEND_NO = ( SELECT MAX(T1.PY_AMEND_NO) FROM PS_PY_1042S_YE_TAX T1 WHERE T1.TAX_YEAR = T.TAX_YEAR AND T1.PY_FORM_ID = T.PY_FORM_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TAX_YEAR |
Signed Number(5,0) | DECIMAL(4) NOT NULL | Tax Year |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
| 3 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: PY_1042S_CM2_VW |
| 4 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 5 | 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.
Prompt Table: PY_IRS_INCCD_VW |
| 6 | TAX_RT |
Signed Number(12,10) | DECIMAL(10,10) NOT NULL | Tax Rate |
| 7 | PY_REVIEW_MSG |
Character(1) | VARCHAR2(1) NOT NULL |
Warning Message Exists
Y/N Table Edit |
| 8 | PY_FORM_ID | Number(10,0) | DECIMAL(10) NOT NULL | 1042S Unique Form Identifier |
| 9 | 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 |
| 10 | COUNTRY_CD_1042 | Character(2) | VARCHAR2(2) NOT NULL | Country Code for 1042 |
| 11 | PY_IN_PROGRESS | Character(1) | VARCHAR2(1) NOT NULL | This field is to indicate if year end data loading is in progress. |