GPES_NRP_TX8_AD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	GPES_TAX_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
3	EFFDT	Date(10)	DATE	Effective Date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	GPES_MILEAGE_RT	Number(6,2)	DECIMAL(5,2) NOT NULL	Statutory rate for mileage
9	GPES_MAINT_DOM	Number(9,2)	DECIMAL(8,2) NOT NULL	Statutory rate for domestic maintenance
10	GPES_MAINT_INTL	Number(9,2)	DECIMAL(8,2) NOT NULL	Statutory rate for non-domestic maintenance
11	GPES_MAINT_FLG_DOM	Number(9,2)	DECIMAL(8,2) NOT NULL	Domestic flight maintenance
12	GPES_MAINT_FLG_INT	Number(9,2)	DECIMAL(8,2) NOT NULL	International flight maintenance
13	GPES_NIGHT_DOM	Number(9,2)	DECIMAL(8,2) NOT NULL	Statutory rate for domestic night stay
14	GPES_NIGHT_INTL	Number(9,2)	DECIMAL(8,2) NOT NULL	Statutory rate for non-domestic night stay
15	GPES_PIN_BR1_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Pin Num.
16	GPES_PIN_BR2_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Pin Num.
17	GPES_PIN_BR3_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Pin Num.
18	GPES_MAX_DEPNT_AGE	Number(3,0)	SMALLINT NOT NULL	Maximum dependent age
19	GPES_IRNR_PCT	Number(5,2)	DECIMAL(4,2) NOT NULL	Non-resident Withholding
20	GPES_IRNR_EU_PCT	Number(5,2)	DECIMAL(4,2) NOT NULL	European Union Non-resident percentage
21	GPES_IRNR_MAX_INC	Number(11,2)	DECIMAL(10,2) NOT NULL	European Union Non-resident Maximum Exempt Income
22	GPES_IRNR_MAX_PCT	Number(5,2)	DECIMAL(4,2) NOT NULL	European Union Non-resident percentage