| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TAX_YEAR |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Tax Year
|
| 2 |
PY_FORM_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
1042S Unique Form Identifier
|
| 3 |
PY_AMEND_NO |
Number(2,0) |
SMALLINT NOT NULL |
1042S Amendment Number
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
PY_EE_SEQ_NO |
Number(2,0) |
SMALLINT NOT NULL |
1042S Employee Information Sequence No
|
| 6 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 7 |
TRANSMITTER |
Character(3) |
VARCHAR2(3) NOT NULL |
Transmitter
Prompt Table:
COMPANY_TBL
|
| 8 |
TXGRS_1042_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross (1042) YTD
|
| 9 |
WH_ALLOW_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Withholding Allowance YTD
|
| 10 |
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
|
| 11 |
TAX_1042_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) YTD
|
| 12 |
TAX1042_REFUND |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) Reimbursed
|
| 13 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 14 |
EMPLOYER_ID_SWT |
Character(20) |
VARCHAR2(20) NOT NULL |
Employer ID (SWT).
|
| 15 |
TAX_YTD |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Tax YTD
|
| 16 |
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.
|
| 17 |
PY_FILE_NO |
Number(3,0) |
SMALLINT NOT NULL |
1042S File Number
|
| 18 |
PY_REVIEW_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Warning Message Exists
Y/N Table Edit
Default Value: N
|
| 19 |
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
|
| 20 |
LAST_UPDT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Updated User Name
|
| 21 |
LAST_UPDT_DTTM |
DateTime(26) |
TIMESTAMP |
Last Updated Date-Time Stamp
|