| # |
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 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TAX_TBL
|
| 6 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 7 |
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
|
| 8 |
TAX_RT |
Signed Number(8,6) |
DECIMAL(6,6) NOT NULL |
Tax Rate
(after form)
|
| 9 |
BAL_ADJ_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Balance Adjust Sequence Number
|
| 10 |
DT_ENTERED |
Date(10) |
DATE NOT NULL |
Date Entered
|
| 11 |
BALANCE_QTR |
Number(3,0) |
SMALLINT NOT NULL |
Balances for Quarter
Prompt Table:
BALANCE_ID_QTR
|
| 12 |
BALANCE_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Balances for Period
Prompt Table:
BALANCE_ID_DEF
|
| 13 |
TAX_1042_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) YTD
|
| 14 |
TAX_1042_QTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) QTD
|
| 15 |
TAX_1042_MTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) MTD
|
| 16 |
TAX_1042_YTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) YTD Adjusted
|
| 17 |
TAX_1042_QTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) QTD Adjusted
|
| 18 |
TAX_1042_MTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) MTD Adjusted
|
| 19 |
TAX_1042_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) Adjustment
|
| 20 |
TXGRS_1042_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross (1042) YTD
|
| 21 |
TXGRS_1042_QTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross (1042) QTD
|
| 22 |
TXGRS_1042_MTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross (1042) MTD
|
| 23 |
TXGRS_1042_YTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Grs(1042) YTD Adjusted
|
| 24 |
TXGRS_1042_QTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Grs(1042) QTD Adjusted
|
| 25 |
TXGRS_1042_MTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Grs(1042) MTD Adjusted
|
| 26 |
TXGRS_1042_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Taxable Gross(1042) Adjustment
|
| 27 |
WH_ALLOW_YTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Withholding Allowance YTD
|
| 28 |
WH_ALLOW_QTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Withholding Allowance QTD
|
| 29 |
WH_ALLOW_MTD |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Withholding Allowances MTD
|
| 30 |
WH_ALLOW_YTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WH Allowance YTD Adjusted
|
| 31 |
WH_ALLOW_QTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WH Allowance QTD Adjusted
|
| 32 |
WH_ALLOW_MTD_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WH Allowance MTD Adjusted
|
| 33 |
WH_ALLOW_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
WH Allowance Adjustment
|
| 34 |
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
|
| 35 |
EXEMPT_CD_1042_ADJ |
Character(2) |
VARCHAR2(2) NOT NULL |
Exempt Cd for 1042 Income Adj
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
|
| 36 |
TAX1042_REFUND |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) Reimbursed
|
| 37 |
TAX1042_REFUND_NEW |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) Reimbursed New
|
| 38 |
TAX1042_REFUND_ADJ |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Tax (1042) Reimbursed Adj
|
| 39 |
ADJ_REASON |
Character(50) |
VARCHAR2(50) NOT NULL |
Adjustment Reason
|