TREATY_EARN_TBL (SQL Table)	Index Back
Tax Treaty Earnings Table This table contains the 1042S treaty information.

TREATY_EARN_TBL

(SQL Table)

Tax Treaty Earnings Table

This table contains the 1042S treaty information.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

2 TREATY_ID Character(10) VARCHAR2(10) NOT NULL Treaty ID

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 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
Prompt Table: INC_CD_1042_TBL

5 MAX_EARNS_ELIG Number(10,2) DECIMAL(9,2) NOT NULL Max Earnings Eligible Per Year

6 TAX_RT Signed Number(12,10) DECIMAL(10,10) NOT NULL Tax Rate (after form)

7 TAX_RT_NOFORM Signed Number(12,10) DECIMAL(10,10) NOT NULL Tax Rate(before form received)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
2	TREATY_ID	Character(10)	VARCHAR2(10) NOT NULL	Treaty ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	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 Prompt Table: INC_CD_1042_TBL
5	MAX_EARNS_ELIG	Number(10,2)	DECIMAL(9,2) NOT NULL	Max Earnings Eligible Per Year
6	TAX_RT	Signed Number(12,10)	DECIMAL(10,10) NOT NULL	Tax Rate (after form)
7	TAX_RT_NOFORM	Signed Number(12,10)	DECIMAL(10,10) NOT NULL	Tax Rate(before form received)