PY_1042S_TAXVW

(SQL View)
 Index Back

1042-S YE Tax View

1042-S YE Tax View

SELECT A.TAX_YEAR , A.EMPLID , A.COMPANY , A.COUNTRY , A.IRS_INCOME_CD_1042 , A.TAX_RT , B.PY_AMEND_NO , B.PY_EE_SEQ_NO , B.TRANSMITTER , B.TXGRS_1042_YTD , B.WH_ALLOW_YTD , B.EXEMPT_CD_1042 , B.TAX_1042_YTD , B.TAX1042_REFUND , B.STATE , B.EMPLOYER_ID_SWT , B.TAX_YTD , B.IRS_EXEMPT_CD_1042 , B.PY_FILE_NO , B.PY_PROC_STATUS , B.LAST_UPDT_OPRID , B.LAST_UPDT_DTTM FROM PS_PY_1042S_XREF A , PS_PY_1042S_YE_TAX B WHERE A.TAX_YEAR = B.TAX_YEAR AND A.PY_FORM_ID = B.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
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
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.
6 TAX_RT Signed Number(12,10) DECIMAL(10,10) NOT NULL Tax Rate (after form)
7 PY_AMEND_NO Number(2,0) SMALLINT NOT NULL 1042S Amendment Number
8 PY_EE_SEQ_NO Number(2,0) SMALLINT NOT NULL 1042S Employee Information Sequence No
9 TRANSMITTER Character(3) VARCHAR2(3) NOT NULL Transmitter
10 TXGRS_1042_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Taxable Gross (1042) YTD
11 WH_ALLOW_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Withholding Allowance YTD
12 EXEMPT_CD_1042 Character(2) VARCHAR2(2) NOT NULL This field is to store the exemption code associated with the tax 1042 earnings. This exemption code is required on 1042S form.
00=00 - Not Applicable
01=01 - Conn/w U.S. Trade or Busn
02=02 - Internal Revenue Code
03=03 - Non US - Sources
04=04 - Tax Treaty
05=05 - Portfolio Interest
06=06 - QI Prim Withholding Resp.
07=07 - Withholding foreign trust
08=08 - U.S. branch
09=09 - QI represents income
99=99 - Correct Information
13 TAX_1042_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax (1042) YTD
14 TAX1042_REFUND Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax (1042) Reimbursed
15 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: PY_1042S_ST_VW

16 EMPLOYER_ID_SWT Character(20) VARCHAR2(20) NOT NULL Employer ID (SWT).
17 TAX_YTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Tax YTD
18 IRS_EXEMPT_CD_1042 Character(2) VARCHAR2(2) NOT NULL This field is to store the exemption code associated with the tax 1042 earnings. This exemption code is required on 1042S form.

Prompt Table: PY_IRS_EXMCD_VW

19 PY_FILE_NO Number(3,0) SMALLINT NOT NULL 1042S File Number
20 PY_PROC_STATUS Character(1) VARCHAR2(1) NOT NULL Year End 1042S process status
C=Completed
I=Transfer In
L=Initial Load
O=Transfer Out
R=Reset
U=Updated
21 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name
22 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp