EXM_CD_1042_VW (SQL View)	Index Back
1042-S Exemption Code Table This record is used to store long and short descriptions of 1042-S exemption codes.

EXM_CD_1042_VW

(SQL View)

1042-S Exemption Code Table

This record is used to store long and short descriptions of 1042-S exemption codes.

SELECT EXEMPT_CD_1042 , EFFDT , EFF_STATUS , NRA_DESCR , NRA_DESCRSHORT , IRS_EXEMPT_CD_1042 FROM PS_EXM_CD_1042_TBL

Related Language Record: EXM_CD_1042_VLN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

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

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 NRA_DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 NRA_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

6 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	NRA_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	NRA_DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	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.