| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 3 |
BALANCE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Balance ID
Prompt Table:
BALANCE_ID_TBL
|
| 4 |
BALANCE_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Balances for Year
Prompt Table:
BALANCE_YR_VW
|
| 5 |
BALANCE_QTR |
Number(3,0) |
SMALLINT NOT NULL |
Balances for Quarter
Prompt Table:
BALANCE_ID_QTR
|
| 6 |
BALANCE_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Balances for Period
Prompt Table:
BALANCE_ID_DEF
|
| 7 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TAX_TBL
|
| 8 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 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 |
TAX_RT |
Signed Number(8,6) |
DECIMAL(6,6) NOT NULL |
Tax Rate
(after form)
|
| 11 |
WH_ALLOW_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Withholding Allowance YTD
|
| 12 |
WH_ALLOW_QTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Withholding Allowance QTD
|
| 13 |
WH_ALLOW_MTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Withholding Allowances MTD
|
| 14 |
TXGRS_1042_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross (1042) YTD
|
| 15 |
TXGRS_1042_QTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross (1042) QTD
|
| 16 |
TXGRS_1042_MTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross (1042) MTD
|
| 17 |
TAX_1042_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) YTD
|
| 18 |
TAX_1042_QTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) QTD
|
| 19 |
TAX_1042_MTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) MTD
|
| 20 |
TAX1042_REFUND |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) Reimbursed
|
| 21 |
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
Default Value: 04
|